|Extraction module allows the specification of various data sources.
|Transformation allows the conversion of various data items.
|Loading module allows the creation or update of output data items.
|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, MySQL) or type of application (QuickBooks®, Dynamics CRM). For every data format supported, there is a 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.
|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.
Errors during the ETL process are logged. At the end of the process, the errors can be reviewed.
|Allows extract/load data from/to Dynamics GreatPlains accounting system
|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 on source filter expressions.
|This is an on-premises application and runs within the customer firewall.
|This DAP supports the XML data format.
|QXchange has the ability to synch the data between tables. Using this feature the user can synch the data between tables. For example when ever there is an account created in Salesforce the same has to reflected in QuickBooks® accounting application and vice versa. User can achieve this by using this QXchange feature.
|QXchange now has the ability to upload the output files to FTP. The user can configure the FTP details where the files to be uploaded. Upon completion the output files will be uploaded to the configured FTP.
|With this feature the user can set validation rules so that in case if there are any validation errors the user can correct the data prior to the loading. The validation rules are like column should have only number, date format, length of the column etc. If there is any validation error happens QXchange will show the records with validation error so that user can correct the validation errors and resume the data transfer instead of reinitiating the entire cycle.
|This feature allows the user to automatically map the matching column to the target. This avoids the overload of mapping each and every column to the target when the source and target has same set of columns.
|QXchange has the ability to send notification email after profile execution got completed. The user can configure the Email server details to send the notification. Option provided to configure the notification to be sent for all profiles or only on failure.
Data Access Plug-Ins(DAPS)