Toolsverse ETL Framework Icon

Toolsverse ETL Framework

Open source Extract Transform Load engine written in Java

Add a Review
0 Downloads (This Week)
Last Update:
Download etl-3.2.zip
Browse All Files
Windows BSD 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)

KEEP ME UPDATED

Other Useful Business Software

Streamline your development cycle with Swiftype Search Icon

Swiftype connects with GitHub, JIRA, Dropbox and your other cloud sources so your team can find what they need regardless of where it’s located.

Streamline your development cycle with Swiftype Search Icon
Swiftype Enterprise Search enables your team to be more efficient by making all your company’s cloud content available from one place and proactively surfacing relevant information as you work. With Swiftype’s AI-powered search, you will spend less time managing, tracking and searching for files and documents. Simplify your development cycle with Swiftype. Get started with a free trial today.
Write a Review

User Reviews

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

Additional Project Details

Languages

English

Intended Audience

Information Technology, Developers

User Interface

Command-line

Programming Language

Java

Registered

2013-01-12

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, thanks