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-generated apps that pass security review
Retool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Toolsverse ETL Framework!
