Adding a BLOB column to transformation

[fj40wdh]

replication from Oracle to SQL Server 

May 2024 (2024.5.0.511)

I'm trying to add a BLOB column to a table. The table currently has a BLOB column, and I'm trying to move that data from the current column to a newly added column on the target. The newly added column does not exists on the source. I add the column in transformation and put the column in the expression,  but the value does not show up in the new column on the target. I can still get the data to show up in the current column on the table. But I can not get the data to show up in the new column.

Here's the json of the new column, the current column is CLNDR_DATA

"transform_columns": [{
"column_name": "",
"new_column_name": "BIN_CLNDR_DATA",
"action": "ADD",
"new_data_type": "kAR_DATA_TYPE_BLOB",
"computation_expression": $CLNDR_DATA"

[OritA]

Hi, 

In general for LOB columns Replicate performs a separate lookup therefore, the transfomation rule you have to use here is source_lookup to get the requested value and assign it to the new column. 
FYI - the following community article includes additional related information:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Transformation-Source-Lookup-...

Regards,

Orit

[fj40wdh]

Thanks, but how I set my source to accept data enrichment ? We are using Oracle.

]W: Source endpoint does not support data enrichment feature (expression_calc.c:2225)

[fj40wdh]

Sorry about the previous post, I was using logstream, switched that out and got

ORA-00932: inconsistent datatypes: expected CHAR got BLOB [1020436] (oracle_endpoint_unload.c:1752)

The new column is defined as BLOB

source_lookup('1','ADMUSER','CALENDAR','CLNDR_DATA','CLNDR_ID=:1',$CLNDR_ID)