Skip to Content
Jan 06, 2017 at 03:44 PM

Unsupported datatype in data services crashes DS


bods3.pngbods1.pngbods2.pngWe have requirement where we need to extract data from system which resides on a Oracle database and one of the table in has 2 columns which has custom datatype.

We are using SAP BODS to load data into HANA and have followed the below steps

1. Created the datastore for Source system.
2. Selected the option for “Importing Unsupported datatypes” , only with this option we are able to see the field which has custom datatype

3. We were successful in bringing the metadata of table.

4. When we try to do a data preview on this table to see the data, it crashes the DS client.
5. We also tried to create job with dataflow with simple query transformation 1:1 mapping and target template table was HANA, but when we ran the job it throws error.

The data in table in below format. Please see attached file.


bods2.png (42.2 kB)
bods3.png (10.3 kB)
bods1.png (29.3 kB)