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

1 REPLY
Eleven Stars

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

Rilhia Solutions