Creating a CDD for Event Replication using the CONNX SQL Engine
Creating a CDD for event replication using the CONNX SQL Engine is the first step in getting data replicated. This includes:
Opening the CONNX Data Dictionary (CDD) Manager.
Importing the Adabas source tables.
Importing the target database.
Setting the correct CDD security.
Saving the CDD.
Create a CDD for Event Replication using the CONNX SQL Engine if:
You have never used the CONNX SQL Engine before.
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 using the CONNX SQL Engine you will be ready to enable InstantdbSync.
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 for replication and the target database. You create CDDs in the CONNX Data Dictionary Manager.
Starting CONNX Data Dictionary Manager
To start the CONNX Data Dictionary Manager:
1. Start CONNX Data Dictionary in the CONNX Driver folder. The Open window appears.
2. Click Cancel. The CONNX Data Dictionary Manager window appears.
Importing the Adabas Source Tables
To import the source Adabas tables:
1. On the main CONNX Data Dictionary Manager screen, click Import. The Import CDD window appears.
2. Input the following:
In Import Type, select the correct Adabas Import Type.
In Database ID, type the Adabas Database ID for the Adabas source tables.
In MAX ADABAS File #, type 255.
Fill in all fields in the logon information.
CAUTION:
Do not use localhost as the server name for the Adabas Source or Target tables. In certain instances using localhost as the server name may cause you to lose all your source table records during an initial state.
3. Click OK. The CONNX Import Table Selection window appears.
4. Add the source tables for replication to the target database and click OK. The ADABAS Count Selection window for the source table appears.
5. If the default values are incorrect, change them. Click OK. The CONNX Data Dictionary Manager window containing the source table information appears. This signals that you've imported the Adabas source tables into the CDD.
Importing the Target Database
If the target database is an Adabas database, follow the above instructions to import the target database and its tables.
CAUTION:
InstantdbSync cannot create Adabas target tables. Adabas target tables must be created using Adabas.
If your target database is on UNIX, follow the special configuration instructions found in CONNX Configuration Settings in the CONNX User Guide. If your UNIX target database is not correctly configured on both the CONNX SQL Engine administrative machine and the InstantdbSync Administrator machine, you will not be able to use InstantdbSync to replicate to those target tables.
To import a non-Adabas target database on Windows:
1. On the main CONNX Data Dictionary Manager screen, click Import. The Import CDD window appears.
2. In Import Type, select the target database type.
Note:
Different target databases will have different required information in the Import CDD window.
3. In Select Provider Type, select OLEDBC Provider. Click Select Provider and supply the required information. Click OK.
4. 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 InstantdbSync.
To avoid future table name conflicts, click Add All to import all available tables.
Click OK. The CONNX Data Dictionary Manager window appears.
Note:
When the target datbase is SQL Server, it is recommended that the Enterprise Server Service is installed on either the SQL Server machine or a Windows machine in the same network as the SQL Server machine. The CDD should then be configured to connect to the Enterprise Server Service by checking the Enterprise Server Service checkbox and specifying the server the Enterprise Server Service is running on. When the Replication Server is running inside a docker container, the Enterprise Server Service must be used when the target is SQL Server.
Set the CDD Security
To set the CDD security:
1. In the Security menu, clear Default Access = Read Only.
2. Click File > Save As.
3. Name your CDD and select the appropriate folder you want to save it to. Click Save.
4. Close the CONNX Data Dictionary Manager.