myBiQ's implementation of ETL (Extract Transform Load)

[Global Data Integrator]

Secure, valid and automatic data Extractor, Transformer and Loader

Based on Pentaho's Kettle Suite (see http://www.pentaho.org) and Talend's Open Studio (http://www.talend.com) we provide with ETL the capability for data integration, streamlining the process of loading disparate corporate data by providing organizations with the ability to perform fast and flexible data loads, helping you gain timely insight into the business performance of your organization.

The Data Integrator provides:

• The ability to gather key business data from multiple sources by using all kind of transportation means: Data pump (online or batch), text and excel files, email, ftp and https.

• Speed and automatic validation of data brings efficiency for these jobs to your desktop - with any size data load

• The capability to quickly build and maintain metadata and data from your current data sources, G/L or ERP system

• An easy-to-use GUI for modeling the transformations, jobs and common data and metadata tasks

• The capacity to manipulate complex data and dimensions (even slow changing dimensions)

• A message window and logging to audit all tasks

• An independent scheduler and event manager to trigger common tasks without impacting the whole system's performance

• With a powerful scripting language (Java Script) critical business rules may be applied on all existing data or just before loading them (more technical details under myBiQ's Website).