DBSync Cloud Workflow (iPaaS)

2022

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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

The first and foremost step is to setup the ODBC driver on the server where Sage 100 is hosted.This section should aim to give new users an understanding of how to setup the ODBC bridge that would establish the connection between Sage 100 and your staging db.  


Follow the below instruction 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 which will pop up “Create New Data Source” option

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

  7. This will pop up the Connection parameters which are explained after these steps.

  8. Click on Test button 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 user name
PasswordThe password of the database user
DatabaseChoose the appropriate database where you wish to dump the data.

ODBC CONNECTION CHECK

The connectivity can be checked by following the below listed steps.

  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 on Test button which pops up connection successful.



  • No labels