Feedback-ID: i76984098:Fastmail
Message-ID: <3cb13eb6-b1fb-4b83-bab5-b03c159b8238@aklaver.com>
Date: Mon, 9 Sep 2024 08:06:39 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Connection between PostgreSQL and SAP HANA database
To: =?UTF-8?Q?Th=C3=BCrmann=2C_Andreas?=
 <Andreas.Thuermann@schoenmackers.de>,
 "'pgsql-general@lists.postgresql.org'" <pgsql-general@lists.postgresql.org>
References: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/3cb13eb6-b1fb-4b83-bab5-b03c159b8238%40aklaver.com>
Precedence: bulk

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.thuermann@schoenmackers.de 
> <mailto:andreas.thuermann@schoenmackers.de>

-- 
Adrian Klaver
adrian.klaver@aklaver.com