public inbox for [email protected]  

help / color / mirror / Atom feed
From: Thürmann, Andreas <[email protected]>
To: '[email protected]' <[email protected]>
Subject: Connection between PostgreSQL and SAP HANA database
Date: Mon, 9 Sep 2024 07:53:37 +0000
Message-ID: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22> (raw)

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

[email protected]<mailto:[email protected]>

________________________________
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/;





Attachments:

  [application/octet-stream] sud_logo2.png (5.9K, 3-sud_logo2.png)
  download

  [application/octet-stream] cshop.png (44.5K, 4-cshop.png)
  download

view thread (9+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Connection between PostgreSQL and SAP HANA database
  In-Reply-To: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox