Skip to Content

Help on how to optimize SDI replication operations

We are using SDI to replicate some ECC database tables to SAP HANA on Cloud. At database level Oracle archive logs are activated and SAP Connector is using ECC Adapter (on the top of Oracle Log Reader Adapter) to replicate tables in realtime.


This scenario is already working and the replication is being done through Replication Tasks and Flow Graphs.

For tables which we need to replicate completely, we use Replication Tasks. For tables which we apply a filter (e.g. company, sales order type), we are using Flow Graphs with filters.

However we have some doubts about how those replications are being managed, and how to optmize it. So the questions are:

  1. When we use Flow Graphs with filters, SDI brings all the information to Cloud and perform the filters, or the select of Flow Graph at source Virtual Table is executed with a "where" clause, filtering all in ECC level before bringing it to Cloud?
  2. Is there any way to see/check executed SQL on SDI (or in SAP Connector logs)? I found a log folder, however it logs only the operation, not the SQL.

.

Another issue is that our basis team are very concerned about archive logs size, because a few hours of record can consume a lot of disk space. SAP recommend 24-76 hours of archive log to be maintained (https://launchpad.support.sap.com/#/notes/0002375559).

So the questions are:

3. The archive log retention time could be reduced to 1 hour? In this case, the only colateral effect i can see is if the SAP Connector loose the connection for more than 1 hour, we will need to restart the "initial + realtime" replication task.

4. Is there any way to active archive logs for specific tables? Because we won't replicate all tables of our ECC.

Any lecture, link, reference, SAP Note will be appreciated!

ecc.png (95.8 kB)
fg1.png (25.6 kB)
fg2.png (6.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 24 at 06:42 AM

    Hi, Eduardo

    According to your first question, you can create a select statement on your virtual table (see the screen below)

    then right click on sql statement and select "Explain plan"

    After that in column 'REMOTE COLUMN SCAN', you will see sql statement created on the source side


    1.jpg (122.6 kB)
    2.jpg (105.0 kB)
    3.jpg (114.2 kB)
    Add comment
    10|10000 characters needed characters exceeded