ETL

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.

Jitterbit is an open source integration technology that allows organizations to quickly and easily integrate:

- Enterprise Apps - Peoplesoft, JD Edwards, Salesforce.com, SAP, Netsuite, SugarCRM, Compiere, Vtiger CRM, OpenMFG, and many more!

- Databases - Oracle, SQL Server, DB2, mySQL, Microsoft Access, Visual Fox Pro, and many more!

- Other Systems - Web Services, Simple and Complex Flat Files (e.g. csv, heirarchical) XML, Active Directory, LDAP, Bugzilla, and many more!

Microsoft SQL Server 2008 provides a scalable enterprise data integration platform with exceptional Extract, Transform, Load (ETL) and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources.

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.

Apatar is an open source data integration and ETL tool written in Java, with powerful Extract, Transform and Load capabilities, that enables anyone to join their on-premise data sources with the Web without coding.

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.

Subscribe to ETL