Five Stars

How to deal with flat file downloads in Integration Cloud?

Hi folks,

 

We just purchased Talend Integration Cloud and I am working to migrate a job I've created in regular studio on my PC and then ran using Windows Scheduler.

 

The job imported a .csv file from an SFTP server, deposited it into a folder on the PC, then did work on it, and uploaded it elsewhere.

 

But when I host a job on Integration Cloud, there is no folder for me to download to, and I can't access my flat files without downloading them first to a location it seems.

 

I know this must be basic for many, but what should I do?

1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars

Re: How to deal with flat file downloads in Integration Cloud?

Shong,

 

I was able to resolve this using an answer you gave to another question.

 

Thank you.

3 REPLIES
Community Manager

Re: How to deal with flat file downloads in Integration Cloud?

Hi
You can download it to location on server , such as "/tmp/" , and delete the file in the end of job, check the file if it exists and delete it.

tpostJob--oncomponentok-->tFileExist--runif--tFileDelete

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: How to deal with flat file downloads in Integration Cloud?

Hi Shong,

 

So I went to try this out by going to my local job and changing the local directory from "C:/xxxx/yyy.csv" to "/tmp/yyy.csv" in the tFTPGet, and all subsequent components.

 

But I got the error that "The system cannot find the file specified".

 

Am I using the wrong component?

 

 

Five Stars

Re: How to deal with flat file downloads in Integration Cloud?

Shong,

 

I was able to resolve this using an answer you gave to another question.

 

Thank you.