Getting Started with Pentaho Data Integration
Pentaho Data Integration and Pentaho BI Suite
Time for action - installing PDI
Launching the PDI graphical designer: Spoon
Time for action - starting and customizing Spoon
Time for action - creating a hello world transformation
Time for action - running and previewing the hello_world transformation
Time for action - installing MySQL on Windows
Time for action - installing MySQL on Ubuntu
Getting Started with Transformations
Time for action - reading results of football matches from files
Time for action - reading all your files at a time using a single Text file input step
Time for action - sending the results of matches to a plain file
Time for action - updating a file with news about examinations
Time for action - running the examination transformation from a terminal window
Time for action - getting data from an XML file with information about countries
Time for action - reviewing examinations by using the Calculator step
Time for action - reviewing examinations by using the Formula step
Calculations on groups of rows
Time for action - calculating World Cup statistics by grouping data
Time for action - counting frequent words by filtering
Time for action - finding out which language people speak
Time for action - browsing new PDI features by copying a dataset
Time for action - assigning tasks by distributing
Splitting the stream based on conditions
Time for action - assigning tasks by filtering priorities with the Filter rows step
Time for action - assigning tasks by filtering priorities with the Switch/ Case step
Time for action - gathering progress and merging all together
Time for action - giving priority to Bouchard by using Append Stream
Transforming Your Data with JavaScript Code and the JavaScript Step
Doing simple tasks with the JavaScript step
Time for action - calculating scores with JavaScript
Time for action - testing the calculation of averages
Time for action calculating flexible scores by using variables
Reading and parsing unstructured files
Time for action - changing a list of house descriptions with JavaScript
Avoiding coding by using purpose-built steps
Time for action - enhancing a films file by converting rows to columns
Time for action - calculating total scores by performances by country
Time for action - enhancing the matches file by normalizing the dataset
Generating a custom time dimension dataset by using Kettle variables
Time for action - creating the time dimension dataset
Time for action - getting variables for setting the default starting date
Validating Data and Handling Errors
Time for action - capturing errors while calculating the age of a film
Time for action - aborting when there are too many errors
Time for action - treating errors that may appear
Avoiding unexpected errors by validating data
Time for action validating genres with a Regex Evaluation step
Time for action - checking films file with the Data Validator
Introducing the Steel Wheels sample database
Time for action - creating a connection with the Steel Wheels database
Time for action - exploring the sample database
Time for action - getting data about shipped orders
Time for action - getting orders in a range of dates by using parameters
Time for action - getting orders in a range of dates by using variables
Time for action - loading a table with a list of manufacturers
Time for action - inserting new products or updating existent ones
Time for action - testing the update of existing products
Eliminating data from a database
Time for action - deleting data about discontinued items
Performing Advanced Operations with Databases
Time for action - populating the Jigsaw database
Time for action - using a Database lookup step to create a list of products to buy
Time for action using a Database join step to create a list of suggested products to buy
Introducing dimensional modeling
Time for action loading a region dimension with a Combination lookup/update step
Time for action - testing the transformation that loads the region dimension
Time for action - keeping a history of product changes with the Dimension lookup/update step
Time for action - testing the transformation that keeps a history of product changes
Time for action - creating a simple hello world job
Receiving arguments and parameters in a job
Time for action - customizing the hello world file with arguments and parameters
Running jobs from a terminal window
Time for action - executing the hello world job from a terminal window
Using named parameters and command-line arguments in transformations
Time for action - calling the hello world transformation with fixed arguments and parameters
Deciding between the use of a command-line argument and a named parameter
Running job entries under conditions
Time for action - sending a sales report and warning the administrator if something is wrong
Creating Advanced Transformations and Jobs
Enhancing your processes with the use of variables
Enhancing the design of your processes
Time for action - generating files with top scores
Time for action - calculating the top scores with a subtransformation
Time for action - splitting the generation of top scores by copying and getting rows
Time for action - generating the files with top scores by nesting jobs
Iterating jobs and transformations
Time for action - generating custom files by executing a transformation for every input row
Developing and Implementing a Simple Datamart
Time for action - loading dimensions for the sales datamart
Extending the sales datamart model
Loading a fact table with aggregated data
Time for action - loading the sales fact table by looking up dimensions
Getting facts and dimensions together
Time for action - loading the fact table using a range of dates obtained from the command line
Time for action - loading the sales star
Getting rid of administrative tasks
Time for action - automating the loading of the sales datamart
Integrating PDI and the Pentaho BI suite
PDI Enterprise Edition and Kettle Developer Support
Pan and Kitchen: Launching Transformations and Jobs from the Command Line
Pan and Kitchen: Launching Transformations and Jobs from the Command Line
Pan and Kitchen: Launching Transformations and Jobs from the Command Line
Pan and Kitchen: Launching Transformations and Jobs from the Command Line
Pan and Kitchen: Launching Transformations and Jobs from the Command Line
Quick Reference: Steps and Job Entries
Quick Reference: Steps and Job Entries