Skip to Content
0

JSON object datatype in SAP BODS

Jan 23, 2017 at 01:37 PM

117

avatar image
Former Member

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 !

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Arun Sasi Jan 24, 2017 at 10:27 AM
0

Nishtha

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

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 25, 2017 at 06:58 AM
0

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


error-1.jpeg (62.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jan 25, 2017 at 09:01 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 07, 2017 at 08:35 AM
0

Arun,

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

Thanks a lot !!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Excellent!! :)

Regards

Arun Sasi

0