• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Pentaho ETL

Pentaho is a company that offers Pentaho Business Analytics, a suite of open source Business Intelligence (BI) products which provide data integration, OLAP services, reporting, dashboarding, data mining and ETL capabilities.

Kettle (K.E.T.T.L.E – Kettle ETTL Environment) has been recently aquired by the Pentaho group and renamed to Pentaho Data Integration. Kettle is a leading open source ETL application on the market. It is classified as an ETL tool, however the concept of classic ETL process (extract, transform, load) has been slightly modified in Kettle as it is composed of four elements, ETL, which stands for:

-Data extraction from source databases

-Transport of the data

-Data transformation

-Loading of data into a data warehouse

Kettle is a set of tools and applications which allows data manipulations across multiple sources.
The main components of Pentaho Data Integration are:

Spoon – a graphical tool which make the design of an ETL process transformations easy to create. It performs the typical data flow functions like reading, validating, refining, transforming, writing data to a variety of different data sources and destinations. Transformations designed in Spoon can be run with Kettle Pan and Kitchen.

Pan – is an application dedicated to run data transformations designed in Spoon.

Chef – a tool to create jobs which automate the database update process in a complex way

Kitchen – it’s an application which helps execute the jobs in a batch mode, usually using a schedule which makes it easy to start and control the ETL processing

Carte – a web server which allows remote monitoring of the running Pentaho Data Integration ETL processes through a web browser.

Interested in mastering Pentaho ?
Learn more about Pentaho Tutorial in this blog post.

Currently, the data sources and supported databases in Kettle ETL are:

Any database using ODBC on Windows

-Oracle

-MySQL

-AS/400

-MS Access

-MS SQL Server

-IBM DB2

-PostgreSQL

-Intersystems Caché

-Informix

-Sybase

-dBase

-Firebird SQL

-MaxDB (SAP DB)

-Hypersonic

-CA Ingress

-SAP R/3 System (using the Pro SAPCONN plugin)

For Indepth Knowledge on Pentaho click on below:

Summary
Review Date
Reviewed Item
Pentaho ETL
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Pentaho ETL"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.