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.

 Text File

Allows to extract/write data from/to text files.The supported file formats are given below

  1. Text files
  2. Fixed length file
  3. Tab delimited file
  4. CSV file 

Excel

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.

  1. Excel 2003
  2. Excel 2007 and later

MS Access

The DAP can get/put the data from Microsoft Access databases.The supported version are given below

  1. MS Access 2003
  2. 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.

MS SQLServer

Allows to extract data and store data from/to SQL Server databases.The supported SQL Server versions are given below.

  1. MS SQL Server 2000
  2. MS SQL Server 2005
  3. MS SQL Server 2008 and later

QuickBooks

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.

Salesforce.com

DAP allows to read/write data from/to Salesforce.com opportunities, accounts, pricebooks, products and other custom objects.

Sugar CRM

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.

Tally

This DAP supports to extract/load data from/to ledger, groups, stock and other objects.The supported SQL Server versions are given below.

  1. Tally ERP 9.2 and later


Xero

This DAP can talk with Xero and able to retrieve/create accounts, opportunities and transactions.

Magento

This DAP is having the ability to read and write the e-commerce data from/to Magento.

PayPal

This DAP can communication with your PayPal account and it can read/create customers, and transactions.

Peachtree

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.

Accounting Seed

DAP allows to read/write data from/to Accounting Seed opportunities, accounts, products and other custom objects.

ACORD

DAP is having the ability to read the ACORD objects from the deployed instance.

EFI Radius

This DAP is having the ability to read and write the customers, products and invoices data from/to EFI
Radius

Mantis BT

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.

SAP B1

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.

WebKPI

Allows extract/load data from/to webKPI BI tool. It can upload report data to the system and it can be extracted also.

Report DAP

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.

QCommission

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.

NetSuite

DAP allows to read/write data from/to NetSuite invoices, accounts, products and other custom objects.

ODBC

This DAP supports the use of ODBC connections. This will allow access to any data format supported by an ODBC driver.

XML

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.

ConnectWise

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.