Data Source Properties Page
Getting There
From the data sources page, select a data source select Properties from the Settings button drop-down after selecting the data source in the data sources view, or by selecting the Properties icon next to the desired data source.
The customizable properties for a data source are organized in the following sections:
Basic Properties
Properties in this group can only be Enabled or Disabled. Use the slider to enable or disable the data source. When the data source is disabled the service will not launch process
and clone
commands for disabled data sources. A data source is disabled when the Client receives an unrecoverable error, or, after the retry count for error recovery reaches its maximum value (normally 3).
Client Properties
There are two properties in this group, Source ID and Table Name prefix.
Source ID
This property is the value of the data_source_id
column in the DATASOURCES Client control table. This property allows you to provide a numeric identifier to distinguish
records that belong to a particular data source from other records in a multi-source environment. This value is used to populate the user columns Data Source ID or Data Source ID key which need to be added to all data sets. See User Columns.
Table Name prefix
This property is the value of the tab_name_prefix
column in the DATASOURCES Client control table. It holds an optional one- to eight-character prefix which is added to all table names in the data source. This prefix, which must be entered, allows you to distinguish between identically named data sets in multiple data sources, without having the Define, Redefine and Customize commands rename tables to eliminate name conflicts. The configuration file parameter use_column_prefixes
extends this prefix to all column names.
Server Properties
The two properties in this group are the Host domain name or IP address and the host Port. Change these properties to switch between using Enterprise Server and DBServer on the MCP, when the Enterprise Server data source is identical to the one on DBServer. These values are initially set in the Add > New command in the data sources view for a Client Manager.