Is it possible to FTP file download and put database?

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

 

Forteen 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

-----------

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch