DBSync for 's "Sage 100 & PocketAdvantage PocketAdvantag Bidirectional Integration" 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 way is Orders of Pocket Advantage getting integrated to Sales-orders in Sage 100. This solution template which integrates data both ways between the Sage 100 & PocketAdvantage app. The template is also useful in migrating historical Sage 100 data into PA and vice versacan also be used to do a periodic swipe of historical accounting data into PA. This template provides Bi-directional sync with pre-built field to field map along with the flexibility for more complex and dynamic mapping capability.
Data flow of Sage 100 and PocketAdvantage application is shown in the table below table .
Image Removed
Image Added
The Process map of Bi-Directional Integration - between Sage 100 application and PocketAdvantage application - is shown in the image below image.
![](/docs/download/attachments/11698391/ProcessMap_Sage.png?version=1&modificationDate=1461766833000&api=v2)
Panel |
---|
Pre-Requisites for Integration |
# Creating ODBC data 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 prerequisites of Sage 100 and PocketAdvantage system is to setup set up the ODBC data source connection on the server where Sage 100 is hosted. The below steps explain how to setup set up the ODBC connection so that Sage 100 opens a connection to DBSync.
- Go to Control Panel -> Administrative services of the server on which the Sage 100 is hosted.
- Select the service ODBC data source 32-bit/64-bit basing based on server configuration, which then opens . This will open a pop up as shown in the image below image .
- Choose the Tab user DSN and click on the Add button which opens . This will open a pop up with various drivers drivers.
- Choose MySQLODBC5.3 unicode driver which pops out a windows Unicode driver. This will pop open a window to enter connection properties properties.
- In the MySQL connection windows window, enter the following Parameters Data Source Name: dbsyncqueue , TCP/IP server: dbsync-queue.cvglyvvn64dx.us-east-1.rds.amazonaws.com, user:dbsync, Password:, DatabaseDatabase: Sage .
![](/docs/download/attachments/11698391/ODBCBridge.png?version=1&modificationDate=1462279151000&api=v2)
The steps below are the steps show how to import the job file script provided by DBSync which - it is mandatory for the integration to take place work.
- Login to Sage 100 with valid credentials credentials.
- On the left navigation, select a visual integrator which gives the . This will provide a list of options Now choose options.
- Choose the "Job Import" option from the available values.
- Choose the file provided by DBSync which . The file can be downloaded from this by clicking on the following link.
- From the file dialog box, choose this the file which . It will show the list of all the job which jobs that are required for DBSync to perform the integration.
- Select all and click . And then, click on the Accept button as shown in the below screen shotfollowing screenshot.
![](/docs/download/attachments/11698391/jobimport.png?version=1&modificationDate=1462279029000&api=v2)
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 , will process the data to PocketAdvantage. Here are the steps to schedule a job so that they get scheduled at the set time intervals:
- Login to Sage 100 with valid user credentials credentials.
- Search for the Task Scheduler from the search which returns . It will return the search resultresults.
- Clicking on the search result name of Task Scheduler will open out a popup which is - as shown in the image below image .
- Key in the desired job name , move . Moving the cursor to next text box will auto-populate the company code, Sage 100 user logonlogin, and server user logon.
- The user will have to key in the Sage 100 Account password Password and Server password and Password. Then, s/he will have to choose the type to "Visual Integrator ".
- Set the schedule job intervals by choosing the appropriate options.
- Now , choose Choose the tab "Tasks".
- Select the V/I Job Type to to Export (, in case of reading data from Sage 100 or . Or, choose Import in case of writing to Sage 100) and . Then, choose the V/I Job Name to appropriate as appropriate.
- Click on Accept so that a job is saved. to save the job.
Image Modified
Panel |
---|
Post Process Of Sage Data |
So here the question arises A question may arise - what happens to the Sage data after being it is read from the Sage 100 application, how ? How does DBSync process the data and writes write to the PocketAdvantage .? Below are the few steps which explain the process of how Sage Data is being processed to the PocketAdvantage.
- The Scheduled jobs with in within the Sage 100 application, helps to read from Sage and process to the DBSync processes to DBSync.
- The DBSync holds the Sage data in the a queue - i.e. a buffer for - before applying the required transformations and writing to the PocketAdvantage.
- The workflows - with the naming convention "Merge" with in within the DBSync - will help DBSync to sort any duplicate records which that are processed into the DBSync's buffer.
- DBSync internally uses a chaining technique for the merging process so that DBSync will identify the . The technic enables DBSync to identify unique records and separate the duplicate records from the unique ones.
- Then the other workflows created , another workflow will process the data from DBSync buffer to writing to PocketAdvantage.
Panel |
---|
Running The Integrations |
DBSync Integration of Sage & PocketAdvantage can be triggered by:
- Using Clicking on the Run-now button from the process listing page of DBSync.
- Using DBSync Scheduler.
Using Clicking on Run-Now Buttons From DBSync platform
The user can login log in to DBSync with his/her valid credentials and hit click on the Run-now button from the process listing page or from the workflow listing page . The order of execution, of the process has to , must follow the below order following path:
- SageToQueue
- CustomerToFTP
- ItemsToFTP
- TransactToFTP
...
- Scheduler available in DBSync Account can be used to schedule the integration & the details of scheduler is available from the . For further details on the scheduler, please click on the following link http://help.mydbsync.com/docs/display/dbsync/Scheduler ..
Note |
---|
PockeAdvantage Configuration steps link: PocketAdvantage Connector (How to do the connector configuration in DBSync Platform) Sage 100 Configuration steps link: Sage 100 Connector (How to do the connector configuration in DBSync Platform) |