Extract Multiple Data Sources from Databases, Text, Excel, XML, LDAP and Object |
 |
Relational DataSources |
- JDBC/ODBC for databases including Oracle, IBM DB2, SQL Server, Sybase, MySQL, Access, with Query Builder to graphically construct SQL statement with support for SQL variants
- Security option for Read-Only, Hide Details, and Encryption
|
Non- Relational DataSources |
-
Direct Excel retrieval supporting multi-sheets range and named range
-
Multi-lingual encoded Text for CSV, Fixed Width, or RegEx for advanced text extraction, and ARFF, an ASCII format used in data mining
-
XML for XQuery/XPath support with Grouping of Subtree, Object for customizable access to Java Objects, EJB or JavaScript, and direct access to LDAP server
|
Auxiliary Data Sources |
- Create internal data source with Tabular for small data set such as a code table, Properties for a single record, Safe for holding and transmitting encrypted data
- Reference, as a proxy to another data source providing a preset parameter values
- FileSystem to extract file attributes in a folder to be processed as records
|
| |
Visual Data Aggregation across Multiple Heterogeneous Data Sources |
|
Composite Data Sources |
- Visual Modeling of Aggregation with no SQL knowledge required, supporting mixing of different data source types
- Graphical layout of data model for easy diagnostics and maintenance.
|
Join |
- Join different types of data sources with options for Inner, Outer, or Cross Join for selected columns
- Resolve field name conflicts with Prefix
|
Concat |
|
Cache |
- Caching & Staging control for optimizing data traffic and system resource utilization
|
|
| |
Powerful Transformation with Derivative, Filtering, Cube, Cleansing, Sorting, and Scripting |
|
Derivative |
- Transform schema to new field name or derive new fields with built-in or custom functions, with Lookup operator for populating parameterized value
|
Filtering |
- Include range, look up from another data source, or JavaScript for complex filtering
|
Cube |
|
Cleansing |
- Split-Merge mechanism for parallel Subflow processing, including operators for Remove Duplicates and Invert Data
|
Sorting |
- Multi-Level Sorting and Grouping for data preparation with Top/Bottom N Extraction
|
|
| |
Store to Databases, CSV, Text, Excel, XML or Custom Java Data Store |
|
Data Store |
-
Load data to databases through JDBC/ODBC with options for creating new table, replacing or updating existing table by appending records, or record update
-
Export to Excel with multi-sheet option based on data grouping
-
Output to CSV with user-configurable separator and append option and advanced Text output with group header and body configuration for generating custom formats
-
Custom Java DataStore for custom output or interface with other applications
-
XML output with XSLT Transformation option
|
Data Drop |
- Generate to Multiple Output Targets, in parallel if combined with Subflow
|
