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 psqlodbcw.so & psqlodbcw.la. 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/psqlodbcw.so
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: : 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 ?
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.