Features of QXchange - Data Integration Software Minimize

Data Extraction 
Download QXchange Feature List pdf
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.

    

 

0
0
0
s2sdefault