Home Products Solution Integration Customers Inquiry Resources Company
Data Transfer, Integration and Management Tool
Data Integration Software
Product Demo
QXchange Inquiry
 
Data Access Plug-Ins

Qxchange supports access to many different data formats. These data formats can be types of files (fixed length, comma delimited), type of database (Access, My SQL) or type of application (QuickBooks, SAP Business One). 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
This DAP allows access to text files. Text files can be fixed length or delimited. Header labels can be used with these files.

Excel
This DAP allows access to Excel files. Individual worksheets within an Excel spreadsheet can be accessed. Header labels can be used.

MS Access
This DAP supports the Microsoft Access database .Tables and query objects can be accessed. New Tables can be created.

My SQL
This DAP supports the MySQL database format.

MS SQLServer
This DAP supports the MS SQLServer database format.

QuickBooks
This DAP supports the QuickBooks file format. It uses the vendor supplied QuickBooks SDK to do all the access and hence is compatible with all versions supported by the SDK. Secure access to the environment is maintained.

Salesforce.com
01. This DAP supports the Salesforce.com hosted environment. It uses the vendor supplied AppExchange SDK and API  to do all  access and hence is compatible with all versions supported by the vendor.
02. Secure access to the hosted environment is maintained.
03. Standard and custom salesforce.com objects can be accessed.

SAP Business One
01. This DAP supports the SAP Business One file format. It uses the vendor supplied SAP B1 SDK to do all the access and hence is compatible with all versions supported by the SDK.
02. Secure access to the environment is maintained.

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.

 
Copyright, Cellarstone, Inc