Pentaho ETL

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

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 acquired by the Pentaho group and renamed to Pentaho Data Integration. The 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:

To enrich your career and become a Pentaho professional, visit Tekslate, the global online training platform:" Pentaho Training". This course will help you achieve excellence in this field.

-Data extraction from source databases

-Transport of the data

-Data transformation

-Loading of data into a data warehouse

The 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 that makes 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 that allows remote monitoring of the running Pentaho Data Integration ETL processes through a web browser.

 

Check Out Pentaho Tutorials

 

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 In-depth Knowledge on Pentaho click on below:

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.


Stay Updated


Get stories of change makers and innovators from the startup ecosystem in your inbox