LKM and Consistent CDC for BLOB and CLOB datatypes

Posted by : Arjun Lagisetty Thursday, January 30, 2014

ODI is big on CDC, but its loading the data with respect to BLOBs and CLOBs datatypes does not work as desired with out of the Box KMs.

Oracle addressed these issues by providing custom LKMs for these complex data types. These KMs handle BLOBs and CLOBs well but, the performance is not acceptable. If you are using low data volume then this is not an issue. If not look into DBlinks or SQl loader for loading high data volume containing BLOBs and
CLOBs

These KMs can be found as a part of Oracle Community Knowledge Module

LKM SQL to Oracle Lob : Description of the KM here
LKM SQL to Oracle (CLOB): Description of the KM here

CLOBs and BLOBs and consistent CDC:

Above KM does not correctly support consistent CDC, so we modified few steps in the KMs for it to play well with consistent CDC.
You can find the modified KM here