Customizing Data Sets
Use this page to map individual DMSII data sets (and their items) and customize the table layout of the relational database.
Customizations should be made before cloning a data source to prevent having to run a re-clone. To make customizations that affect the entire data source, use the Configure option available from the Settings drop-down on the data sources page. See Customize the Client Configuration for more information.
The customize command is a cooperative process between the DBClntCfgServer program, the Client Manager service, the code in the Administrative Console server, and the browser. You should never use the browser back button during this command ,or, close the browser before you exit the Customize command. Use the Done buttons or the links provided in the Administrative Console to complete this command. Closing the browser when making customizations can result in the DBClntCfgServer program being left in a bad state. When this happens, you can wait for the timeout, or end the task by using task manager.
When Customize is selected the data set view will be displayed. From this view, customizations can be made at the data set level. Some examples of customizations that can be made can be seen below:
- Deselecting specific data sets to not be replicated.
- Setting data set specific options that override the configured global parameters specified in the Client configuration file.
- Link virtual data sets and the real data sets from which they are derived.
DMS Items and Relational Data Item and Table Customizations
From the data sets view you can select a data set to get to its DMS item view where you can perform customizations on the data set's DMS items. The following customizations can be made from the DMS Items Properties page.
Modify the way an item is replicated.
For example, a date represented as a NUMBER(8) in DMSII can be replicated as a relational database date.
Modify an item with an OCCURS clause so it can be mapped to a secondary table or be flattened within the table.
From the DMS Item Properties page select the Relational tab to access the relational view where you can customize data tables and data items. The following customizations can be made from the Data Item and Data Table Properties page:
- Rename data tables and data items
- Change the order of columns in a table
- Modify the data type of an item, or making its length bigger.
- (SQL Server Client only) Apply data masking to sensitive items
The Done button in both the DMS Items and Relational tabs will return to the data sets view.
To exit the Customize command return to the data set view and select the Done button.