Skip to Content
avatar image
Former Member

Data Mirroring/Replication/changes between SAP and SQL Server through PO/PI

My requirement is to replicate the data changes(Insert/Update/Delete) of few SAP tables to SQL server through PO/PI and vice versa. (almost real time/ frequency 1 or 2 minutes)

I know JDBC adapter is one option to connect to SQL server.

Following are the challenges

1. How to track the data changes of SAP table (Insert/Update/Delete) in PO/PI to send it SQL server?

2. How to track the data changes of SQL Server table (Insert/Update/Delete) in PO/PI to send it SAP system tables?

3. Please help me on performance problems.

Any help would be appreciated.

Thanks for the help.

Regards,

Tushar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 06, 2017 at 12:37 PM

    SAP PI/PO is not the right tool for what you are trying to accomplish. I suggest you take a look into SAP SLT, which allows trigger-based replication of SAP database changes to any SAP-supported database, irrespective of whether or not the target DB is connected to an SAP system.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2017 at 12:51 PM

    Hi Tushar!

    In case the changes should be tracked in backend tables the straight way is to track it in that systems itself and to trigger appropriate methods to initiate data transfers via PI.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded