QXchange Integration with Sage Intacct

Overview
QXchange is a powerful and easy to use data integration tool to access, integrate and manage large volumes of data from various systems. Extraction, transformation and loading of data are powered by QXchange with source and target database support.

QXchange helps organizations to bond together all enterprise data and ensures accuracy of data in a timely manner. QXchange is a simple stand-alone application that can be used by novice users with ease.

QXchange can quickly and easily transfer data between many standard data formats and applications, including MS Access, Excel, Comma delimited flat file, MS SQL Server, QuickBooks, Salesforce.com, MS Dynamics AX, MS Dynamics GP and others. It allows simple and clear setup of extraction, transformation and loading instructions to exchange data between different formats.
Microsoft Dynamics GP (formerly Great Plains) delivers comprehensive business management functionality, from financials and human resource management to manufacturing and more. It connects the many moving parts of the organization, providing better visibility into and control over what’s going on in business.

QXchange is installed locally at the customer site where GP installed. QXchange sends a message request to GP and GP sends back a response message (using eConnect SDK); the communication is managed synchronously.

QXchange engine works the same for all different DAPs. Every data transfer is set up as a profile, with a source and target data file, which can be of different data formats. Data transfer between specific objects and the mapping of source to target fields are also set up in the profile. The profile can be executed directly or can be scheduled to be executed later. The process can be run on a local desktop or on a server.

Sage Intacct is the only cloud financial management solution with tomorrow’s innovative technology to make your today easier powerful automation to transform your productivity to modern cloud architecture to scale with your growing business.

Technology
Sage Intacct was built to be able to “talk” to your other best-in-class cloud systems with automated two-way, system-to-system communication. With our web services API, you don’t need to worry about complex business logic. You have the flexibility to tailor your connections to your specific workflow processes. And you can be ready to go in a week or less.  

Authentication and Authorization
QXchange uses sign-on information provided by the individual customer to identify itself while communicating through the Sage Intacct. An existing user id and password can be used. The login information is encrypted and stored locally on the user machines. The application and login information are presented to the Sage Intacct authentication system to allow access to the QXchange application.

Use of the login information allows Sage Intacct to enforce access to various data objects based on the same security profile used within the application for direct access.

Data Access Plug-in
QXchange integration engine uses Data Access Plug-ins (DAPs) for individual application and data format integration. All the DAPs are called using a standard Application Program Interface (API). TheSage Intacct API is wrapped inside one of these DAPs. This allows for a smooth and standard operation across all the various DAPs.

QXchange is installed locally at the customer site so that customer data is directly loaded between customer machines and the Sage Intacct without any other third-party applications or web sites.

Importing Data
QXchange imports the data in the Sage Intacct at a faster rate. Facilitates data filtering and formatting according to requirement and enables precise view of the data before filtering process. Enables easy and prioritized maintenance of databases. 

Exporting Data
QXchange enables effective transfer of the data to the databases of Sage Intacct. Facilitates precise view of the data after filtering process. The System also facilities data size validations before initiating the export.

Conclusion
QXchange does a tremendous job, understanding the intricacies of the Sage Intacct data structure as well as the complications inherent in the data integration process. With this ability and its ease of use, it allows users to make more effective use of their Sage Intacct data process.