Instant Pentaho Data Integration Kitchen

Instant Pentaho Data Integration Kitchen - Opis

Pentaho PDI is a modern, powerful, and easy-to-use ETL system that lets you develop ETL processes with simplicity. Explore and gain the experience and skills that you need to run processes from the command line or schedule them by using an extensive description and a good set of samples.Instant Pentaho Data Integration Kitchen How-to will help you to understand the correct way to deal with PDI command line tools. We start with a recipe about how to configure your memory requirements to run your processes effectively and then move forward with a set of recipes that show you the different ways to start PDI processes.We start with a recap about how transformations and jobs are designed using spoon and then move forward to configure memory requirements to properly run your processes from the command line.We dive into the various flags that control the logging system by specifying the logging output and the log verbosity. We focus and deliver all the knowledge you require to run the ETL processes using command line tools with ease and in a proficient manner. Spis treści:
Instant Pentaho Data Integration Kitchen
Instant Pentaho Data Integration Kitchen
Credits
About the Author
About the Reviewer
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Preface
How the story began
Kettle components
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example (...) więcej code
Errata
Piracy
Questions
1. Instant Pentaho Data Integration Kitchen
Designing a simple PDI transformation (Simple)
Getting ready
How to do it...
Theres more...
How to quickly find the steps to use
Designing a simple PDI job (Simple)
Getting ready
How to do it...
How it works...
There's more...
Why a proper naming for tasks and steps is so important
Using internal variables to write location-independent processes
The important role of icon and color indicators
Configuring command-line tools to run properly (Simple)
Getting ready
How to do it...
There's more...
Making things easier by writing custom scripts
Executing PDI jobs from a filesystem (Simple)
Getting ready
How to do it
Executing PDI jobs packaged in archive files (Intermediate)
Getting ready
How to do it...
How it works...
There's more...
Changes in job and transformation design
Executing PDI jobs from the repository (Simple)
Getting ready
How to do it...
There's more...
Changes in job and transformation design
How to define a filesystem repository
Defining a database repository
Dealing with the execution log (Simple)
Getting ready
How to do it...
There's more...
Understanding the log to identify where our process fails
Separating execution logfiles by date and time
Discovering your PDI repository from the command line (Simple)
Getting ready
How to do it...
Exporting jobs and transformations to the .zip files (Simple)
Getting ready
How to do it...
How it works...
There's more...
Managing PDI processes return code (Simple)
Getting ready
How to do it...
There's more...
A summary of Kitchen/Pan exit codes
Scheduling PDI jobs and transformations (Intermediate)
Getting ready
How to do it...
There's more...
Understanding crontab malfunctions O autorze: Sergio Ramazzina is an experienced software architect/trainer with more than 25 years of experience in the IT field. He has worked on a broad number of projects for banks and major Italian companies and has designed complex enterprise solutions in Java, JavaEE, and Ruby. He started using Pentaho products from the very beginning in late 2003. He gained thorough experience by deploying Pentaho as an open source BI solution, standalone or deeply integrated in other applications as the analytical engine of choice. In 2009, due to his experience in the Java/JavaEE world and appreciation for the open source world and its main ideas, he began participating actively as a contributor to some of the Pentaho projects such as JPivot, Saiku, CDF, and CDA and rose to the Pentaho Active Contributor level. At that time, he started participating as a BI architect and Pentaho expert on a wide number of projects where open source BI and Pentaho were the main players. In late 2010, he founded Serasoft, a young Italian consulting firm that specializes in delivering high value open source Business Intelligence solutions. With the team in Serasoft, he shared his passion and experience in designing and delivering highly innovative enterprise solutions to help users make their work more effective. In July 2013, he published his first book, Instant Pentaho Data Integration Kitchen, Packt Publishing. He is also passionate about skiing, tennis, and photography, and he loves his young daughter, Camilla, very much. You can follow him on Twitter at @sramazzina. You can also look at his profile on LinkedIn at https://it.linkedin.com/in/sramazzina/. mniej