How to create Oracle CLOB to S3

Four Stars

How to create Oracle CLOB to S3

Hi Gurus


I have requirement to create Oracle CLOB into json file into S3.

I have followed steps as below.

1. Created Oracle input component ( Query has ClOB and File_name) 


2. Created JavaFlex Component  (Code Attached in the Screenshot)


3. CreateFileout(for testing i use local folder) - but i need to send the file to S3 for file_name( file name is from the Query ).


4. if the Oracle 10 rows - need to push 10 files to S3.

Note : S3 connection got established . 


Could you please any one help me on this ?


I am getting error when run the Job.








Re: How to create Oracle CLOB to S3

Hello mani,

When you get some compile errors, please check your "Code" tab in your job. There will be your compile error highlighted in red line.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.



Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.