View source | Discuss this page | Page history | Printable version   

Modules:IDL ETL Tool Selection

Contents

Introduction

This document describes the process of selecting the ETL tool used to build and execute the processes for the Initial Data Load project. The goal of this document is to keep track of the decision process, and to give to the community feedback in order to facilitate feedback.

Selection process

The goal of this selection process is to have a short list of ETL tools with an small prototype of data load built. After this goal is achieved, the final decision will be done based on the experiences obtained during the evaluation of the tools and the development of prototypes.

The final result of the decission process is the selection of the ETL tool used to build and execute the processes needed for the initial data load of Openbravo ERP, a prototype of the Initial Data Load project based on the tool selected, gain experience on the tool selected and in ETL tools in general.

The selection process will consist in the following steps.

List of tools

Selection criteria

This section lists the selection criteria which play a role in determining the list of ETL tools which we will prototype:

Tools evaluation (Adrián)

This is an small evaluation of the list of ETL tools identified. In my opinion the end the decision will be between Pentaho data integration and Talend Open Studio.

Pentaho data integration (Kettle)

Popularity: Google results > 64600, >10 forum messages a day.

Talend Open Studio

Popularity: Google results > 832000, >15 forum messages a day.

Jitterbit 2.0

Popularity: Google results > 44100, ~2 forum messages a day.

Apatar

Popularity: Google results > 45300, ~2 forum messages a day.

Clover.ETL

Popularity: Goggle results > 25200, ~2 forum messages a day.

Palo BI Suite

Popularity: Google results > 30500, ~ 2 forum messages a day.

Enhydra Octopus

Popularity: Google results > 13700, No official forums found.

Scriptelle

Popularity: Google results > 5540, Forums seem dead.

KETL

Popularity: Google results > 729, Forums seem dead.

Prototype

This section describes the capabilities and goals to achieve in the prototype built for the tools selected.

Scenario

Goals

Retrieved from "http://wiki.openbravo.com/wiki/Modules:IDL_ETL_Tool_Selection"

This page has been accessed 1,125 times. This page was last modified on 11 January 2019, at 11:49. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.