Data Integration Perspective in the PDI Client
The Data Integration perspective of Spoon enables you to create two basic file types:
- Transformations are used to perform ETL tasks.
- Jobs are used to orchestrate ETL activities, such as defining the flow and dependencies for what order transformations should be run, or preparing for execution by checking conditions.
The following sections describe how to use these transformations and jobs within the Data Integration perspective of Spoon:
| Section | Description |
|---|---|
| Basic Concepts of PDI: Transformations, Jobs and Hops | Learn about terms like transformation, step, hop, and job. |
| PDI Client (Spoon) Options Dialog | Adjust the look and feel of Spoon. |
| Working with Transformations | Discover how to create and use transformations. |
| Inspecting Your Data | Gain valuable insights into the data of most steps through visualizing and interacting with your data. |
| Working with Jobs | Discover how to create and use jobs. |
| Arguments, Parameters, and Variables | Learn how to work with user inputs. |
| Performance Monitoring and Logging | Configure logging to monitor transformation or job progress. |
| Interact with Web Services | Determine what must occur if your transformation or job interacts with a web service. |
| Using the SQL Editor | Learn how to generate SQL statements. |
| VFS File Dialogues in Spoon | Learn what steps and plugins use Virtual File System (VFS) dialogues. |
| Reusing Transformation Flows with Mapping Steps | Learn how to map commonly used steps into their own steps. |
| Using Notes with Transformations and Jobs | Create and manage notes to your transformations and jobs. |
| Using the Database Explorer | Explore configured database connections. |
| Use Checkpoints to Restart Jobs | Learn how to restart a job at the last checkpoint before an error occurred. |
| Transactional Databases and Job Rollback | Implement job rollback by making the transformation or job databases transactional. |