cancel
Showing results for 
Search instead for 
Did you mean: 

JSON object datatype in SAP BODS

Former Member
0 Kudos

I have a source table in POSTGRES having one JSON column.When i am fetching this column in BODS it is automatically taking it as varchar().But Varchar of this size is not supported by BODS.

Please suggest what can be solve this issue.

Thanks in Advance !

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Arun,

I am able to fetch this table now in HANA using this approach.

Thanks a lot !!

former_member198401
Active Contributor
0 Kudos

Excellent!! 🙂

Regards

Arun Sasi

former_member198401
Active Contributor
0 Kudos

Nishtha,

Can you try doing a select on the POSTGRES table column which has JSON datatype using a SQL transform and then output it to a Target table.

Try changing the datatype of the JSON object to LONG in the Query transform

SQL Transform>Query Transform(Change the datatype of JSON column to LONG)>Target Table

Regards

Arun Sasi

Former Member
0 Kudos

Hi

Thanks for the reply !

I changed the DS settings as suggested by you and then ran my job.But facing below attached error while running it.

Please help.

error-1.jpeg

former_member198401
Active Contributor
0 Kudos

Nishtha

Can you try checking the option Import unsupported data types as VARCHAR of size and then run the job

Regards

Arun Sasi