Oracle Replication

[Former Member]

We are a new SAP shop in the realization stage. We are planning on creating a few zTables that will contain large number of records (millions). These zTables will only be read by SAP ABAP programs to make business decisions. Since, the source of data in these zTables are non-SAP systems, we are thinking of use Oracle Replication to keep these zTables in sync with the source systems. The Synchronization will only be done once a day at night.

We understand that SAP does not recommend updating SAP tables including the zTables directly (without going through SAP). Does any one have suggestions and/or alternatives to accomplish this.

Thanks

Sat Pal

[markus_doehr2]

> We understand that SAP does not recommend updating SAP tables including the zTables directly (without going through SAP). Does any one have suggestions and/or alternatives to accomplish this.

Not only that - you may run into license specific issues (Note 581312 - Oracle database: licensing restrictions)

What you could think about is to access the external database directly using the SAP system and external database connection from ABAP - DBCO.

Markus