Skip to Content
avatar image
Former Member

How to create a connection for JSON as source

Hi,

I have created a ODBC connection for JSON source, but i couldn't able to pull the data from it. In Data Foundation it is showing no tables(But data is available at source).

Please find the attached ODBC parameter setup, am i need to add anything in the ODBC parameters?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 17 at 12:57 PM

    Where is the attachment?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 17 at 03:38 PM

    Are you using Generic ODBC? What's the version of BO?

    Did you create the System DSN?

    Check the user name for the BO login.

    Don't see the attachment as well.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18 at 07:55 AM

    Sorry Guys,

    Forgot to attach the snippets,

    I am using Generic ODBC connection and the version of BO is 4.2 SP3. I have tried with System DSN and User DSN as well.

    Please let me know if i need to add any other parameters in ODBC connection properties.

    Thanks

    Guruprasad G

    Add comment
    10|10000 characters needed characters exceeded