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 used InstantdbSync.

  • 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 InstantdbSync 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. 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 the replication.

 

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

  2. On the Start menu, click Programs, click CONNX InstantdbSync and then click InstantdbSync Administrator. If this is the first time the InstantdbSync 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) databases can be used for replication.

  1. If the InstantdbSync Administrator has been used previously, the main InstantdbSync window appears. The application will normally open the last opened CDD.

  • If this is the CDD you want, you do not need to re-enable event replication  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 port refers to the message queue server that is running on the machine where the replication controller is running.  The controller uses this message queue server for its communications with the other components.. 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 database.

add_tables_filled_in.bmp

 

  1. Click OK. The InstantdbSync window appears.