2022
panel
Table of Contents |
---|
Panel |
---|
Overview |
DBSync for Inventiv has developed an easy to use integration solution for the customers of Inventiv where data has to be moved in and out of QuickBooks to integrate QuickBooks Customers, Items, Invoices and SalesOrders. DBSync provides Bi-directional sync with pre-built field to field map QuickBooks & PocketAdvantage integration template is easy to use. It integrates QuickBooks Vendors, Sales Rep, Customers, Invoice and line Items and Sales Order transactions with PocketAdvantge Vendors, Sales Rep, Customers, Items, Transact and Orders. DBSync provides bi-directional sync between QuickBooks and PocketAdvantage with the pre-built field-to-field mappings along with flexibility for more complex and dynamic mapping capability. DBSync also has an capabilities. DBSync's automatic online update , enabling DBSync enables its customers to enjoy all the product updates and features that come with every new release.
The proposed data flow is demonstrated in the latter section including the Business -Casecase, Data-Flow , Architecture in detail.
Panel |
---|
Data Flow |
Data Flow of QuickBooks and PocketAdvantage application is as shown below.
Panel |
---|
Process Map |
The data flow is derived from the following Business - case which depicts the solution to be built using DBSync Ipaas showing the pre-built mapping using DBSync Ipaas to be used by Customers.
The first section of the solution explained explains the very first Business Case - i.e. the data flow of Customer, Item, Invoice objects from QuickBooks to PocketAdvantage followed by the image showing the process map.
Customer Integration: The customer integration dataflow data flow constitutes of retrieving data on a nightly basis from QuickBooks and integrating it with FTP and file using Inventiv specs on PocketAdvantage. It involves file creation.FIL as the file extension. The integration data-flow will always extract all Customers and move to the Inventiv FTP system. The scheduler job consists of the following ? QuickBooks Customer following:
...
...
...
...
...
*Item Integration: * The Item integration dataflow data flow constitutes of retrieving data on a nightly basis from QuickBooks and integrating it with FTP and file using Inventiv specs on PocketAdvantage. It involves file creation with.FIL as the file extension. The integration of data - flow will always extract all items and move to the Inventiv FTP system. The scheduler job consists of the following:?
...
...
...
...
...
...
Invoice Integration: The Invoice Object dataflow data flow will be unidirectional with . It will transfer of data from QuickBooks into inventive FTP to a specified file path with the Invoice transaction file bearing a and integrate it with PocketAdvantage. This will result in file creation.FIL as its extension. Integration is invoked overnight at a specified time interval of time by the scheduler mechanism built inside the DBSync platform. The data - flow will be uni-directional and incremental in nature with the transfer of data into Inventiv FTP.
...
Proposed Data-Flow Between QB To Inventiv FTP
...
The Second Business Case covers the data flow is as follows and explained in detailed from PocketAdvantage order to QuickBooks Sales order followed by the data flow diagram image showing the process map.
Order Integration: The Order integration from Inventiv SQL Server instance and will be from PocketAdvantage. It will periodically retrieve Order data and integrate with QuickBooks Sales Order transactions. The integration data - flow will be incremental in nature and uni-directional with the transfer of data into the QuickBooks system.
...
Proposed Data-Flow Between inventive SqlServer To QB
...
Note |
---|
PockeAdvantage Configuration steps link: PocketAdvantage Connector (How to do the connector configuration in DBSync Platform) |