Skip to Content
avatar image
Former Member

JSON object datatype in SAP BODS

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 !

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 24, 2017 at 10:27 AM

    Nishtha

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

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 25, 2017 at 06:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2017 at 09:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2017 at 08:35 AM

    Arun,

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

    Thanks a lot !!

    Add comment
    10|10000 characters needed characters exceeded