From: | Thürmann, Andreas <Andreas(dot)Thuermann(at)schoenmackers(dot)de> |
---|---|
To: | "'pgsql-general(at)lists(dot)postgresql(dot)org'" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Connection between PostgreSQL and SAP HANA database |
Date: | 2024-09-09 15:35:06 |
Message-ID: | DEEF3EF111E75A4AA8B1205635F235DC0276A24515@sud-exc22 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ron Johnson (ronljohnsonjr(at)gmail(dot)com<mailto:ronljohnsonjr(at)gmail(dot)com>) 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(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>) 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
Schönmackers Umweltdienste GmbH & Co. KG
Hooghe Weg 1
47906 Kempen Tel:
Fax:
E-Mail:
+49 (2152) 207 6765
andreas(dot)thuermann(at)schoenmackers(dot)de<mailto:andreas(dot)thuermann(at)schoenmackers(dot)de>
________________________________
Unsere aktuellen Datenschutzhinweise gemäß Artikel 13 DSGVO finden Sie hier: Kunden <https://www.schoenmackers.de/wp-content/uploads/2018/05/Datenschutzerklaerung-DSGVO_Kundeninfo.pdf> / Bewerber <https://jobs.schoenmackers.de/content/Datenschutzerklaerung/?locale=de_DE> .
[cid:sud_logo2.png]
Schönmackers Umweltdienste GmbH & Co. KG, Hooghe Weg 1, 47906 Kempen, Sitz: Kempen, Amtsgericht Krefeld, HRA 3763,
p.h.G.: Schönmackers Umweltdienste Verwaltung GmbH, Sitz: Kempen, Amtsgericht Krefeld, HRB 6153,
Geschäftsführer: Oliver Zimmermann
www.schoenmackers.de <http://www.schoenmackers.de/>
[cid:cshop.png]<https://www.schoenmackers.de/containershop/>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-09-09 15:40:00 | Re: postgresql FDW vs dblink for DDL |
Previous Message | Greg Sabino Mullane | 2024-09-09 15:33:21 | Re: How effectively do the indexing in postgres in such cases |