How to deal with flat file downloads in Integration Cloud?

Six 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?


Accepted Solutions
Six 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.


All 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
Six 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?

 

 

Six 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.