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