|
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?
Mit freundlichen Grüßen
i. A. Andreas Thürmann Teamleitung IT-Applikationen & BI IT-Applikationen & BI
|
