Page History

...

1. Go to Control Panel -> Administrative services of the server on which Sage 100 is hosted
2. Select the service ODBC data source 32-bit/64-bit basing on server configuration, which then opens a pop up as shown in below image . 
3. Choose the Tab user DSN and click on Add button which opens a pop up with various drivers 
4. Choose MySQLODBC5.3 unicode driver which pops out a windows to enter connection properties 
5. In MySQL connection windows enter the following Parameters Data Source Name: dbsyncqueue , TCP/IP server : dbsync-queue.cvglyvvn64dx.us-east-1.rds.amazonaws.com, user:dbsync, Password:, Database:Sage  

The below are the steps to import job file script provided by DBSync which is mandatory for the integration to take place .

1. Login to Sage 100 with valid credentials 
2. On the left navigation , select visual integrator which gives the list of options 
3. Now choose "Job Import" option from the available values. 
4. Choose the file provided by DBSync which can be downloaded from this link.
5. From the file dialog box , choose this file which will show the list of all the job which are required for DBSync to perform integration
6. Select all and click Accept button as shown in the below screen shot.