Re: Connection between PostgreSQL and SAP HANA database

On 10/11/24 01:23, Thürmann, Andreas wrote:

Please do not post. The convention on this list is to inline or bottom
post. That makes it easier to follow the conversation flow.

See:
https://en.wikipedia.org/wiki/Posting_style

> Yes I run it under Windows, I also have a Linux server for testing.
> Under Windows I know that the driver works because i use it already in another project (MS SQL Server with LinkedServer).
> In Linux I can test the HDBODBC driver via command line and the ISQL command, this works fine.

Works fine as in you can connect to the SAP HANA database with the
HDBODBC driver?

>
> I'm desperate about the PostgreSQL configuration. I have no idea how to configure it. I doubt the path (HDBODBC (SAP-driver) –> SAP HANA database) myself, but i cant connect to the HDBODBC driver directly via an extension.
What are the settings/commands you are using for the various parts of
this connection chain:

1) HDBODBC driver.

2) ISQL command.

3) odbc_fdw.

4) Foreign server creation statements.

> My previous assumption was that i need a extension for the foreign data wrapper, the foreign server, foreign table and so on...

Yeah that is shown here:

https://github.com/CartoDB/odbc_fdw

In the Example section.

>
> How can I use the system dsn in PostgreSQL?
>
>

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