Toolsverse ETL Framework Icon

Toolsverse ETL Framework

Open source Extract Transform Load engine written in Java

Add a Review
1 Download (This Week)
Last Update:
Download etl-3.2.zip
Browse All Files
Windows Mac Linux

Screenshots

Description

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

Toolsverse ETL Framework Web Site

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)

Update Notifications





Write a Review

User Reviews

Be the first to post a review of Toolsverse ETL Framework!

Additional Project Details

Languages

English

Intended Audience

Developers, Information Technology

User Interface

Command-line

Programming Language

Java

Registered

2013-01-12
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.