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

[Former Member]

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

[former_member190293]

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.

[Former Member]

Trigger for SAP tables and SQL server DB tables to track the changes. I understand that Trigger will have performance problems if there is a frequent update with high volume. Please let me know if you have any other approach. Thanks for the help.

[former_member190293]

Hi Tushar!

I think there are no other possible approaches. You use either SLT as Patrick has already suggested or trigger update events from backend's side. PI itself can't track the changes, moreover, it shouldn't do it.

You can use polling mechanism of JDBC sender adapter, for example, to select data from database tables using some trigger field value but PI can't set that trigger value on any change happening. This trigger is set by backend system when data is changed.

On SAP side in most cases data transfer is initiated by backend system. It checks for data changes, composes messages and sends it using appropriate communication channel (RFC, ABAP Proxy, IDOCs etc.).

Regards, Evgeniy.

[Former Member]

Thank you for the reply. That was helpful. Thanks a lot Evgeniy.