Data Migration and Conversion Tool-QXchange

Data Transfer, Integration and Management Tool

Data management software

Download QXchange Feature List

Data Extraction

Features	Description
Select Source Database	Select the proper source database easily for the given DAP. Specify file name, location and connection information such as user id and password.
Test Connection	Verify that a particular source dataset definition is a working connection.
Encryption Security	Critical information such as User and Password are encrypted with Blowfish 128 bit encryption.
Show full schema	Once source dataset is specified, then the schema of the recordset objects and data items are presented in the UI.
Select Dataset	Specific datasets can be selected and data can be mapped to export. Multiple datasets can be selected and data extracted in a single run.
Individual Data item Selection	Table objects from source can be extracted from.
Extract from Views/Queries	Views/Query objects from source can be extracted from.
Filter Input data	The source data can be limited further by applying filters to the data. The filters can be complex expressions using multiple data items in combination.
View Data	Any dataset object can be selected and the data from that can be immediately viewed in a datasheet view, without actually running the ETL process. The data can be copied and pasted into Excel.

Transformation

Features	Description
Data Item Mapping	Data items can be mapped from any source recordset to target recordset. While mapping the data item names do not have to be the same.
Data conversion	Data can be converted from one format to a different format, such as from text to number and vice versa.
Data combination	Data from multiple data items can be combined together.
Constant data	Constant data items can be assigned to target data items.
Lookup Value	Lookup data from additional dataset objects for specific record and data item values and use the resulting values in the target.
Formula Builder	Build a formula using math, string operations to create target data item. Use functions as part of these formulas.
Function	Views/Query objects from source can be extracted from.
Filter Input data	The source data can be limited further by applying filters to the data. The filters can be complex expressions using multiple data items in combination.
View Data	Use a complete set of data conversion functions, including string, data and financial functions to affect the target data item. Use multiple source data items in these expressions.

Loading

Features	Description
Create dataset	For some dataset formats such as Excel and Text files, create a brand new file. Replace the file if it exists, optionally. Create all the data items and complete schema necessary.
Data Item Mapping	Data items can be mapped from any source recordset to target recordset. While mapping the data item names do not have to be the same.
Check for errors	Log update and other errors as part of the loading process.

Functions

Features	Description
Standard functions	QXchange has a full complement of pre-built excel-like functions to apply against data items. This provides very sophisticated data manipulation activities. The following type of functions are included: -Mathematical and Trigonometric Functions -String Functions -Date & Time Functions -Logical and Conversion Functions -Financial Functions -Statistical Functions -Conversion Functions
Formula Expression	QXChange allows the creation of formula expressions using math, string and logical operators combined with data items, variables, constants and functions. Provides almost any kind of data manipulation.
Constants	Constant values (values that are not available in the incoming data) or very standard values can be defined and used in data manipulation or just setting a target data item. E.g. String example: “USA” Logical example: False Math example: 50
Operators	A comprehensive set of operators are included to be used in Formula expressions: Unar plus (+) and minus (-) Percentage (%) Bitwise Not (~) Bitwise And (&) Bitwise Implication (^~), Equivalence (^&) and Exclusive Or (^\|) Bitwise Or (\|) Power (^) Multiplication (*), Division (/) and Safe Division (//) Addition (+) and Subtraction (-) Comparison Operators (<, <=, >, >=, =, <>) Logical Not (Not) Logical And (And) Logical Or (Or)
Constant data	Constant data items can be assigned to target data items.
Variables	Temporary variables can be defined and used in the expressions. E.g. Comm_Percent_Var
Formula Builder	Build a formula using math, string operations to create target data item. Use functions as part of these formulas.
String Functions	There are many standard string functions. Here are a few samples: Left, Mid, Right: to extract portions of strings Len: to get length of a string Concatenate: to join strings Proper: to capitalize strings Search: to find strings within strings Value: to convert to a number
Math Functions	There are many standard math functions. Here are a few samples: ABS: to remove sign from a number Round: to round values Rand: to generate random numbers Sum: to add up a set of numbers
Date and Time Functions	There are many standard date and time functions. Here are a few samples: Date value: to convert a string to a date Day: to extract day value from a date Month: to extract month value from a date Year: to extract year value from a date Hour: to extract hour from a date time
Logical Functions	It is possible to setup an If clause to do conditional actions while manipulating data.

Copyright, Cellarstone, Inc