Re: Connection between PostgreSQL and SAP HANA database

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?

> andreas(dot)thuermann(at)schoenmackers(dot)de
> <mailto:andreas(dot)thuermann(at)schoenmackers(dot)de>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com