Data Access Plug-Ins
QXchange supports access to many different data formats. These data formats can be types of files (fixed length, comma, semicolon, TAB delimited), type of database (Access, MySQL) or type of application (QuickBooks). For every data format supported, there is as separate component called a Data Access Plug-in (DAP). This allows sophisticated data format specific operations to be done. The DAPs are also optimized for the underlying data structures. The DAPs also enforce the security required by the underlying data structure.
Allows to extract/write data from/to text files.The supported file formats are given below
- Text files
- Fixed length file
- Tab delimited file
- CSV file
Allows to extract data from excel spreadsheets. Also, it allows to create new excel file and ability to write the data in it.Supporter Excel versions are Given below.
- Excel 2003
- Excel 2007 and later
The DAP can get/put the data from Microsoft Access databases.The supported version are given below
- MS Access 2003
- MS Access 2007 and later
MY SQL DAP
The DAP can communicate with MySQL server and able to read/write the data from MySQL databases.The MySQL can be hosted in a network or a system.
Allows to extract data and store data from/to SQL Server databases.The supported SQL Server versions are given below.
- MS SQL Server 2000
- MS SQL Server 2005
- MS SQL Server 2008 and later
The DAP is having the ability to communicate with QuickBooks Desktop and QuickBooks Online versions.It can read the customers and their invoices with respective payments and the bills related to the vendors.
DAP allows to read/write data from/to Salesforce.com opportunities, accounts, pricebooks, products and other custom objects.
Allows to get/put data from/to Sugar CRM system. It can read Customers, opportunities, products and other objects and it can also be created to the system.
This DAP supports to extract/load data from/to ledger, groups, stock and other objects.The supported SQL Server versions are given below.
- Tally ERP 9.2 and later
This DAP can talk with Xero and able to retrieve/create accounts, opportunities and transactions.
This DAP is having the ability to read and write the e-commerce data from/to Magento.
This DAP can communication with your PayPal account and it can read/create customers, and transactions.
Allows extract/load data from/to Peachtree accounting system. It can read Customers, Products, and Invoices and it can also be created to the system. The supported versions are Peachtree Quantum 2009 and Quantum 2010.
Sage 50 US
DAP allows to read/write data from/to Sage 50 Customers, Products, Invoices and other objects. Supported versions are Sage 50 US 2015, 2016 and 2017.
DAP allows to read/write data from/to Accounting Seed opportunities, accounts, products and other custom objects.
DAP is having the ability to read the ACORD objects from the deployed instance.
This DAP is having the ability to read and write the customers, products and invoices data from/to EFI
Allows get/put data from/to Mantis Bug Tracker. It can read Issues, Categories, Status and other objects and it can also be created to the Mantis Bug Tracker system.
Allows extract/load data from/to webKPI BI tool. It can upload report data to the system and it can be extracted also.
This DAP allows extracting the data from Excel/CSV reports. It has the ability to mention the headers and also it has the ability to ignore lines between reports and so on.
The DAP can communicate with QCommission application and able to read/write the data from/to QCommission. The QCommission application can be hosted in a network or in a system.
DAP allows to read/write data from/to NetSuite invoices, accounts, products and other custom objects.
This DAP supports the use of ODBC connections. This will allow access to any data format supported by an ODBC driver.
This DAP supports the XML file format. XML tags can be used as data item labels.
Microsoft Dynamics GP
Allows extract/load data from/to Dynamics GreatPlains accounting system. It can read Customers, Products, and Invoices and it can also be created to the system.
Microsoft Dynamics AX
Allows extract/load data from/to Dynamics AX system. It can read Customers, Products, and Invoices and it can also be created to the system.
Microsoft Dynamics CRM
Allows extract/load data from/to Dynamics CRM system. It can read Customers, Products, and opportunities and it can also be created to the system.
Allows extract/load data from/to ConnectWise helpdesk system. It can read Customers, Products, and Service tickets and it can also be created to the system.
This DAP supports data exchange for automotive OEMs, insurers, and other partners who want to leverage and drive value for connected data.
SuiteCRM is a software fork of the popular customer relationship management system from SugarCRM. It became popular when SugarCRM decided to stop development of its open source version.
Allows extract/load data from/to Sage Intacct,Sage Intacct is a provider of cloud-based accounting software.