Conversion of byte or blob column into Byte( Base64) into BigQuery

[kishetty03]

HI Everyone,

While replicating data from Oracle to BigQuery. The raw/Bytes/Blob columns are  coming in as BYTE(BASE64).

I want the data to be integrated in Byte(Hexadecimal).
I tried using hex function at column level but it doesn't work.
Does Qlik Replicate support inserting data in Byte(hexadecimal) datatype in BigQuery

Thank you in Advance

[Michael_Litz · Accepted solution]

Hi kishetty03,

I am attaching a link to an article that will show how to get an Oracle  CLOB value out of oracle and allow a string function to used on it. In the example I used a replace function, for your use case the Hex() function should work.

https://community.qlik.com/t5/Official-Support-Articles/Transformation-Source-Lookup-CLOB-datatype-l...

For Oracle BLOB you need to add an explicate conversion around the Blob field:
UTL_RAW.CAST_TO_VARCHAR2()

source_lookup(1,'DBO','MyClob','UTL_RAW.CAST_TO_VARCHAR2(MyClob)','MyID=?',$MyID)

So for your Blob fields you will do the same source lookup and add the cast function to the Blob field.

I hope this helps out.

Thanks,
Michael

PREVIEW