DATA ETL FEATURES
 

Extraction-Transformation-Loading (ETL) and Data Aggregation, Cube and Cleansing

  • Increase productivity with minimal learning curve where no programming or SQL is required
  • Flexibility visual modeling interface for creating and editing data processing steps
  • Powerful built-in data operations with JavaScript and support for custom functions
  • Eliminate data errors and increase effficiency by automating with time, data and logic activation
 
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

  • Intersection or Union for row merging
 
     

Cache

  • Caching & Staging control for optimizing data traffic and system resource utilization
   
Powerful Transformation with Derivative, Filtering, Cube, Cleansing, Sorting, & 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

  • Built-in multi-dimensional Cube engine with multi-measure support and user definable functions
 
 

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
Copyright © 2012 Elixir Technology Pte Ltd. All rights reserved. [ Sitemap ]