A scheduling module allows the selection of a single or a set of profiles to be executed at a specific time, in addition to on-demand. Scheduling can be one-time or recurring.
Extraction module allows the specification various data sources.
|Transformation||Transformation allows the conversion of various data items.|
Loading module allows the creation or update of output data items.
ETL instructions are coded and saved as profiles for re-execution.
|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 a separate component called a Data Access Plug-in (DAP).
Profiles can be established to run at specified times. Scheduled processes can be recurring. Multiple schedules such as daily/weekly can be set up. Scheduling is integrated with Windows Scheduler.
|Process Logging||Process execution is logged for review.|
Errors during the ETL process are logged. At the end of the process, the errors can be reviewed.
System variables such as $Current Date can make available system level values for the profiles. These values can be set by the user as well. These variables can be used as part of the transformation process and can affect target data items. These variables can be also used in source filter expressions.
This is an on-premises application and runs within the customer firewall.