2022
Panel |
---|
Overview |
DBSync for Sage 100 & PocketAdvantage is an easy to use Integration Template to integrate Sage Customer, Item, Vendor, SalesRep, Invoice with PA Customer, Item, Sales Rep and Transactions respectively is one way and other an other way is Orders orders of Pocket Advantage getting integrated to Salessales-orders order in Sage 100. This template is also useful in migrating historical Sage 100 data into PA and vice versa. This template provides Bi-directional sync with the pre-built field to field map along with the flexibility for more complex and dynamic mapping capability.
Panel |
---|
Data Flow |
Data flow of Sage 100 and PocketAdvantage application is shown in the below table .
Panel |
---|
Process Map |
The Process map of Bi-Directional Integration between Sage 100 application and PocketAdvantage application is shown in the below image.
Panel |
---|
Pre-Requisites for Integration |
# Creating ODBC data source
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 .
...
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
Panel |
---|
Post Process Of Sage Data |
So here the question arises what happens to the Sage data after being read from the Sage 100 application, how does DBSync process the data and writes to the PocketAdvantage .Below are the few steps which explain the process of Sage Data being processed to the PocketAdvantage.
Panel |
---|
Running The Integrations |
DBSync Integration of Sage & PocketAdvantage can be triggered by
...