QXchange

QXchange, developed by CellarStone Inc., is data integration software designed to facilitate the process of extracting, transforming, and loading data for companies of varying sizes. This software is aimed at business analysts, data analysts, IT professionals, sales and marketing teams, as well as finance and accounting departments across multiple industries. QXchange offers a range of features that aim to simplify data integration tasks and improve efficiency in data management.

Key Features

Extraction: According to the vendor, QXchange allows users to specify various data sources and extract data from applications and databases such as Access and MySQL.

Transformation: The software offers a mapping feature that enables users to convert and manipulate data items by mapping them from source to target recordsets. QXchange provides pre-built Excel-like functions for data manipulation and allows users to apply functions against data items.

Loading: QXchange supports the creation or update of output data items, enabling users to load data into applications like QuickBooks and Salesforce, as well as different data formats such as fixed length and CSV files. The software also provides the ability to load data into databases like MySQL and Microsoft Access.

Profiles: According to the vendor, QXchange allows users to code and save ETL instructions as profiles for re-execution. This feature enables the reuse of profiles for data transfer processes. QXchange Lite, a Windows tool, is used to create and modify profiles, which can then be used in QXchange Online.

Data Access Plug-ins: QXchange supports access to various data formats, including files (fixed length, comma delimited, TAB delimited), databases (Access, MySQL), and applications (QuickBooks, Salesforce). The software allows the addition of Data Access Plug-ins (DAPs) for accessing new data formats.

Scheduling: Profiles can be scheduled to run at specified times, supporting both one-time and recurring scheduling. QXchange seamlessly integrates with Windows Scheduler, enabling users to set up multiple schedules, such as daily or weekly.

Process Logging: According to the vendor, QXchange logs the execution of processes, providing a record of the performed data integration tasks. This feature assists in tracking and troubleshooting data transfer processes, ensuring transparency and accountability.

Error Logging: The software logs errors encountered during the ETL process, facilitating the identification and resolution of errors. QXchange provides a comprehensive view of the errors, enabling efficient troubleshooting and debugging of data integration processes.

System Variables: QXchange offers system-level values for profiles, allowing users to use system variables in the transformation process. Users can set these variables and utilize them in source filter expressions.

Installation: QXchange is an on-premises application that runs within the customer's firewall. It requires installation on the customer's system, providing data integration capabilities within the customer's infrastructure.