|
Ron Johnson (ronljohnsonjr@xxxxxxxxx) asked me the following. Answers below: 1. What error did you get? No error, the query runns into infinity (>30 min.) without a result. 2. Which command caused the error? Test-query like SELECT * FROM hana_table LIMIT 10; 3. What version of the odbc_fdw are you using? Latest, Version 0.5.2 4. What version of Postgresql are you using? PostgreSQL 16 with pgAdmin 16 4.2.2 Adrian Klaver (adrian.klaver@xxxxxxxxxxx) asked: Postgres version? PostgreSQL 16 with pgAdmin 16 4.2.2 SAP HANA version? SAP HANA database 2.00.07400
odbc_fdw version and where did you get it from? I use the odbc_fdw from
https://www.postgresonline.com/journal/index.php?/archives/409-PostgreSQL-16-64-bit-for-Windows-FDWs.html How do you know you are not making a connection? No results from the query, no suggestions in the foreign table creation menu Have you looked at Postgres log for errors? No errors during the query in the log, only a „unrecognized winsock error 10054“ at the start of the pg client 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
|
