DataStudio_en

Advantages

Rich and intuitive GUI

DataStudio has many panels simplifying design and deployment of ETL processing.

espace 10x10

Easy to use and easy to design

The numerous helpers, the comprehensive HTML documentation full of examples as well as high level functions and the SQL approach for transformations allow for both simplicity and effectiveness.

espace 10x10

Performance based on EL-T architecture, parallel processing and massive bulk loading technology

parallelisatio

With the EL-T architecture, data is processed before or after transfer. The transformations, always handling large scale data sets, are done closer to the data source or target allowing access to very powerful tranformations.

Parallelization on a single click and massive data loading technologies complement the performance of the processing from one end to the other of the processing chain.

espace 10x10

DataStudio engine optimized in native code : no waste of resources

moteur

DataStudio is coded in C++ so as to optimize processor load and memory usage.

Thus, the power of your machine is used for true data processing and not for running countless abstraction layers.

espace 10x10

Business format connectors : ETEBAC, EDIFACT, NOEMIE...

formats_metier

Business formats are seen as data zones containing table type data objects accessible with SQL queries. Access to these data is thus simplified despite the possible great complexity of the underlying format.

This approach allows easy and standardized integration of multi-source data in information systems.

espace 10x10

ERP, CRM, mainframes and non relationnal data connectors

applications_metier

Just as with business formats, access to ERP, CRM, ... is done in SQL.

espace 10x10

Integrated reporting module

reporting

DataStudio drives reporting features of "Crystal reports" runtime engine.

The combination of DataStudio ETL for data extraction and processing and the reporting on this pre-processed data gives a rational and powerful platform.

Indeed, reporting tools are specialized in graphical layout and are much more efficient when information is already extracted, filtered, cleaned, ...

espace 10x10

Data quality management (standardization, deduplication...)

Data quality management can be done at different levels. When reading data from a source (especially when reading files), while data transfers (line by line or block by block), by executing business rules.

DataStudio data quality error behavior can be completely specified or left to default behavior.

espace 10x10

Integrated platform : design, meta-data, version management, deployment, scheduling, monitoring, ...

All the tools needed for implementing a true professional information system are part of the DataStudio platform, from design to deployment, reuse of validated ETL processes and resources version management.

espace 10x10

Centralized, shared and secured repository in database

referentiel

All the settings of data ETL processes are stored in a database, which provides the needed security and allows system administrators to easily insert the DataStudio platform in their administration process.

espace 10x10

Comprehensive Service Oriented Architecture (SOA)

web_services

DataStudio SOA framework makes it easy to integrate ETL processing in a modern service oriented architecture but also to combine other external services to create a new high added value ETL processing.

It will of course be possible to publish it as a service itself.

espace 10x10

Availability on Windows, Linux and Unix

The same version of DataStudio can be deployed on Windows, Linux or Unix platform. All platform DataStudio versions use the same settings repository to run the ETL processing without any update.

espace 10x10

Reusing and enhancing legacy

DataStudio can drive and integrate legacy processing developped in other technologies, other languages, enhancing it while adding the power and connectivity of ETL technology to the whole system.