topic Re: Adding a BLOB column to transformation in Qlik Replicate

Adding a BLOB column to transformation

fj40wdh — Wed, 12 Mar 2025 18:21:29 GMT

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"

Re: Adding a BLOB column to transformation

OritA — Thu, 13 Mar 2025 08:51:20 GMT

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-CLOB-datatype/ta-p/1987353

Regards,

Orit

Re: Adding a BLOB column to transformation

fj40wdh — Thu, 13 Mar 2025 10:28:20 GMT

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)

Re: Adding a BLOB column to transformation

fj40wdh — Thu, 13 Mar 2025 10:49:11 GMT

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)