Hi ! We are studying differents solution to manage our file transfers. We would like to use standards (sftp for example). We would like to manage with this server : - a server A send a file to a server B - server A send a file to server B, C, D etc ... - a server A, C, D etc ... send a file to a server B Is an ETL a good idea to do that ? Tanks
Dear Merlin Der Koenig, Filetransfer is one diferent part of ETL, but, it has to be tightly coupled with one ETL process. I suggest that you use o Q-Ware for file´s transfer.
Q-Ware do filetransfers with next features: - Data Compression. - Data Cryptografy. - Check-point and restart after stops, without any byte to be lost. - Run command after and before each file transfered, in both sides . - Run command if something is wrong. - Is 2 times more fast that SFTP, FTP, OFTP. - Supports for Muli-languages. - Store Histories for each transaction (file processed). - Store Logs of operations with grained controler. - Use Operation System mechanisms for to do autentication, * i.e., don´t have to maintain another password file - Do integration with ETL process made with JasperETL. - And make many other things more. Try it on site www.pix.com.br. Best Regards Anderson.