Enabling a CDD for Event Replication
Enabling a CDD for event replication is the next step towards replicating your data. This includes:
Opening a CONNX Data Dictionary (CDD).
Entering connection information to connect to the source and target databases through CONNX.
Selecting tables from a source database and a target database to be used in replication.
Enable a CDD for event replication if:
This is the first time you are using InstantdbSync.
This is the first time you are using this CDD for event replication.
You are using a different CDD from the one used during the last event replication session.
After you enable InstantdbSync, you will have a CDD with replications that are ready to be:
Modified with column mapping.
Deployed (which starts replicating data from source database to target database).
The Event Replication Controller is designed to use a single CDD. When designing a set of replications, create one CDD that includes all the desired source tables and target databases.
CAUTION:
Replications from two separate CDDs cannot be deployed to the same Controller. If you attempt to do so, the replications from the second Data Dictionary will replace the replications from the first.
Two separate CDDs cannot replicate to the same targets from two different controllers. InstantdbSync is designed to maintain data integrity from the source to the target; any target modifications from more than one controller will result in replication errors, disabling InstantdbSync.
To enable a CDD for event replication:
1. If you do not have a replication CDD created, create one.
Note:
Only CONNX Data Dictionaries (CDD) that contain both the source and target (destination) data bases can be used for replication.
2. Start the Replication Administrator.
If this is the first time the Replication Administrator is used, the Open the Data Dictionary window appears.
If this isn't the first time the Replication Administrator is used, the Open Systems Event Replication window appears. InstantdbSync will open the last opened CDD by default. If this is the CDD you want, you do not need to re-enable InstantdbSync for it.
3. If the Replication Administrator has not been used before, or the opened CDD is not the one you want, click File > Open CDD. Select a CDD that contains the source tables for replication and the target database, and click Open. The Configure Servers window appears.
4. Enter your User Name and Password in CONNX Logon Credentials and click Test Connection. If the data is valid, a confirmation message will appear.
5. Enter the server name or IP address of the Replication Server in Name/Address and the server port number in Port.
Note:
The default port is 9200.
6. Click Done. The Add Tables window appears.
7. Select the source tables you wish to replicate and the target database and click OK. This window will close and the Open Systems Event Replication window will appear.