Skip to Content

Data Services ODBC Driver Manager unable to find data source in $LINK_DIR/bin/ds_odbc.ini file.

bodsercc.jpgHi all,

I have created a BODS job where my source is PostgreSQL DB and my target is hana,

I have created an ODBC connection and created a new data store in BODS and imported the source table and also completed the development of my job.

But when I am trying to run the job, I am getting the following error and I am unable to proceed with the ETL job.

Kindly help me in finding the silution.

bodsercc.jpg (39.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    May 30, 2018 at 07:14 AM

    That's because you don't have the ODBC connection on the DS server box.

    You must create exactly the same connection on both your DS client (where you develop in DS Designer) and DS server (where your DS jobs run).

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2018 at 06:35 AM

    kaushik goli

    Please answer below

    What is the version of Data Services installed?

    What is the PostgreSQL driver version and have you downloaded from PostgreSQL Site?

    Is your Job server installed on Unix Server? If yes what is the version of Unix/Linux

    Have you installed the Windows version of PostgreSQL driver on your Client machine where Data Service Client is installed?

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 11:22 PM

    Note that Postgres isnt officially supported in the DS PAM but you can upvote the idea on the customer influence page to get visibility to it.

    https://influence.sap.com/sap/ino/#/idea/201753

    Add comment
    10|10000 characters needed characters exceeded