DATABridge Client Control Tables

This chapter describes the five client control tables and the properties in each table that can be customized. For best results, use the Console and Client Configurator to customize your client control tables.

Control tables do not contain replicated DMSII data. To store replicated data, the relational database uses data tables, which are created using information from the control tables. The control tables hold the layout information of the DMSII database (from the DMSII DESCRIPTION file) and the layout of the corresponding relational database tables. Each relational database has one set of Client control tables that includes the following tables: DATASOURCES, DATASETS, DATATABLES, DMS_ITEMS, and DATAITEMS.

The DATABridge Client uses several columns of the control tables to determine how DMSII database objects are represented in the relational database layout. While DATABridge makes many of these decisions, some properties can be customized by using the Client Configurator or user scripts. For example, you can rename columns, combine like items, and flatten OCCURS, to name just a few.

For instructions on backing up the Client control tables, see Backing Up and Maintaining Client Control Tables.