Request a quote now!
Compact, modular, high performance and embeddable ETL engine written in Java.
ETL Framework allows you to create data integration and ETL scenarios using XML-based language or Java. You can easily embed framework in your application or deploy it as a Web application and connect to the open API. There is a wide selection of built-in transformations and you can develop your own using JavaScript and SQL.
The most common data integration, ETL and data migration problems solved by ETL framework:
- Ability to embed ETL engine in your application and take only components that you need.
- Ability to use XML-based language or Java to create ETL scenarios.
- Ability to extend functionality by adding plugin modules.
- Native support for wide selection of SQL and Non SQL data sources.
- High performance data integration and ETL.
- Real time and batch data movements and transformations.
- Any-to-any data migration
Some unique features of the ETL framework available to developers:
- Automatic data type translation.
- Data streaming.
- Parallel extract and load.
- Real time data movements and data transformations.
- Batch processing.
- Support for bind variables.
- Creating schema objects on the fly using source as a pattern. For example table can be automatically created if it doesn’t exist.
- Column transformations: calculate value, add, remove, change data type.
- Dataset transformations: filter, order by, set operations, de-normalization, de-duplication, matrix transformations, XLT transformations.
- Dimension transformations: add dimension, extract dimension.
- Data quality features and validation using SQL, JavaScript, other scripting languages and regex.
- Support for pluggable scripting languages such as JavaScript and Ruby.
- Using of databases specific features: language constructs, cursors, temporary tables, exception handling, external tools.
- CLOB and BLOB support.
- Common tasks such as OS commands, support for file-based operations such as copy, delete, rename, etc, sending emails.
Read more about Toolsverse ETL Framework.