Five Stars

Is it possible to FTP file download and put database?

first, I want to download remote files (using FTP)

 

and then, put to database in column( CLOB, BLOB...etc)

 

is it possible?

 

I know anything is possible(By modifying the talend source code directly) .

 

But these functions provided formally at talend?

 

Thank you everyone

 

1 REPLY
Ten Stars

Re: Is it possible to FTP file download and put database?

Yes it possible

use tFileInputRaw - read file context as bytes array, and in tDatabaseOutput component use BLOB (or similar)

Screen Shot 2017-07-03 at 9.21.13 PM.pngScreen Shot 2017-07-03 at 9.20.50 PM.png

-----------