Skip to Content

create a datastore using sap bods for db2 via odbc

Hi Everyone,

Thanks in a advance if any one suggest " how to create a data store using sap bods for db2 via odbc".

Thanks & Regards

Murali

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 01, 2016 at 05:31 AM

    Hi Murali,

    Select data store as Database-Database type-DB2,Tick use data source name(DSN) option.

    Refer this too: Connect to IBM DB2 source from BODS or Fetching data from IBM DB2 source


    Capture.JPG (39.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2016 at 01:27 PM

    Hi Murali,

    Create a ODBC DSN in your jobserver and your client (local machine or citrix client) for the DB2 database. Make sure it is a system DSN.

    Now connect to the DSN using ODBC option.

    kind regards

    Raghu

    Add comment
    10|10000 characters needed characters exceeded