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
Feature
- 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)
miMas - GUI tool for SQL developers
miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available.
The tool uses JDBC drivers for connecting to a database. For most popular databases.........
GETL
P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven.
GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL».
GETL is a set of libraries of pre-built.........
JobScheduler
JobScheduler runs executables, scripts and database procedures and can be operated with e.g. MySQL, PostgreSQL, SQL Server, Oracle databases.
JobScheduler provides sequential and parallel task execution, job chains, cross-platform scheduling, events, job synchronization, load sharing, fail-over an.........
Open Source Data Quality and Profiling
This project is dedicated to open source data quality and data preparation solutions. Data Quality includes profiling, filtering, governance, similarity check, data enrichment alteration, real time alerting, basket analysis, bubble chart Warehouse validation, single customer view etc. defined by Str.........
XML Editor/Validator/Designer with CAMV
The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JS.........
SymmetricDS
SymmetricDS is a data and file sync/replication solution. It is a platform-independent, web-enabled, and database-agnostic synchronization tool. SymmetricDS was built to replicate changes, bi-directionally, between remote nodes and a centralized node....
The Ring Programming Language
The Ring is an Innovative and practical general-purpose multi-paradigm scripting language that can be embedded in C/C++ projects, extended using C/C++ code and/or used as standalone language.
The supported programming paradigms are Imperative, Procedural, Object-Oriented, Functional, Meta programmi.........
JPPF
JPPF makes it easy to parallelize computationally intensive tasks and execute them on a Grid....
Icarus Scene Engine
Icarus Scene Engine is a cross-platform, CLS-compliant 3D framework, integrating open source APIs into a cohesive all-open-source, all .NET solution. For Windows, MacOSX & Linux.
Uses OpenTK, OpenGL, OpenAL APIs for graphics and audio. Runs on Mono/.NET. Links to FFMpeg for streaming video, and Fre.........
Lioness (Languages Interop Framework)
Framework for making Windows applications that are one .exe file in AutoHotKey_L,C++,C#, VB.NET,Java,Groovy,Common Lisp,Nemerle,Ruby,Python,PHP,Lua,Tcl,Perl,Jint,S#,WSH VBScript,HTML/JavaScript/CSS,COM, PowerShell without compiling . For .NET 4....
