On 9/9/24 00:53, Thürmann, Andreas wrote:
Hello everyone,
I'm currently trying to establish a connection between PostgreSQL and a
SAP HANA database. Unfortunately, so far without success.
SAP's own ODBC driver works correctly and I can query the HANA database
using an ISQL command. However, I can't establish a connection from
PostgreSQL.
I used the following commands to establish the connection:
CREATE SERVER hana_server
FOREIGN DATA WRAPPER odbc_fdw
OPTIONS (dsn 'SAP_ODBC_DNS');
CREATE FOREIGN TABLE hana_table (
matnr VARCHAR(40)
)
SERVER hana_server
OPTIONS (table 'SAPABAP1.MARA');
CREATE USER MAPPING FOR postgres
SERVER hana_server
OPTIONS (odbc_user 'secret_user', odbc_password 'secret_password');
Can anyone tell me where the error is?
Postgres version?
SAP HANA version?
odbc_fdw version and where did you get it from?
How do you know you are not making a connection?
Have you looked at Postgres log for errors?
andreas.thuermann@xxxxxxxxxxxxxxxx
<mailto:andreas.thuermann@xxxxxxxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
