ETL4ALL Product Sheet

Content of this page :

1. Overview

ETL4ALL is a tool for enterprise wide, engine driven data extraction, data transformation and data delivery. It enables knowledge workers, analysts and other end users to turn rough operational data into valuable business insights. ETL4ALL's unique architecture and design result in an unseen set of features.

2. High Usability

 

Everywhere, management information systems, reporting applications and other solutions measuring business performance need to tap in an ever-growing number of operational data. Their users - managers, analysts, and knowledge workers alike - need to transform their data into ever-new reports, models and spreadsheets. ETL4ALL is the one solution that can meet all requirements - in a single environment that is extremely easy to use.

  • Visual composition of transformations
    The ETL4ALL client consists of an easy to use graphical user interface, equipped with a drag-and-drop functionality for building data integration rules.
  • Library of pre-built transformations
    ETL4ALL maintains an extensive library of more than 100 pre-built transformation functions, which can be extended easily.
  • Reporting as you like
    • Excel files
    • Compatibility with third-party reporting tools
    • JFreeReport embedded
  • Engine driven
    Regular users are not confronted to any complex configuration issues.

3. Flexibility

ETL4ALL allows users to extract operational data in real-time, as events occur in the transactional systems. No longer being bound by the restriction of only weekly refreshments of operational data, end users can now use ETL4ALL to enhance existing business intelligence applications or have it bring the right data at the right moment to new report models, new spreadsheets or new dashboards.

4. Scalability

  • Standalone...
    In its simplest configuration, ETL4ALL runs on a single machine.
  • ...or as a distributed application
    ETL4ALL can easily be reconfigured into a fully distributed application, with its different components running in a cluster of application servers.

5. Openess

ETL4ALL's openness is guaranteed through the deployment of industry standards, including built-in and JDBC connectivity, web technology, SOAP, XMI and XSLT.

  • Built-in connectivity
    ETL4ALL has built-in access to Microsoft Excel, CSV files, XML files and Xindice (an XML database).
  • JDBC
    Other data sources are accessed using JDBC. This guarantees :
    • A virtually unlimited number of supported data sources.
    • High quality data access.
    • Excelling performance.
  • Web technology
    The different ETL4ALL components can run as servlets in an application servers servlet container. This ensures :
    • Access control and security.
    • Configurable performance through clustering.
    • Loosely coupled components.
  • SOAP
    Through the use of SOAP, the ETL4ALL server is accessible for applications running on any platform or environment.
  • XMI
    The server maintains an XMI compliant repository, open for other tools.
  • XSLT
    Data transformations are done in a user-specified TraX compliant XSLT engine.