topic Re: How to insert CLOB data to Talend in Talend Studio

How to insert CLOB data to Talend

Anonymous — Sat, 16 Nov 2024 09:10:31 GMT

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

Re: How to insert CLOB data to Talend

Anonymous — Fri, 13 Oct 2017 12:39:02 GMT

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

Re: How to insert CLOB data to Talend

nar — Wed, 10 Jan 2018 04:12:38 GMT

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

Regards,

Naresh

Re: How to insert CLOB data to Talend

Anonymous — Tue, 16 Jan 2018 12:28:24 GMT

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