E-book details

Pentaho Data Integration Beginner's Guide. Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook - Second Edition

Pentaho Data Integration Beginner's Guide. Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook - Second Edition

María Carina Roldán

Ebook
Capturing, manipulating, cleansing, transferring, and loading data effectively are the prime requirements in every IT organization. Achieving these tasks require people devoted to developing extensive software programs, or investing in ETL or data integration tools that can simplify this work.

Pentaho Data Integration is a full-featured open source ETL solution that allows you to meet these requirements. Pentaho Data Integration has an intuitive, graphical, drag-and-drop design environment and its ETL capabilities are powerful. However, getting started with Pentaho Data Integration can be difficult or confusing.

Pentaho Data Integration Beginner's Guide - Second Edition provides the guidance needed to overcome that difficulty, covering all the possible key features of Pentaho Data Integration.

Pentaho Data Integration Beginner's Guide - Second Edition starts with the installation of Pentaho Data Integration software and then moves on to cover all the key Pentaho Data Integration concepts. Each chapter introduces new features, allowing you to gradually get involved with the tool. First, you will learn to do all kinds of data manipulation and work with plain files. Then, the book gives you a primer on databases and teaches you how to work with databases inside Pentaho Data Integration. Moreover, you will be introduced to data warehouse concepts and you will learn how to load data in a data warehouse. After that, you will learn to implement simple and complex processes. Finally, you will have the opportunity of applying and reinforcing all the learned concepts through the implementation of a simple datamart.

With Pentaho Data Integration Beginner's Guide - Second Edition, you will learn everything you need to know in order to meet your data manipulation requirements.
  • 1. Getting started with Pentaho Data Integration
  • 2. Getting Started with Transformations
  • 3. Manipulating real-world data
  • 4. Filtering, searching, and other useful operations with data
  • 5. Controlling the Flow of Data
  • 6. Transforming Your Data by Coding with JavaScript Code and the JavaScript Step
  • 7. Transforming the Row Set
  • 8. Working with Databases
  • 9. Performing Advanced Operations with Databases
  • 10. Creating Basic Task Flows
  • 11. Creating Advanced Transformations and Jobs
  • 12. Developing and Implementing a Simple Datamart
  • 13. Appendix: Working with Repositories
  • 14. Appendix: Pan and Kitchen: Launching Transformations and Jobs from the Command Line
  • 15. Appendix: Quick reference: Steps and Job Entries
  • 16. Appendix: Spoon Shortcuts
  • 17. Appendix: Introducing PDI 5 Features
  • 18. Appendix: Best Practices
  • Title: Pentaho Data Integration Beginner's Guide. Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook - Second Edition
  • Author: María Carina Roldán
  • Original title: Pentaho Data Integration Beginner's Guide. Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook - Second Edition
  • ISBN: 9781782165057, 9781782165057
  • Date of issue: 2013-10-24
  • Format: Ebook
  • Item ID: e_3crp
  • Publisher: Packt Publishing