ETL Framework is a standalone Extract Transform Load engine written in Java. It includes executables for all major platforms and can be easily integrated into other applications.
Key Features:
* embeddable, open source and free
* fast and scalable
* uses target database features to do transformations and loads
* manual and automatic data mapping
* data streaming
* bulk data loads
* data quality features using SQL, JavaScript? and regex
* data transformations
Requirements
* Java 1.6 and up
* At least 4 MB of RAM
New in 3.2 (01/18/2013)
* Improved auto-update functionality
* Bug fixes
Features
- Supported operating systems - Windows, OS X, Linux/Unix
- Supported databases - any JDBC, any ODBC
- Extended database support - Oracle,DB2,MS SQL Server,MySQL,ProgreSQL,Informix,Sybase ASE
- Supported data sources - delimited text, fixed length text, Excel xls, Excel xlsx, XML, XML with transformation, custom using pluggable connectors
- Transformations - regex, xsl, JavaScript, SQL, sorting, transpose, filtering, remove duplicates, union, minus, join, pivot, de-normalize
- XML-based scenario language
- Extract data from multiple sources and load into multiple destinations
- Stream unlimited data sets from the source to destination
- All data types supported including CLOBs and BLOBs with automatic or manual conversion between source and destination databases (data sources)
- Automatic and manual column level mapping
- Extract and load each data set in parallel with forks and joins
- Inner scenarios with conditional and in-loop execution
- Automatic table and index creation based on the source data set specification
- Manual and automatic transaction management (commit intervals)
- Per field functions in SQL and JavaScript
- Support for automatic primary/foreign key generation with mapping to existing primary/foreign key
- Data quality features and validation using SQL, JavaScript and regex
- Conditional (IF-THEN-ELSE) execution
- Automatic and manual exception handling
- Automatic Insert/Update/Delete/Merge
- In-line SQL in scenarios
- Pre/post/inline extract and load tasks
- OS command execution
- File-based tasks (file system, ftp and sftp are supported)
License
GNU Library or Lesser General Public License version 3.0 (LGPLv3)
You Might Also Like
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Toolsverse ETL Framework!