ETL Tools

Provided as a packaged, out-of-the-box, ready-to-install platform, Talend Open Studio meets data integration requirements of all organizations – regardless of their size or level of data integration expertise.

Talend Open Studio consistently delivers robust capabilities to run complex integration processes even in the most demanding environments.

Enhydra Octopus is an advanced open source Extraction/Transformation/Loading -ETL- tool. It can connect to JDBC data sources and perform transformations defined in XML definitions. JDBC drivers for CSV and XML are included.

CloverETL is a Java based ETL framework which can be used to transform structured data. While using JAVA technology it allows for platform independence. It can be used standalone as an application run from command line or can be embedded into an application.

CloverETL Features:

* internally represents all characters as 16bit (Unicode) - any character from any codepage can be represented
* converts from & to most common character sets (ASCII, UTF-8, ISO-8859-1,ISO-8859-2, etc)
* works with delimited or fix-length data records, each field can have different delimiter composed from several characters
* fields can have default values, handles NULL values
* cooperates with any database with JDBC driver
* transforming of the data is performed by independent components, each running as an independent thread - can utilize more than one CPU
* framework implements so called pipeline-parallelism - when data record is processed by component, it is immediately sent to the following component for additional processing.
* metadata describing structure of data files (records) can be read from XML
* transformation graphs can be read from XML

The whole framework is composed from more or less independent pieces which can be used in your application.

KETTLE is a set of open source ETL tools that will all you to manipulate data from various databases. It gives a graphical user environment to describe what you want to do not and how you want to do it.