topic Re: Reading multiple file from unix server and dumping all the rows into a table in oracle in Talend Studio

Reading multiple file from unix server and dumping all the rows into a table in oracle

Anonymous — Wed, 13 Sep 2017 18:11:30 GMT

Hi All,

i am trying to design a job where i am retrieving the files from a unix server and need to dump all the rows into a table in oracle.

attached is the screenshot of the error that i am getting. i.e. the tfileinputdelimited is unable to find the path(global variable) of the tfilelist component.

Kindly help.

Thanks

Re: Reading multiple file from unix server and dumping all the rows into a table in oracle

Anonymous — Wed, 13 Sep 2017 18:28:29 GMT

Are you running from localhost? If the server is remote you'll need to deploy to that server (i.e. the file system paths defined in your job represent the file system paths of wherever the job is running from)

Re: Reading multiple file from unix server and dumping all the rows into a table in oracle

cterenzi — Wed, 13 Sep 2017 21:01:30 GMT

That is not a tFileList component; it's a tFTPFileList. You'll need a tFTPGet to retrieve the file before you can operate on it.

Re: Reading multiple file from unix server and dumping all the rows into a table in oracle

Anonymous — Thu, 14 Sep 2017 04:49:21 GMT

Hello,

So far, talend don't support for transferring data by air.

You have to save your files from unix server to local machine(tFTPGet component) firstly and then load all the rows into oracle table.

Best regards

Sabrina

Re: Reading multiple file from unix server and dumping all the rows into a table in oracle

Anonymous — Thu, 14 Sep 2017 15:13:23 GMT

thank you. will apply this one and will get back to you in case I face any issue

Re: Reading multiple file from unix server and dumping all the rows into a table in oracle

Anonymous — Fri, 15 Sep 2017 08:14:18 GMT

Hi,

Feel free to post your issue here.

Best regards

Sabrina