We are looking for a solution to replicate part of SAP ECC tables into another SAP ECC system, realtime & sychnorized!
A functional team is leading the solution from SAP functional point of view, such as sycn all the business orders to keep tables synchronized. I want to know the possibility on technical level.
What I know is it's almost impossible, the possible solutions are as follows:
1) DataGuard on whole DB level.
Question: Can this support serveral destinations sync, for example, database A to database B&C&D? The DB sid must be the same? Can destination DB start as readonly mode when sync? Can SAP start during sync to support ECC query/report? As I know, even after user login, some tables need to be updated...
2) Replication on table level. According to note 105047, there are some build-in replication tools:
2.1) Advanced Replication, supported
2.2) Streams, can not be used
2.4) Materialized Views, supported
2.3) Trigger, supported with Materialized Views but cannot use trigger-based real-time replication
Question: Which one can be used for replicating ream time huge SAP transaction tables? Only support Z/Y cutomized talbe or even support standard tables?
3) 3rd party replication product, such as sybase replication agent for oracle, others....
Question: Comparing with oracle build in functionality, they are better or worse?
I know this is crazy but still need your input regarding this.
Thanks
James