Skip to Content
0
May 19, 2016 at 11:03 AM

Support of BLOB datatype in Data Services

1337 Views

Hello All,

We use SAP HANA as the staging database and also our SAP CRM schema sits on the same HANA database. Till date I have been reading SAP CRM specific tables by connecting to the SAP datastore and reading the tables through RFC. But now I would like to read the same table directly from SAP CRM schema of HANA.

In this standard CRM table, we have a field which holds the value of a GUID. It's datatype is RAW in SAP. However when I use this table as source in Data Services, GUID field datatype is shown as BLOB and I would like to store this data as varchar into a template table.

Job fails because I cannot convert BLOB to VARCHAR. Infact I cannot use BLOB field as a parameter in any function of Data Services.

Please let me know if there is any 100% working solution to store BLOB datatypes as varchar?

Thanks,

San