DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 26

changes.mady.by.user Anil Bhimineni

Saved on

compared with

New Version 27

changes.mady.by.user Anil Bhimineni

Saved on

Key

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

...

  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 RemovedImage Added

Panel
Importing Job File 

...

  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 ~anil.b: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.          Image Removed    Image Added

Panel
Schedule a Job 
Scheduling all the necessary jobs from Task Scheduler will facilitate the data to be migrated from Sage 100 to DBSync so that the DBSync in turn processes the data to PocketAdvantage. Here are the steps to schedule a job so that they get scheduled at the set time intervals

...