Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export

2025-08-12 Thread Adrian Klaver
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 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

Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export

2025-08-12 Thread Ron Johnson
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 wrote: > Hi Greg, > > Thanks for

Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export

2025-08-12 Thread Ian Huang
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 regar

Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export

2025-08-11 Thread Greg Sabino Mullane
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