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

kishetty03 — Sat, 04 Feb 2023 11:01:31 GMT

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

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

Michael_Litz — Sat, 04 Feb 2023 23:10:23 GMT

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-limitations-on-string/ta-p/1987353/message-revision/1987353:1

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

topic Conversion of byte or blob column into Byte( Base64) into BigQuery in Qlik Replicate

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

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