Projects tagged ‘etl’

A little set of tools that I build in order to make my work easier. Mainly extentions to Castle and NHibernate.

K.E.T.T.L.E (Kettle ETTL Environment) is a meta-data driven ETTL tool. (ETTL: Extraction, Transformation, Transportation & Loading) This means that no code has to be written to perform complex data ... [More] transformations. Environment means that it is possible to create plugins to do custom transformations or access proprietary data sources. Kettle is LGPL licensed [Less]

Talend's flagship product, Talend Open Studio, is the most open, innovative and powerful data integration solution on the market today. Provided as a packaged, out-of-the-box, ready-to-install ... [More] 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. [Less]

Apatar is an open source data integration application to help join your desktop data with the web. Apatar effectively integrates data and applications, and provides visual job designer and mapping ... [More] , joins, filtering, data cleansing and validation capabilities. Connectors include MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SalesForce.Com, SugarCRM, Compiere ERP, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon, RSS and even Flickr; more connectors are under way. [Less]

Scriptella is an ETL (Extract-Transform-Load) and script execution tool. Its primary focus is simplicity. It doesn't require the user to learn another complex XML-based language to use it, but allows ... [More] the use of SQL or another scripting language suitable for the data source to perform required transformations. Main features: * Simple and minimalistic XML syntax for ETL scripts. * Built-in providers for JDBC, CSV, Text, XML, LDAP, Lucene and Velocity. * Support for many useful JDBC features, e.g. parameters in SQL including file blobs and JDBC escaping. * Easy-to-Use as a standalone tool or Ant task. No deployment/installation required. Easy-To-Run ETL files directly from Java code. * Seamless integration with Java/Java EE and Spring [Less]

CloverETL is an Commercial Open Source, 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 ... [More] standalone - as a server application or can be embedded in other applications as a library. [Less]

ChronicleDroid assist in creating ETL mappings for tracicking changes on a existing OLTP Schema. ChronicleDroid implements The Data Vault architecture. Currently in early development stage

A custom Data Flow component for SQL Server Integration Services (SSIS) that replaces the standard SCD Wizard with a superior experience, from the configuration UI to runtime performance. Performs ... [More] 100x faster than the standard component, and edits are non-destructive. [Less]

Palo ETL Server is a Java based Tool for Extraction, Transformation and Loading of mass data into the Palo OLAP Server - This project is integrated into Palo BI Suite and will no longer be updated.

Fusion is an open source Application and Data Integration Platform that allows developers and end-users to integrate and transform information using a web-based drag-and-drop interface that doesn't ... [More] require coding or programming skills. Fusion can access and consolidate data from legacy systems, SQL databases, SOAP/REST Web Services, Excel files, HTML pages, RSS, E-mail, FTP/WebDAV/SMB repositories, CSV, Zip files and DNS lookups. [Less]