public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Thürmann, Andreas <[email protected]>
To: '[email protected]' <[email protected]>
Subject: Re: Connection between PostgreSQL and SAP HANA database
Date: Thu, 10 Oct 2024 08:45:34 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <DEEF3EF111E75A4AA8B1205635F235DC0276A29F32@sud-exc22>
References: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
<DEEF3EF111E75A4AA8B1205635F235DC0276A24515@sud-exc22>
<DEEF3EF111E75A4AA8B1205635F235DC0276A29F32@sud-exc22>
On 10/10/24 02:54, Thürmann, Andreas wrote:
> Please excuse the late reply. I didn't have time to continue working on
> this project.
>
> I still don't get a response to the query. The query continues
> indefinitely and the data output window shows only „Waiting for the
> query to complete...“
>
> In the SAP HANA logs i can’t find any access of my PostgreSQL-query, the
> Microsoft solution works perfectly and is visible in the log.
Are you running this on Windows?
>
> Is it not possible to connect to the SAP HANA database with PostgreSQL
> or are there errors in my setup?
>
> My current expectation of the data stream: PostgreSQL -> odbc_fdw ->
> HDBODBC (SAP-driver) –> SAP HANA database
Does this:
HDBODBC (SAP-driver) –> SAP HANA database
work?
Meaning, does test connection complete successfully.
What are the settings for odbc_fdw and the SAP driver?
>
> But how can I set up the connection between the two ODBC drivers?
>
> Has anyone already implemented a project like this and can tell me how
> to establish the connection to SAP?
>
> > Adrian Klaver ([email protected]
> <mailto:[email protected]>
>
> > <mailto:[email protected]
> <mailto:[email protected]>>) asked:
>
> >
>
> > Postgres version?
>
> >
>
> > PostgreSQL 16 with pgAdmin 16 4.2.2
>
> Have you tried tried this using psql?
>
> > 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
>
> Have you looked at the SAP HANA logs to see if a connection is even
> attempted?
>
> Ron Johnson ([email protected] <mailto:[email protected]>)
> 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 ([email protected]
> <mailto:[email protected]>) 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... <https://www.postgresonline.com/journal/index.php?/archives/409-PostgreSQL-16-64-bit-for-Windows-FDWs...;
>
> 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
>
>
> 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&g... Bewerber <https://jobs.schoenmackers.de/content/Datenschutzerklaerung/?locale=de_DE;.
>
>
> 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: Sabrina Michelbrink, Oliver Zimmermann
> www.schoenmackers.de <http://www.schoenmackers.de/;
>
> <https://www.schoenmackers.de/containershop/;
>
>
--
Adrian Klaver
[email protected]
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], [email protected]
Subject: Re: Connection between PostgreSQL and SAP HANA database
In-Reply-To: <[email protected]>
* 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