--- title: "Metadata Connection Wizard" slug: "metadata-connection-wizard" updated: 2024-04-24T08:11:22Z published: 2024-04-24T08:11:22Z canonical: "skthelp.syniti.com/metadata-connection-wizard" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Metadata Connection Wizard This wizard is optional and allows you to specify a connection to create metadata tables that hold all the information needed for your replication. ## Select Provider ### Metadata Name Type a name to identify the metadata. This name appears in the Metadata Explorer as a way to group connections for a specific replication. ### Database Syniti certify Microsoft SQL Server 2019 or 2022 to be used as Metadata. All Editions are supported, such as Enterprise, Standard, or Express. > [!NOTE] > **Note** > > Syniti recommends using a local database as metadata to avoid possible connectivity issues when using remote databases. ### Provider > [!NOTE] > Note > > The following systems cannot be used for the metadata connection: > > - IBM DB2 for i > - IBM Db2 on Mainframe > - Hadoop > - MongoDB > - Kafka > - Cassandra > - Data Lakes, like Azure Data Lake, S3 or Big Query Choose a different database when defining your metadata connection.Select a .NET data provider from the list. You are free to use any relational database you want for metadata, with the exception of IBM Db2 for i or mainframe. If no .NET provider is available for the database, select either an OLE DB provider or an ODBC driver. By default, only default providers are listed in this dialog. If you want to see all providers for a specific database, uncheck the Use Only Default Providers option in the Options dialog available from the Tools menu. .NET providers are preferred over ODBC drivers or OLE DB providers because, with Syniti Replicate being a .NET application, it can take advantage of the use of native .NET providers based on the same architecture. If you use ODBC or OLE DB connections, the .NET framework will need to add a software layer for every call you make to the driver, adding overhead. Besides, using 100% managed .NET providers, there is no risk of memory leaks because the .NET framework cleans up memory automatically using an internal garbage collector. ### Assembly This field is displayed only if using a .NET data provider, and the provider has not been registered. Provide a path to the .NET data provider DLL. ## Set Connection String ### Connection Properties For all providers, edit at least the Required connection properties by clicking in the property value field and typing a new value. The list of Optional properties for .NET and OLE DB providers contains the most commonly used properties for the providers. Edit these as needed. Note that some properties are displayed with default values (no bold text.) Any values that you add or edit are displayed in bold text. Check the documentation for your provider for a complete list of properties. You can set the value of the ExtendedProperties property to define additional property-value pairs. The syntax for defining property-value pairs is: prop1=val1;prop2=val2;.... If you are creating the metadata tables in SQL Server, note that each login has a default initial catalog. For example, the default initial catalog for a system administrator login is "master." If you do not want to use the default catalog, be sure to enter a catalog to use in the Initial Catalog field. If you are using an ODBC driver, click in the ConnectionString value field and then click to open the ODBC Driver Connection dialog. The contents of this dialog depend on the ODBC driver that you are using. Provide values for the dialog fields, then click OK to make a test connection and set the values in the wizard. ### Edit Click **Edit** to open a text entry window where you can paste or type a connection string for your provider. This is offered as an alternative to the Connection Properties grid, but should be used with great care because an error in the connection string can cause a connection to fail or to have unexpected properties. This window displays any connection information that you have already entered in connection string format. Note that default values are not displayed as part of the connection string. ### Test Click **Test** to make sure that the connection correctly opens a database connection. ## Select Qualifer This screen is not available if the database you have specified does not allow table qualifiers such as catalogs and schemas. If you do not select values for these fields, the default qualifiers will be used based on the connection properties provided in the [Set Connection String](/v1/docs/metadata-connection-wizard#set-connection-string) screen. ## Define Metadata ### Create a new metadata database Select this option to create metadata tables using the connection properties specified in the [Set Connection String](/v1/docs/metadata-connection-wizard#set-connection-string) screen, ### Restore the metadata set from a backup file Select this option if you have previously saved a metadata set to a file using the [Backup Metadata option](/v1/docs/backing-up-and-restoring-metadata). ### Open existing metadata database Select this option to use an existing metadata set available from the connection properties specified in the [Set Connection String](/v1/docs/metadata-connection-wizard#set-connection-string) screen, ## Summary ### Database name The name of the database server ### Database version The database server version ### Provider type The description of the provider that you selected in the [Select provider](/v1/docs/metadata-connection-wizard#select-provider) screen. ### Provider name Whatever connection information is available for the provider you have chosen. In some cases, this field will be blank. In other cases, the provider DLL may be displayed. ### Selected Qualifier Qualifier names (if any) selected in the [Select Qualifier](/v1/docs/metadata-connection-wizard#select-qualifer) screen. ### Proceed with the definition of a source connection When checked, the [Source Connection wizard](/v1/docs/add-source-connection-wizard) is displayed on completion of the Metadata Connection wizard. Use the Source Connection wizard to define a connection to the database that contains the tables or views you want to replicate. ## Opening the Metadata Connection Wizard In the Management Center, from the **Metadata** menu, choose **Add New Metadata**.