Using ETLs with Pentaho Spoon
You can use Pentaho Spoon as an ETL development environment.
- Overview of using Pentaho Spoon
You must first create the source and destination tables and establish the corresponding mappings. Next, you must identify variables that need to be passed into the transform and add these variables to the transform business object or form. Then, you can use Pentaho Spoon and the following steps to define and maintain transforms. - Installing Pentaho Spoon
You can install Pentaho Spoon as an ETL development environment. Use version 3.1, which is the version with which TRIRIGA integrates. - Creating transforms and database connections
You can create transforms and database connections for use between Pentaho Spoon and TRIRIGA - Running a transform from Pentaho Spoon
You can run a transform that is either completed or is in the process of being completed. - Selecting Spoon steps
You can use the Design Mode to select the various Spoon step types and add them to a transform. - Testing the transform
You can test the transform after you add each Spoon step, or at the end when all Spoon steps are complete. Testing after each step makes debugging easier. Before you can test the transform, you must first save the transform. - Date solution
Several date variables require calculation and comparison when used by Pentaho Spoon. Date solution provides these calculations and comparisons. - Moving ETL Scripts into TRIRIGA from Kettle
Once the transform is completed and tested, it must be uploaded to the TRIRIGA ETL job item. - Debugging ETL scripts in the application
To debug ETL scripts in the application, you must first set up logging and then trigger the RunETL Custom workflow task to view the log information. - Performance tuning tips
Use the following tips to improve performance of ETLs with Spoon.
Parent topic: Defining and maintaining ETL transforms