Common

Sync Data Sources in Common and System Administration

When an Administrator registers a data source in System Administration, it is available in Common on the Data Source Registry page.  

However, after the initial record is added to Common, changes made to data sources in System Administration are not applied to data sources in Common. Changes made to data sources in Common are reflected in data sources in System Administration when the data source record is saved or validated in Common.

On the Data Source Registry page in Common, a data source that has been updated in System Administration displays the Out of Sync icon in the OUT OF SYNC column. To view the updates in System Administration, the user clicks the Admin Data Source icon.

NOTE: A user must have access to the Data Sources page in System Administration to view these updates.

Admin > Data Sources

Common > Configuration > Data Sources > Registry

CranSoft.dbo.DataSource

DSPCommon.dbo.ttDataSourceRegistry

[DataSourceName]

[Name]

[Database]

[Database]

[UserID]

[UserID]

[Password]

[Password]

[ConnectionTimeout]

[ConnectionTimeout]

[CommandTimeout]

[CommandTimeout]

[TrustedConnection]

[TrustedConnection]

[DSN]

[DSN]

[Driver]

[Driver]

[DBQ]

[DBQ]

[ConnectionString]

[ConnectionString]

[Active]

[Active]

[AuditDataSourceID]

[AuditDataSourceID]

[DataSourceType]

[DataSourceType]

[Port]

[Port]

[Protected]

[Protected]

[ServerAddress]

[ServerAddress]

[DatabaseInstanceName]

[DatabaseInstanceName]

[ProcedureParameterNamePrefix]

[ProcedureParameterNamePrefix]

[DatabaseType]

[DatabaseType]

[SystemViews]

[SystemViews]

[NetConnectionString]

[NetConnectionString]

The user can either:

  • Apply the updates made to the data source in Common to the data source in System Administration by validating or saving the record in Common.
  • Apply the updates made to the data source in System Administration to the data source in Common manually.

NOTE: If a data source is deleted in Common, the corresponding data source is deleted in System Administration. If a data source is deleted in System Administration, the Common data source is not deleted.

To view changes made to data sources in System Administration:

  1. Select Common > Configuration > Data Source Registry in the Navigation pane.
  2. Locate a data source that displays the Out of Sync icon in the OUT OF SYNC column.
  3. Click the Admin Data Source icon to view the changes made to the data source in System Administration.

To update the data source in System Administration with changes made to the data source in Common, use the Data Source Registry page in Common and save the data source record.

To update the data source in Common with changes made to the data source in System Administration, apply the changes manually on the Data Source Registry page.