DBSync Cloud Workflow (iPaaS)

2022

Page tree
Skip to end of metadata
Go to start of metadata

The first and foremost step is to setup the ODBC driver on the server where Sage 100 is hosted. In this section, I will show you how to setup the ODBC bridge to establish the connection between Sage 100 and your staging database.  


Follow the instructions for setting up ODBC.

  1. Download the mysql-connector from the link https://dev.mysql.com/downloads/connector/odbc/ as per your server configurations.

  2. Install mysql-connector on the server where Sage is hosted.

  3. On the server, navigate to Control panel -> Administrative Tools.

  4. Double click on the service Data Source (ODBC).

  5. From the User DSN tab -> Click Add button. This will pop up “Create New Data Source” option.

  6. Scroll down to select option “MySql ODBC 5.3 unicode driver” and click Finish.

  7. This will pop up the Connection parameters. Below, I explain the parameters.

  8. Click Test to test the connection of your entered parameters.

ParameterDescription
Data Source NameEnter the name of your choice by which you want to identify the connection.
TCP/IP serverEnter the ip/domain name where your database server is hosted.
UserDatabase server username.
PasswordThe password of the database user.
DatabaseChoose the appropriate database where you wish to dump the data.

ODBC CONNECTION CHECK

Follow the steps below to check the connectivity:

  1. On the server, navigate to Control panel -> Administrative Tools.

  2. Double click on the service Data Source (ODBC).

  3. On the User DSN tab, you will find “dbsyncqueue” driver.

  4. Double clicking on the “Data Source Name” driver will open up a pop-up.

  5. Click Test. It will pop-up when connection is successful.



  • No labels