PostgreSQL ODBC from Data Services 4.2 on Linux

[Former Member]

Hello experts. We are trying to connect our Data Services 4.2 on Linux to a PostgreSQL using ODBC. We are using a PostgreSQL driver downloaded from PostgreSQL site. This Driver is already installed on Linux Box; we can open an ODBC Connection on Linux. Now we are trying to configure DS4.2 to use the DSN (Data Source Name) that we have. Could anybody please be so kind to point me in the right direction? So far this is the configuration we have. Driver Location: Driver=/app/nz/lib64/libnzodbc.so ds_odbc.ini [MY_DSN] Description        = PostgreSQL connection to SNAPDB Driver              = PostgreSQL Database            = my_database_name Servername          = 123.123.123.123 UserName            = My_User_Name Password            = My_Password Port                = 5432 Protocol            = 9.1 ReadOnly            = No RowVersioning      = No ShowSystemTables    = No ConnSettings        =

[former_member187605]

You'll first need to install a Windows version of the driver on the box where you're running DS Designer.

Then create a new data store. Select Database for Datastore Type and ODBC for Database Type. Specify DSN, User Name and Password.

[Former Member]

Hello Dirk, thanks very much for your help.

On the Client side, I mean, on Data Services Designer Computer, which is a Windows 32, we have the Driver Installed, the ODBC DSN ( Data Source Name ) 32 bits, we have the Data Store, everything is in place on Designer. I can see the source system, tables and table rows.

The problem we have is on the server side (job server to be specific), which is a Linux 64 bits with Data Services 4.2 on top of it.

I cannot run the jobs on server because job server is unable to connect to PostgreSQL.

It is important to tell that Linux can connect successfully to PostgreSQL using the DSN.

Data Services is unable to see the DSN.

There are some configurations steps on Linux that we need to do. I’m not sure which configuration steps do I need to follow. As far as I know, I need to set two .ini files and of course I need to previously install the PostgreSQL driver on Linux Box.

So far this is what we have done:

[1] Install PostgreSQL driver on Linux 64Bits

[2] Change odbc.ini

[3] Change ds_odbc.ini

What I would like to understand is, how these files (ds_odbc.ini and odbc.ini) on Linux has to be configured, meaning, what do I need to add on these files.

If you could be so kind to point me in the right direction, that would be awesome.

[former_member187605]

I have never done this for PostgreSQL myself and I know there's nothing about it in the official documentation.

Either you find the solution yourself or contact SAP Support, they might know more.

[Former Member]

Try installing 32 -bit Driver as well at server side and also configure ODBC for 32 bit.

[jessie_wu01]

Hi Jairzinho,

Can you tell me which kind of DSN you used to configure the postgres part.

Thanks,

Jessie