Sap dataservice: How to convert blob to varchar in BODS

[Former Member]

Hi all

I have source column with blob datatype. Actually this columns stores long string. I want to ETL to target columns with varchar(3000)

How can I transform data?

Thank you!

[mageshwaran_subramanian]

There are limitations in Data Services to achieve BLOB to VARCHAR conversion . Refer 4.1.7 Limitations for long and blob , in reference guide.

What data do you have in BLOB?

If it is text and stored in oracle , do the conversion in Oracle DB itself and import the table/view into Data Services.

[Former Member]

thanks for your reply

data in blob columns is fund transfer message, I have used convert func blob to varchar in OraDB, but it's limited length

[former_member198401]

Tony,

Can you try using the long_to_varchar() function in Data Services to convert the long column to varchar

Regards

Arun Sasi

[Former Member]

Arun sasi,

I already try using long_to_varchar() func. It works well with CLOB but BLOB I still get error cannot convert

[former_member190674]

Hi Tony,

Blob fields generally holds data in binary/raw format. These are the fields that are not supposed to change while migrating from one system to another. Even if you convert to varchar, it would fail while you load it to a blob/raw data type in target system.

Regards

Santhosh