DBD: Data Replication System - Set up DB Distributor Tables to Replicate

You set up a table for Data Replication by executing the Table Setup utility as follows:

GUI: DB Distributor Optional Modules > Data Replication > Setup > Table

CHUI: D/R menu, option S2

DB Distributor Table

This text field selects the name of the DB Distributor table, e.g., “AR1500”.

Sequence

This text field is a unique two-digit number that allows you to associate a table with multiple databases. If this is the first instance of this DB Distributor file being replicated, use “01”. Additional sequences can be set up later if you want to replicate the table to multiple databases. Having multiple sequences gives the ability to update multiple databases simultaneously.

Description

This text field is filled in automatically from the Table name. e.g., “Customer Master”

Target Code

This text field allows you to select or enter the Target code that you are replicating to. You can query the field to select the correct entry.

Database Type

This pulldown field is filled in automatically after the Target Code is selected. Examples are “Oracle” for Oracle, “MySQL” for MySQL, and “Other” for other databases such as SqlServer.

Data Source Name

This text field is filled in automatically after the Target Code is selected:

• Oracle Example:

  [oci]DB_ENTERPRISE;&TF;USER=TEST;PSWD=TEST;

• MySQL Example:

  [wdx][odb]dbreports;ⅅ

• Microsoft SqlServer Example:

  [wdx][odb]dbprg;ⅅUSER=sa;PSWD=secret;

Options

Currently left blank.

Data Dictionary Name

This text field is filled in automatically after the Target Code is selected,.e.g., “AR1_Cust”.

Currently Replicating?

Check or set to Yes to force this file to replicate.

Log Activity?

Check or Set to Yes to record replication activity. This is the suggested setting.

Uncheck or Set to No to not log the replication activity.

Changed On

This date field will show the date this record was changed after the initial setup of the table.

Replication Initialized

This date field will show the date the replication initialization process was done.

Queue Code

This text field contains a three-character field (string or zero-filled number) that specifies the name of the group that this table is associated with. Typical values might be “001”, “002” or “100”,”200” or “AAA”, “BBB” or “A’, “B” and so on.

The Queue Code allows the table being replicated to be "grouped" with other tables for processing. It is best if only one Data Replication server is updating the data for a table. When a Data Replication server is started it is assigned a Queue Code to process and will only process tables with the corresponding Queue Code.

It is recommended that either all tables be assigned Queue codes or no tables be assigned Queue Codes.

Don’t Update from Data Dictionary?

Check or Set to Yes to NOT update the Data Dictionary before you update the Table Information.

If the syntax of the File Name in the Data Dictionary does not match the file name on your DB Distributor files, you would use this option to keep the name from being overwritten.