ETLSE

ETL Integrator is a Data Integration tool which can be used to preform extract - transform - load to build DataWarehouse or can be used for Data Migration.

ETL Integrator is designed to manage and orchestrate high-volume, high-performance data transformation from within the SOA tier. ETL Integrator, along with Open ESB platform, offers a comprehensive enterprise integration infrastructure. ETL Integrator is an enterprise module optimized for extracting, transforming, and loading bulk data between files and databases. It provides connectivity to a vast range of heterogeneous and diversified data sources including non relational data sources. It provides an ETL development and runtime environment that is fully integrated into Open ESB and Netbeans Enterprise Pack and optimized for handling very large record sets.

Platform: Linux;License: CDDL

Reference: https://wiki.open-esb.java.net/Wiki.jsp?page=ETLSE

JasperETL

JasperETL is easy to deploy and out-performs many proprietary and open source ETL systems.

Platform: Linux;License: GNU GPL

Reference: https://jasperforge.org/projects/jasperetl

Pentaho

Pentaho is the open source business intelligence leader. Thousands of organizations globally depend on Pentaho to make faster and better business decisions that positively impact their bottom lines.

Platform: Linux, Windows;License: GNU GPL

Reference: https://www.pentaho.com/

Scriptella

Scriptella is an open source ETL (Extract-Transform-Load) and script execution tool written in Java.

Our primary focus is simplicity. You don't have to study yet another complex XML-based language - use SQL (or other scripting language suitable for the data source) to perform required transformations.

Platform: Linux, Windows, Mac OS X;License: Apache

Reference: https://scriptella.javaforge.com/index.html

Apatar

Apatar brings a set of advantages to the end- users, developers and partners:flexible deployment options, No Coding! visual job designer, No Coding! transformation mapper, modular and open applications, and open source architecture.

CloverETL Community Edition

CloverETL is a high performance data integration platform that enables you to move data between different locations.

Xineo XIL

Xineo XIL (XML Input Language) is an XML-based language for transforming record-based data sources into XML documents. A simple command-line tool is available to run Xineo XIL. This implementation has built-in support for relational (via JDBC) and structured text (like CSV) sources. It is extensible thanks to its public API and provides an abstraction over output format.

CB2XML

CB2XML (CopyBook to XML) is a COBOL CopyBook to XML converter written in Java and based on the SableCC parser generator. This project includes utilities to convert an XML instance file into its COBOL copybook equivalent string buffer and vice versa.

Joost

Joost is a Java implementation of the Streaming Transformation for XML (STX) language.

Babeldoc

Babeldoc is a framework and set of applications to process documents for business-to-business and other Internet/integration applications. It is primarily intended for text documents, especially XML, but supports a wide range of operations and data types.