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.