Search Postgresql Archives

Re: Connection between PostgreSQL and SAP HANA database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux