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:
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!