Wednesday, January 28, 2015

Pentaho Data Integration (Kettle) Tutorial

Introduction

Pentaho Data Integration (PDI, also called Kettle ) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Though ETL tools are most frequently used in data warehouses environments, PDI can also be used for other purposes:

  • Migrating data between applications or databases
  • Exporting data from databases to flat files
  • Loading data massively into databases
  • Data cleansing
  • Integrating applications

PDI is easy to use. Every process is created with a graphical tool where you specify what to do without writing code to indicate how to do it, because of this, you could say that PDI is metadata oriented .

PDI can be used as a standalone application, or it can be used as part of the larger Pentaho Suite. As an ETL tool, it is the most popular open source tool available. PDI supports a vast array of input and output formats, including text files, data sheets, and commercial and free database engines. Moreover, the transformation capabilities of PDI allow you to manipulate data with very few limitations.

Through a simple "Hello world" example, this tutorial will to show you how easy it is to work with PDI and get you ready to make your own more complex Transformations.

Source

Related Posts:

  • Keurig Iced Coffee InstructionsPlatinum Brewing System Fill a coffee mug with ice cubes. Place it on on the Platinum Brewer's drip tray. Press the left-most button when offered a ch… Read More
  • How to Build Outdoor Waterfalls InexpensivelySimple Instructions for the "Cheap" (Like Me) In planning to build outdoor waterfalls, you need to concentrate on two structures: the pool into which … Read More
  • Velvet StockingVelvet Stocking - Red Velvet/Ivory Cuff Add to Cart Add to Registry Overview Crafted of luxurious velvet and accented with crisp, high-quality monogra… Read More
  • Nicolas Feuillatte Brut ReserveWinemaker's Notes It is composed of 20% of the Chardonnay grape variety, for elegance and delicacy, 40% of Pinot Noir, for roundness and structure and… Read More
  • Colace stool softenerColace What is Colace (docusate)? Docusate is a stool softener. It makes bowel movements softer and easier to pass. Docusate is used to treat or preve… Read More

0 comments:

Post a Comment