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.
This DAP allows access to text files. Text files can be fixed length or delimited. Header labels can be used with these files.
This DAP allows access to Excel files. Individual worksheets within an Excel spreadsheet can be accessed. Header labels can be used.
This DAP supports the Microsoft Access database .Tables and query objects can be accessed. New Tables can be created.
This DAP supports the MySQL database format.
This DAP supports the MS SQLServer database format.
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.
- 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.
- Secure access to the hosted environment is maintained.
- Standard and custom salesforce.com objects can be accessed.
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.