Configuring the Streams

Notes:

This section is only relevant when configuring the BI Interface for installation on two separate databases.
This section is not executed by the user. The operations described here are performed automatically by scripts, and this is only an explanation of how they are implemented.

The system uses Oracle streams for the replication process. To perform data replication using Oracle Streams, the following is required:

Create Stream Administrator users on both databases.
Create a capture process on the source database that captures the changes the user wants to replicate to the target database.
Create a queue that holds the captured changes on the source database.
Create a propagation process that propagates the changes recorded in the queue.
Create a queue on the target database that receives the changes propagated from the source database.
Create an apply process that applies the changes from the queue.
Create capture rules to define which tables should be replicated. These rules depend on the initial configurations for the tables selected for replication.