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: Mon, 9 Sep 2024 08:06:39 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
References: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
On 9/9/24 00:53, Thürmann, Andreas wrote:
> 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?
Postgres version?
SAP HANA version?
odbc_fdw version and where did you get it from?
How do you know you are not making a connection?
Have you looked at Postgres log for errors?
> [email protected]
> <mailto:[email protected]>
--
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