Enabling a CDD for Event Replication

Enabling a CDD for Event Replication is the first step in getting data replicated.  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 have use the Open Systems Event Replicator.

  • This is the first time you have used this CDD for event replication.

  • You are using a different CDD than the one used during the last event replication session.

 

After you enable the Event Replicator 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.  

 

Caution: Two separate CDDs cannot replicate to the same targets from two different controllers. The Event Replicator 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 the Event Replicator.

 

  1. If you do not have a replication CDD created, create one.

  2. On the Start menu, click Programs, click CONNX Open Systems Event Replicator and then click Replication Administrator. If this is the first time the Replication Administrator has been used, the Open the Data Dictionary window appears.

 

Open_CDD.bmp

 

Note: Only CONNX Data Dictionaries (CDD) that contain both the source and target (destination) data bases can be used for replication.

  1. If the Replication Administrator has been used previously, the Open Systems Event Replication window appears. The Event Replicator will normally open the last opened CDD.

  • If this is the CDD you want, you do not need to re-enable the Event Replicator for this CDD.

  • If this is not the CDD you want, from the File Menu, click Open CDD. Select a CDD that contains the source tables to be replicated and the target database, and click Open. The Configure Servers window appears

  1. If the Replication Administrator has not been used before, select a CDD that contains the source tables to be replicated and the target database, and click Open. The Configure Servers window appears.

 

Configure_Replication.bmp

 

  1. Enter your User Name and Password in CONNX Logon Credentials and click Test Connection. If the data is valid, the following message window appears:

 

Configure_Replication_Successful_Connection.bmp

 

  1. Click OK. The message window closes.

  1. Enter the server name or IP address of the Replication Server  in Name/Address and the server port number in  Port.

 

Configure_Replication_Server.bmp

 

Note: The default port number is 9200.

 

  1. Click Done. The Add Tables window appears.

 

Add_Tables.bmp

 

  1. Select the source tables you wish to replicate and the target data base.

 

Add_Tables_filled_in.bmp

 

  1. Click OK. The Open Systems Event Replication window appears.