Skip to Content

HANA to-from Postgresql Connection

Hello Experts

We wanted to establish a two way connection from HANA DB to Postgresql DB.

Reviewed many blogs etc., and figured out these are the steps to be performed:

1. Install unixODBC drivers and hdbclient on Postgresql server, edited the odbc.ini file and was able to query the HANA DB from isql command.

- How do I query the HANA DB from psql command ?

2. Next to install the postgresql-odbc drivers on HANA Server, where I am having issue making the Make file for installation. But was able to get couple of library files & But still not able to use psql command from HANA server command line.

3. Edited the .odbc.ini file in /usr/sap/SID/home and given the Postgresql details with driver path as /usr/local/lib/

Added new Remote Sources in HANA Studio as GENERIC_ODBC connection with DSN & path as /usr/sap/SID/home/.odbc.ini. When trying to open and test connection from HANA Studio to Postgresql it is throwing up below error:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP][ODBC Driver Manager] Data source not found and no default driver specified

Can anyone advise is this is correct approach I am following to have the connection established ?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 23, 2015 at 08:32 PM

    Ok, so you have been able to query HANA from your PostgreSQL server via ODBC/isql.

    You haven't been able to do it the other way around as it seems.

    And consequentially you haven't been able to access the PostgreSQL db via SDA (via ODBC).

    Sounds to me as if there's an issue with the PostgreSQL client installation or setup. I'd try to check the appropriate PostgreSQL forums on that.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.