Creating Database Connections
  • 27 Mar 2024
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Creating Database Connections

  • Dark
    Light
  • PDF

Article summary

With Syniti Replicate, 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
    The database you use to store tables containing information and settings for the replication process. 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 Replicate 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.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence