Download
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)
Project Samples
License
GNU Library or Lesser General Public License version 3.0 (LGPLv3)Other Useful Business Software
AI-powered service management for IT and enterprise teams
Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Toolsverse ETL Framework!