Обсуждение: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
Dear PostgreSQL Community Team,
I hope this message finds you well.
I’m currently exploring options for implementing a staging (intermediate) database to handle outbound data exports from an SAP ERP system. I would like to inquire whether PostgreSQL is considered a suitable and stable solution for this purpose, particularly in terms of performance, data integrity, and compatibility with SAP or third-party middleware.
Specifically, I’m interested in the following:
Any known use cases or best practices of using PostgreSQL in SAP ERP data pipelines.
Recommendations or considerations for integrating PostgreSQL in such a scenario.
Whether there are any limitations or concerns regarding this architecture.
I would greatly appreciate it if you could direct me to any relevant documentation, user groups, or case studies that could help.
Thank you for your time and support.
Best regards,
Ian Huang.
Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
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
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--Crunchy Data - https://www.crunchydata.comEnterprise Postgres Software Products & Tech Support
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,
IanGreg 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--Crunchy Data - https://www.crunchydata.comEnterprise Postgres Software Products & Tech Support
On 8/12/25 08:13, Ron Johnson wrote: > This link says that there's an ADBC driver for Postgresql: https:// > arrow.apache.org/adbc/current/driver/status.html <https:// > arrow.apache.org/adbc/current/driver/status.html> I believe that is a different beast. See: https://help.sap.com/doc/abapdocu_753_index_htm/7.53/en-US/abenadbc.htm https://www.linkedin.com/posts/ruhanigarg_what-is-adbc-in-abap-adbc-stands-for-abap-activity-7223583205814157315-wQTg > > You should probably research _IT_ and SAP as to why your SAP > installation does not have the PG driver. > -- Adrian Klaver adrian.klaver@aklaver.com