Search
Friday, July 03, 2009   Integration » Data Access Plug-Ins
Data Transfer, Integration and Management Tool

Data Integration Software
Data cleansing software - Buy QXchange
QXchange Inquiry
Contacat Us
 Data Access Plug-Ins Minimize

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, 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.

MySQL

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

  1. 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.
  2. Secure access to the hosted environment is maintained.
  3. Standard and custom salesforce.com objects can be accessed.

SAP Business One

  1. 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.
  2. 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