Pentaho Data Integration Tutorial.

    Hi Guys,

                              By this tutorial, I am going to explain you the features of Pentaho data integration (a.k.a Kettle).

What is ETL:

                In computing, Extract, Transform and Load (ETL) refers to a process in database usage and especially in data warehousing that :

• Extract is the process of reading data from a database.
• Transform is the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
• Load is the process of writing the data into the target database.

                ETL is used to migrate data from one database to another, to form data marts and data warehouses and also to convert databases from one format or type to another.

PDI provides you the tool which is visualized to eliminate the coding and complexity. Just drag and Drop the required input ,output & transform the data as per the business logic.

        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