Instant Pentaho data integration kitchen / Sergio Ramazzina.

Format:

Book

Author/Creator:

Ramazzina, Sergio.

Language:

English

Subjects (All):

Data integration (Computer science).

Database management--Computer programs.

Database management.

Physical Description:

1 online resource (68 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, UK : Packt Pub., 2013.

Language Note:

English

Biography/History:

Ramazzina Sergio: 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 http: //it. linkedin. com/in/sramazzina/.

Summary:

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. A practical guide with easy-to-follow recipes helping developers to quickly and effectively collect data from disparate sources such as databases, files, and applications, and turn the data into a unified format that is accessible and relevant to end users.Any IT professional working on PDI and is a valid support for either learning how to use the command line tools efficiently or for going deeper on some aspects of the command line tools to help you work better.

Contents:

Intro

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 code

Errata

Piracy

Questions

1. Instant Pentaho Data Integration Kitchen

Designing a simple PDI transformation (Simple)

Getting ready

How to do it...

There's more...

How to quickly find the steps to use

Designing a simple PDI job (Simple)

How it works...

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)

Making things easier by writing custom scripts

Executing PDI jobs from a filesystem (Simple)

How to do it…

Executing PDI jobs packaged in archive files (Intermediate)

Changes in job and transformation design

Executing PDI jobs from the repository (Simple)

How to define a filesystem repository

Defining a database repository

Dealing with the execution log (Simple)

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)

Exporting jobs and transformations to the .zip files (Simple)

Managing PDI processes return code (Simple)

A summary of Kitchen/Pan exit codes

Scheduling PDI jobs and transformations (Intermediate)

Understanding crontab malfunctions.

Notes:

Bibliographic Level Mode of Issuance: Monograph

ISBN:

9781849696913

1849696918

OCLC:

855897677