Mirror SAP internal data to an external system

We would like to mirror data which is inside SAP to an external database.

Up to now there is a script which exports the data every night.

The customer wants this to happen more often. It should happen every hour.

The export is quite big, and we search for a better way to mirror data which is inside SAP to an external database.

Based on the tag, I assume that your external database is a PostgreSQL database. In this case, I don't think you will really find a pure SAP, database independent solution.

The standard solution for this sort of replication is the SAP SLT Server. It supports taking data out of your SAP system to either a SAP target or a non-SAP target. Currently it supports the following non-SAP targets:

• DB2
• SAP MaxDB
• Microsoft SQL Server
• Oracle
• Sybase ASE

As you can see, PostgreSQL is not included in there (yet). In conclusion, I see the following possibilities:

• Use SLT in combination with some other external DB that is supported.
• Use a third party replication tool like for example SymmetricDS.
• Depending on your source database, you might be able to use some database specific tools (e.g. SAP HANA Smart Data Integration).
• Write some custom code for doing it. In my opinion, you should try to build a sort of log table in this case, to record (using maybe triggers) which rows were inserted / updated / deleted since the last replication. IMO, this should be really a last resort, as database replication is a fairly common topic and you should not reinvent the wheel.