Creating a CDD for Event Replication

Creating a CDD for Event Replication is the first step in getting data replicated.  This includes:

  • Opening the CONNX Data Dictionary (CDD) Manager

  • Importing tables from the source database

  • Importing the target database

  • Setting the correct CDD security

  • Saving the CDD

 

Create a CDD for Event Replication if:

  • You do not have an existing CDD containing the source tables and target database needed for event replication.

 

After you create a CDD for Event Replication you will be ready to:

  • Enable the Event Replicator

 

InstantdbSync needs a CONNX Data Dictionary (CDD) to replicate. Create a new CDD if you do not have an existing CDD that contains both the source tables to be replicated and the target database.  

 

Note: For this example, the source database will be SQL Server and the target database will be Oracle

 

  1. On the Start menu, click Programs, click CONNX Driver and then click CONNX Data Dictionary. The Open window appears.

 

connx_open_cdd.bmp

 

  1. Click Cancel. The CONNX Data Dictionary Manager window appears.

 

connx_cdd_manager.bmp

 

Importing Source Tables from SQL Server

  1. Click Import. The Import CDD window appears.

 

connx_import_cdd-sqlserver.bmp

 

  1. Select OLEDB Provider and then click the Select Provider button.  Fill in the SQL Server Data Link Properties..

Note: If "Use a specific user name and password" is selected, be sure to also check "Allow saving password".  If this is not checked, the password will not be passed back to the CDD Manager and it will have to be re-entered prior to completing the import.

sql_server_data_link_properties.bmp

 

Click OK. The CONNX Import Table Selection window appears.

 

connx_import_table_selection_-_sqlserver.bmp

 

  1. Add the source tables to be replicated to the target database and click OK.

connx_import_table_selection_selected-_sqlserver.bmp

 

  1. The CONNX Data Dictionary Manager window containing the source table information appears.

connx_cdd_manager_with_source_tables.bmp

 

You have imported the source tables into the CDD.

 

Importing Source Tables from MySQL

  1. Click Import. The Import CDD window appears.

    connx_import_cdd-mysql.bmp
  2. Select MySQL in the Import Type drop down box.  Do not use the Enterprise Adapter for the import method.
  3. Fill in values for Server, UserName and Password.  The Port is set to the default value of 3306.  If MySQL is configured to use a different port, this value will need to be changed to match the port MySQL is configured to use.
  4. Press the Select Catalog button.  This will bring up a list of the available catalogs.  Select one and press OK.  Alternatively, pressing the Advanced button will allow the specification of all MySQL driver settings including the catalog.  If Select Catalog is used, the rest of the MySQL driver settings will be the default settings.
  5. Press OK on the Import CDD dialog.  The CONNX Import Table Selection window appears.
  6. Follow steps 3 and 4 in the above section on importing from SQL Server to select the desired tables.
Importing the Target Database

This example illustrates importing from an Oracle database as the replication target.  If the target database is a SQL Server database, follow the Importing Source Tables from SQL Server  instructions above and import the target database and its tables.

 

Warning: If the target database does not allow table creation via SQL, InstantdbSync cannot create target tables. Target tables must be created in that database's native environment and not with the Replication Administrator.

 

If your target database is on UNIX, follow the special configuration instructions found in CONNX Configuration Settings in the CONNX User Guide.

  1. Click Import. The Import CDD window appears.  In Import Type, select the target database type.

    Note: Different target databases will have Import CDD windows with different required information. The example shows Oracle.

connx_import_cdd-oracle.bmp

 

  1. Fill in the SQLNet connect name and the Oracle logon credentials. Click OK.

The CONNX Import Table Selection window appears. If there are any tables in the target database, they will appear in Available Tables.

  • If any of the existing tables will be used as target tables, select them and click Add. After enabling a CDD for Event Replication, map the source columns to the target table.

  • If none of the existing tables will be target tables, do not select anything. You will create the new target table in the Event Replicator.

  • To avoid future table name conflicts, click Add All to import all available tables.

Click OK. The CONNX Data Dictionary Manager window appears.

 

connx_cdd_manager_with_target_tables.bmp

 

Set the CDD Security

  1. In the Security menu, clear Default Access = Read Only.

 

connx_security-default_access.bmp

 

  1. In the File menu, select Save As.

connx_save_as.bmp

 

  1. Name your CDD and select the appropriate folder to save it in. Click Save.

  2. Close the CONNX Data Dictionary Manager.