Creating Database Connections

With Syniti Data Replication, you can use a .NET data provider, an OLE DB Provider or an ODBC driver to connect to the databases used in your replication. Check the Available Source and Target Options and the Help Center for a list of supported databases and drivers/providers.

You will need connections to the following databases:

  • Metadata database (Default connection to Microsoft SQL Server CE provided)
    The database you use to store tables containing information and settings for the replication process. Syniti DR provides a default database connection to SQL Server CE (included with Syniti DR) so you do not need to create a connection for your metadata. However, you can choose to store metadata in a different database by creating a metadata connection to the database. To use a different database for your metadata, in the Metadata Explorer, choose and complete the Metadata Connection wizard.

  • Source database
    The database that contains the tables you want to replicate.

  • Target database
    The database that will contain the replicated tables.

Follow the steps below to set up Syniti DR for replication.

  1. For each database you are planning to use in your replication project:

    • Install and configure one of the third-party supported data access providers. (See a list of providers in the Help Center)

    • From the data access product, test the connection to the database.

    • Create a connection string for the data access product/database you are using. Check the documentation for the data access product for information on how to do  this.

  1. In the Management Center Metadata Explorer, expand the node for your metadata to view the Sources and Targets nodes.

  2. Check to see if there is a Setup Guide in the Help Center for your source database to learn all the steps involved in setting up the connection correctly.

  3. Select the Sources node.

  4. From the right mouse button menu, choose Add New Connection.

  5. In the Source Connection Wizard, follow steps to add a connection string and test the connection to the database.

  6. Choose the tables that you plan to replicate.

  7. Complete the wizard.

  8. Select the Targets node.

  9. From the right mouse button menu, choose Add New Connection.

  10. In the Target Connection Wizard, follow steps to add a connection string and test the connection to the database.

  11. Choose the tables to which you plan to replicate.

  12. Complete the wizard.

  13. You are now ready to create target tables, set up for transactional replications or create a replication.