Is there any similar alternatives to this via pins ? Is there a general name for this kind of connector that I can google on?
Or probably there is a tool for producing this kind of tapered pins from a regular wire?
Despite the attraction of getting boards done fairly cheaply, I still like to do things on stripboard and these "via pins" still have a use. Harwin don't do them any more, but Vero in the UK still do a lot of different pins at reasonable prices and have stock of most on 07 Nov 2015.
One of the uses I put them to, is mounting SMD's on the non-track side of a single sided board - very useful for things like PSU sockets that are sometimes only available in SMD form.
These are known as via or pcb Rivets. Some are hollow tubes, others are solid wire, and some are shaped. You can find them in a variety of finishes.
You probably won't find a tool to make cone shaped tapered ones like you pictured, but you can make simple ones with some wire and hammer. See: https://paulwanamaker.wordpress.com/300-2/ Standard riveting method applies here as it would armor or metal fabricated PC enclosures.