Metadata Properties Dialog

This dialog reports connection properties for your connection to the database containing your metadata tables. It also provides options for setting up primary and secondary backup metadata databases. Syniti Data Replication automatically keeps metadata synchronized between the main and backup metadata databases so that you can restore metadata tables from the backup in case of main metadata database failure.

Authentication

Authentication Method

Read only property. Reports the type of security used to access the metadata

AnonymousAccess
No access control has been selected.

UserName Authentication
Syniti DR manages the user ID and password information.

Windows Authentication
Syniti DR uses your Microsoft Windows login and ID to control access.

User Name

Read only property. Reports the name of the user logged in at the current time.

User Role

Read only property. Reports the role of the user logged in at the current time.

General

Connection Name

Read only property. The name of the connection that you provided when creating the connection.

Current

Shows which metadata connection is current.

IsActive

If true indicates that the information with the metadata database are constantly updated.

IsRunning

If true, indicates that the Replication Agent (either locally or remotely) is executing with this set of metadata.

Status

Provides status messages for this set of metadata.

Connection Properties

Displays the connection details for the main metadata database.

Connection

Displays the name of the data provider used to connect to the main metadata database. Click in this field, then click to open the Connection Properties dialog and modify property values as needed. For example, to switch from using the main metadata to a backup metadata database, change the connection using this dialog.

DriverName
Read only property.The name of the data provider used to connect to the database.

DBType
Read only property. The DBMS name from an internal list provided by Syniti DR

DBVersion
Read only property. The database version number retrieved from the provider.

Provider Assembly
Read only property. If using a .NET data provider, and the provider has not been registered, provide a path to the .NET data provider DLL. Otherwise, this field should display the DLL for your registered provider.

Use Local Assembly
Read only property. Default value is false. Set to true if you have not registered your provider and you are providing a pathname to the provider DLL.

Connection Class
Read only property. The class for your provider.

Connection String
Read only property. Connection string used to connect to the database. The connection string follows the format required by your .NET data provider, ODBC driver or OLE DB Provider.

Main Enabled

Always set to true.

Qualifier

Either reports the catalog and schema where the metadata tables were created (if this information was included in the connection) or allows you to specify a catalog and schema for the metadata tables.

Command Timeout

Default value is -1, which means that no timeout is set for Syniti DR and the default timeout determined by the .NET data provider is used. For example, the default value for Microsoft SQL Server is 15 seconds. To set a different timeout value, enter a value in seconds. This property determines the amount of time before any command from Syniti DR times out while waiting for a response from the database server.

Primary Backup Properties

Connection

Allows you to set connection properties for a backup metadata database. Click in this field, then click to open the Connection Properties dialog and set values as needed.

Backup Enabled

False by default. When set to True, metadata is backed up to this database to keep it synchronized with the main metadata database.

Qualifier

Either reports the catalog and schema where the metadata tables were created (if this information was included in the connection) or allows you to specify a catalog and schema for the metadata tables.

Command Timeout

Default value is -1, which means that no timeout is set for Syniti DR and the default timeout determined by the .NET data provider is used. For example, the default value for Microsoft SQL Server is 15 seconds. To set a different timeout value, enter a value in seconds. This property determines the amount of time before any command from Syniti DR times out while waiting for a response from the database server.

Apply to Other Backups

Click in the value field to apply the current backup metadata to main and other secondary backups.

Repair from Main Backup

Click in the value field to apply the main metadata to this backup.

Secondary Backup Properties

Connection

Allows you to set connection properties for a backup metadata database. Click in this field, then click to open the Connection Properties dialog and set values as needed.

Backup Enabled

False by default. When set to True, metadata is backed up to this database to keep it synchronized with the main metadata database.

Qualifier

Either reports the catalog and schema where the metadata tables were created (if this information was included in the connection) or allows you to specify a catalog and schema for the metadata tables.

Command Timeout

Default value is -1, which means that no timeout is set for Syniti DR and the default timeout determined by the .NET data provider is used. For example, the default value for Microsoft SQL Server is 15 seconds. To set a different timeout value, enter a value in seconds. This property determines the amount of time before any command from Syniti DR times out while waiting for a response from the database server.

Apply to Other Backups

Click in the value field to apply the current backup metadata to main and other secondary backups.

Repair from Main Backup

Click in the value field to apply the main metadata to this backup.

Related Topics
Metadata Connection Wizard
Creating a Connection