Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szIJh-005JSo-ED for pgsql-general@arkaria.postgresql.org; Fri, 11 Oct 2024 16:16:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1szIJf-007Ewu-QA for pgsql-general@arkaria.postgresql.org; Fri, 11 Oct 2024 16:16:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szIJf-007Eo7-F1 for pgsql-general@lists.postgresql.org; Fri, 11 Oct 2024 16:16:35 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szIJd-000OHu-23 for pgsql-general@lists.postgresql.org; Fri, 11 Oct 2024 16:16:34 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfout.phl.internal (Postfix) with ESMTP id 141AE13801C5; Fri, 11 Oct 2024 12:16:32 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Fri, 11 Oct 2024 12:16:32 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1728663392; x=1728749792; bh=Qg1T0aZWQVsFVmO0cGTS+PgRo43aA8oJWX47p//ZBwg=; b= RU2jd6tvQinNa0ZRd8E+wUjjjDAGcRXbcL3be/C8h7O4SWWtL0qBsz1lrXRfhyC9 1jomHv0PAJr8fEJg4W9VQBP4UjcI/V9qUQGGc5AlvmZufDOC3WykE0Jx8SiisFqh jKkrEwd8BJdUuE/7obQ/mi8U3I0pMAikQSKm0lbEcoH/FVCNCln9LCEUNerZGDCz xpcKDsAu/vSa/6OgALpeRXcO39hm/K1i3iTkfserhnHFa2c/X1aRKr8k7UXYeW/6 z4prNX4/RycL1/0K6zYXy9u2xa2Gh1W7WCYXyV0BKQ2oXjBFz0I2M9lOY3bkBxb2 fdv9sY+u5osgvFdyefkAdQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1728663392; x= 1728749792; bh=Qg1T0aZWQVsFVmO0cGTS+PgRo43aA8oJWX47p//ZBwg=; b=l zGKcHXv5gFhvtxHb/edhp1/cWw2+ziIpDjPCAGL0QTyNWTU4DcpUM4PjUeib1pXd ScFnz57RKhD6uSHzMadtOMPaePIwQs1zBVZQnziIh6vFfErTA39mAT0wRy5niuxr A4JVR69gEFujWse1c5Ybgf9OGkV5PfInZk5RECnmps+RcB9IvkNVvOaWMIh6Fy08 BsB+ZmRK8i6QHRLtbdC2PYIcoD4ZsH6mKBOjAJk3MfLTSywuRwlpubgAxkcelovn Naq2CI3aF4mYVwPYPRiersIcV6DumKsam4Nesc6sZMX7KDhvhDkFrcn8FtDXJ0Lh 9UpxnsnJrIaF0QszbxbYQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdefkedgleekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfg fuvfhfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghr uceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrth htvghrnheptdffvdejfeettdekfefghfeitdehteevkefhgfelueejudduleffveetgfff feeunecuffhomhgrihhnpeifihhkihhpvgguihgrrdhorhhgpdhgihhthhhusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughr ihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpd hmohguvgepshhmthhpohhuthdprhgtphhtthhopegrnhgurhgvrghsrdhthhhuvghrmhgr nhhnsehstghhohgvnhhmrggtkhgvrhhsrdguvgdprhgtphhtthhopehpghhsqhhlqdhgvg hnvghrrghlsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 11 Oct 2024 12:16:30 -0400 (EDT) Message-ID: <2678e457-fe4d-44a7-a74a-4a2c51027097@aklaver.com> Date: Fri, 11 Oct 2024 09:16:30 -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?= , "'pgsql-general@lists.postgresql.org'" References: <8023c908-bf4a-4e04-a0a3-2ce5cfebe9b2@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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@aklaver.com