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 12, 2018 in Talend by 93.lynn
• 1,600 points

edited Apr 12, 2018 by 93.lynn 2,288 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

Hope this was what you were looking for. 

Get your Talend certification today to become certified professional.

Thanks.

answered Apr 12, 2018 by code.reaper12
• 3,500 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,450 points
3,767 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,680 points
2,659 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,450 points
2,027 views
0 votes
1 answer

Looping through all the schemas in Talend

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

answered Apr 11, 2018 in Talend by code.reaper12
• 3,500 points
1,767 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,500 points
3,803 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

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

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

Implement Common Logging in Talend

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

answered Apr 12, 2018 in Talend by geek.erkami
• 2,680 points
1,933 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 17, 2018 in Talend by code.reaper12
• 3,500 points
6,065 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP