Adding a Replication to InstantdbSync
Adding a Replication to InstantdbSync includes:
Opening a CONNX Data Dictionary (CDD).
Adding a source table from the Adabas tables in the CDD.
Adding a target database.
Add a replication if:
You wish to replicate a source table that is not in the list of Event Replication source tables.
You wish to replicate a source table to an additional target table.
After you add a replication, you will be able to:
Modify it with column mapping.
Deploy it (which will start replicating data from source database to target database).
You can add additional source tables to InstantdbSync and associate them with a target database at the same time.
CAUTION:
To maintain data integrity, a table cannot be both the source table in one replication and a target table in another replication.
To add a replication:
1. Open the InstantdbSync CDD.
2. Click Add Tables. The Add Tables window appears.
3. Select any additional source tables you wish to replicate and specify the target Database.
By default, the source tables will map to new target tables which exactly match the source tables that will be created on deploy. Select the Use Existing Target Tables option to have the Replication Administrator search for a table with the same name as the source table in the target database. If a table with the same name is not found in the target database, the Replication Administrator will create a new table with the same name.
In this process, the Replication Administrator will also map columns with the same name from the source table to the target table. If there are columns in the existing tables with names that do not match the source, they must be mapped manually in the Column Map window.
If you are creating replications that are for ACD changes, select the Target tables are ACD option. If you would like to create several replications for each selected source table, use the Create multiple target tables per source checkbox. Once checked, use the dropdown to specify how many replications to create. Each replication will have a different new target table, the name will be automatically generated.
Note:
If there is a large number of source tables, the Filter window can be used to reduce the number of displayed tables. For example, if you know the table you are interested in has the word "Account" in it, entering "Account" in the Filter window will display only those tables that contain that word in their name.
4. Click OK. The InstantdbSync window appears and the tables you added are in the list.
5. If you want to deploy the changes you've made, click Validate Active and then Deploy. If you wish to save the changes but not deploy them until a later time, click File -> Save.
For more information about Validate Active, see Validating Active Replications. For more imformation about Deploy, see Deploying the Event Replication.