Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export - Mailing list pgsql-general

From Ron Johnson
Subject Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
Date
Msg-id CANzqJaCw+M53Om-VyZjwAN0khqXmYoDbUvAe181XB=8yTfp_tw@mail.gmail.com
Whole thread Raw
In response to Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export  (Ian Huang <iancl32ul3@gmail.com>)
Responses Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
List pgsql-general
This link says that there's an ADBC driver for Postgresql: https://arrow.apache.org/adbc/current/driver/status.html

You should probably research _IT_ and SAP as to why your SAP installation does not have the PG driver.

On Tue, Aug 12, 2025 at 10:36 AM Ian Huang <iancl32ul3@gmail.com> wrote:

Hi Greg,

Thanks for your feedback.
I’ve tried connecting to PostgreSQL using the ADBC method, but unfortunately the SAP Kernel doesn’t have the corresponding .os (DBMS) file, so the connection could not be established.
May I ask if connecting via ADBC is actually feasible in this case?

Best regards,
Ian


Greg Sabino Mullane <htamfids@gmail.com> 於 2025年8月12日 週二 上午12:50寫道:
That's a little too vague of a question, but yes, Postgres should be able to handle things just fine. The amount of SAP tools and SAP-supporting ETL tools that also support Postgres should be a strong encouragement. I'd recommend looking at the specific tools you would use and confirming they have Postgres support built in. Then try and find use cases / complaints for those specific items.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support



--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Bitnami deprecation
Next
From: Adrian Klaver
Date:
Subject: Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export