As of today, PDI is one of the best ETL open source solutions; it is made up of the following components:
- Spoon: This is a desktop application that uses a graphical interface and editor for transformations and jobs. It provides a way for you to create complex ETL jobs without having to read or write code. Any time you author, edit, run, or debug a transformation or job, you will use Spoon.
- Pan: This is a standalone command-line process that can be used to execute transformations and jobs created in Spoon.
- Kitchen: This is a standalone command-line process that can be used to execute jobs.
- Carte: Carte is a lightweight web container that allows you to set up a dedicated, remote ETL server.