How to insert CLOB data to Talend

Four Stars

How to insert CLOB data to Talend

Hi,

I need to load data from Oracle table which contains some of the columns having datatype as CLOB. My approach is to use Tmap where user defined Routine can be used to convert CLOB to String. But the main challenge I'm facing is which datatype should be selected in Talend schema for Oracle CLOB and then as per the selected datatype in talend, there is need to write the Routine to convert it to string.

 

Can anyone please suggest, what is the best way to handle the above scenario.

Appreciate your help!!

 

Regards,

Pragya

Community Manager

Re: How to insert CLOB data to Talend

Use the Object class and convert to the appropriate class using Java. Either create a routine to handle your case or do it in a tJavaRow/tJavaFlex

Four Stars

Re: How to insert CLOB data to Talend

Did you solved the problem?. If yes will you please explain how to do it. I have the same requirement.

 

Regards,

Naresh 

Four Stars

Re: How to insert CLOB data to Talend

Hi,

For this, I used SQL query in tOracleInput component in Talend and put STRING datatype in talend for the column having CLOB datatype in Oracle. I know it will truncate the data if it's size exceeds 4000 chars, however followed this approach because I was not able to handle CLOB data in talend using any other datatype.

 

Regards,

Pragya

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now