Talend: Read CLOB data from Oracle DB

Scenario: Using Talend, read the JSON data stored in Oracle table as CLOB column.

Components used for demonstration:

TOracleInputDelimited: used for reading Oracle data

TLogRow: used for displaying the data on the screen

Configuration:

In TOracleinputDelimited 'Edit Schema', set the Type to 'Dynamic' and DBtype to 'NVARCHAR2' for the incoming CLOB column.

This will convert the incoming CLOB data to string format which later can be used in downstream components like TExtractJsonField.

Posted in: ETL, JSON, Talend