How do I read all files from an FTP site, merge them into one dataset and write to a database.

Hi @hzassypk​ this is kind of a broad question, do all of your shapefiles have the same schema? If this is the case, you may not need any transformers and simply read them all in and write them out to one file. For reading from FTP here is a good article on working with the FTPCaller: Upload a File to the Safe Software Support FTP

Let us know if you have any specific questions!