toolsverse etl framework

We have hosted the application toolsverse etl framework in order to run this application in our online workstations with Wine or directly.

Quick description about toolsverse etl framework:

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)

Audience: Information Technology, Developers.
User interface: Command-line.
Programming Language: Java.
Database Environment: XML-based, JDBC, Oracle, MySQL, PostgreSQL (pgsql), IBM DB2, Sybase, Microsoft SQL Server, Flat-file.

Categories: