Downloading files using Talend Studio

0 votes

How can I migrate files from an FTP server to another server? I am new to Talend, so can someone suggest which components do I need to use to download them and add them to a Salesforce database.

Apr 11, 2018 in Talend by 93.lynn
• 1,570 points

edited Apr 11, 2018 by 93.lynn 289 views

1 answer to this question.

0 votes

As per my understanding, I think first you need to fetch the files from the FTP server and then insert them into the database.

In order to fetch the files, you will need a tFTPConnection, tFTPFileList, tFTPExists, tFTPGet and tFTPDelete components.

tFTPConnection will help you in establishing the FTP connection. With tFTPFileList, you can iterate over a set of files and with tFileExists, you will be able to check whether your required files exist in the directory or not to avoid any unnecessary errors. The tFTPGet component will help you in retrieving the files from the FTP server based on the specified filemask and tFTPDelete component will clean up the remote directory once your job is done.

After the successful retrieval of the files on your local system, you can insert your files as blobs into your Salesforce database.

image

answered Apr 11, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer
0 votes
1 answer

Using tHiveRow to execute multiple Hive queries in Talend

In order to execute multiple queries, you ...READ MORE

answered Apr 14, 2018 in Talend by misc.edu04
• 1,420 points
838 views
0 votes
1 answer

Using Java Classes in Talend

While working with routines, the very 1st ...READ MORE

answered Apr 14, 2018 in Talend by geek.erkami
• 2,640 points
449 views
0 votes
1 answer

Creating a New Project in Talend Open Studio

Before you switch over to a new ...READ MORE

answered Apr 18, 2018 in Talend by misc.edu04
• 1,420 points
234 views
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points
127 views
0 votes
1 answer

Adding third party libraries into the Talend project

You can add the 3rd party libraries ...READ MORE

answered Apr 9, 2018 in Talend by code.reaper12
• 3,450 points
422 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,640 points
351 views
0 votes
1 answer

Implement Common Logging in Talend

Well, you can try using following 2 ...READ MORE

answered Apr 11, 2018 in Talend by geek.erkami
• 2,640 points
166 views
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,450 points
712 views
0 votes
1 answer