DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 9

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version 10

changes.mady.by.user Anil Bhimineni

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
Pre-Requisites for Integration
* Creating ODBC connectiondata source 

  • Importing a Job File in Sage 100
  • Scheduling a Job in Sage 100  

Panel
Setting up ODBC DataSource 
 One of the most important prerequisite of Sage 100 and PocketAdvantage system is to setup the ODBC data source connection on the server where Sage 100 is hosted . The below steps explain how to setup the ODBC connection so that Sage 100 opens a connection to DBSync .

  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 Image Added
    Panel
    Import Job File