Using arguments with Pentaho Data Integration (PDI) transformations are extremely handy when trying to pass through dynamic information. In this tutorial I will show how you can implement variables (denoted by ?) within SQL statements using Table input steps. Along with using variables I also cover how to copy and get rows from the result (memory), how to use system information and debugging steps. This tutorial was done with version PDI 3.2.0.
Using Variables (?) with Table Input Steps.
Posted under Data Integration, Open Source, Pentaho, Tutorials
Review: Pentaho 3.2 Data Integration – Beginner’s Guide.
Posted under Data Integration, Pentaho, Reviews
Recently I was given the chance to review Maria Carina Roldan’s new book “Pentaho Data Integration 3.2 – Beginners Guide”. Maria is an active member of the community and be found on the forums under the (surprise, surprise) Pentaho Data Integration (PDI) section.
As I had been given an ebook to review it was hard to sit down and read through it easily – it just isn’t the same as the real thing. Generally the book is meant for beginners (as the title suggests) as it covers the basics and some intermediate topics of Pentaho’s Data Integration tool. The best thing about this book is that each chapter uses ‘real-life’ data scenarios i.e. football game results and backs it up with quick pop quiz’s to test your PDI knowledge.
I recommend the book for both beginner and intermediate users of PDI and is a great to keep handy on your desk for quick reference. The book covers many different areas but some of the main topics include: transformations and jobs, JavaScript, databases, error handling and using repositories.
So what are you waiting for? Head over to Packt Publishing and grab yourself a copy!