public inbox for [email protected]help / color / mirror / Atom feed
Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export 4+ messages / 3 participants [nested] [flat]
* Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export @ 2025-08-04 01:47 Ian Huang <[email protected]> 2025-08-11 16:49 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Ian Huang @ 2025-08-04 01:47 UTC (permalink / raw) To: [email protected] 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export 2025-08-04 01:47 Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> @ 2025-08-11 16:49 ` Greg Sabino Mullane <[email protected]> 2025-08-12 00:10 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Greg Sabino Mullane @ 2025-08-11 16:49 UTC (permalink / raw) To: Ian Huang <[email protected]>; +Cc: [email protected] 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.com Enterprise Postgres Software Products & Tech Support ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export 2025-08-04 01:47 Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> 2025-08-11 16:49 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Greg Sabino Mullane <[email protected]> @ 2025-08-12 00:10 ` Ian Huang <[email protected]> 2025-08-12 15:13 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ron Johnson <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Ian Huang @ 2025-08-12 00:10 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: [email protected] 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 <[email protected]> 於 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.com > Enterprise Postgres Software Products & Tech Support > > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export 2025-08-04 01:47 Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> 2025-08-11 16:49 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Greg Sabino Mullane <[email protected]> 2025-08-12 00:10 ` Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> @ 2025-08-12 15:13 ` Ron Johnson <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Ron Johnson @ 2025-08-12 15:13 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> 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 <[email protected]> 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 <[email protected]> 於 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.com >> Enterprise Postgres Software Products & Tech Support >> >> -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-08-12 15:13 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-08-04 01:47 Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export Ian Huang <[email protected]> 2025-08-11 16:49 ` Greg Sabino Mullane <[email protected]> 2025-08-12 00:10 ` Ian Huang <[email protected]> 2025-08-12 15:13 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox