topic How to send FTP command using Talend Data Integration in Talend Studio

How to send FTP command using Talend Data Integration

_AnonymousUser — Tue, 19 Nov 2013 21:19:18 GMT

With Talend Data Integration, I can open a connection and send/receive files. How can I send a ftp command other than send/put/rename? The command that I need to send is "QUOTE SITE FILETYPE=SEQ" for our mainframe.
Thank you

Re: How to send FTP command using Talend Data Integration

Anonymous — Wed, 20 Nov 2013 03:15:15 GMT

Hi,
Maybe you are looking for tSystem to call FTP command.
Note: Make sure you have installed FTP application in your computer.
Best regards
Sabrina

Re: How to send FTP command using Talend Data Integration

_AnonymousUser — Thu, 21 Nov 2013 13:38:32 GMT

Sorry I did not make myself more clear. My job has the following components. tFTPConnection opens the ftp channel to the ftp server. tFTPGet gets some files. With my channel open, I now need to send a command to the FTP server. Like a get or put, I need to send "QUOTE SITE FILETYPE=JES" while within the FTP session. How can I do this?
Thanks

Re: How to send FTP command using Talend Data Integration

Anonymous — Fri, 22 Nov 2013 02:53:45 GMT

Hi,
Yes I got your requirement, however, it can not be achieved by tFTPXXX component.
You should use tjava to make connection then run .executeCommand(command) for your FTP command.
Best regards
Sabrina

Re: How to send FTP command using Talend Data Integration

Anonymous — Thu, 03 Dec 2015 09:35:54 GMT

Hai,
How can i get a ftp file from a ftp server into my sql database?