public inbox for [email protected]  

help / color / mirror / Atom feed

From: 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: Fri, 11 Oct 2024 09:16:30 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <DEEF3EF111E75A4AA8B1205635F235DC0276A2A5EA@sud-exc22>
References: <DEEF3EF111E75A4AA8B1205635F235DC0276A2418F@sud-exc22>
	<DEEF3EF111E75A4AA8B1205635F235DC0276A24515@sud-exc22>
	<DEEF3EF111E75A4AA8B1205635F235DC0276A29F32@sud-exc22>
	<[email protected]>
	<DEEF3EF111E75A4AA8B1205635F235DC0276A2A5EA@sud-exc22>

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
[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