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

Product type Paperback

Published in Oct 2013

Publisher Packt

ISBN-13 9781782165040

Length 502 pages

Edition 2nd Edition

Languages

Java

Tools

Pentaho

Concepts

Data Visualization

Author (1):

María Carina Roldán

View More author details

Table of Contents (21) Chapters

Preface

1. Getting Started with Pentaho Data Integration

2. Getting Started with Transformations FREE CHAPTER

3. Manipulating Real-world Data

4. Filtering, Searching, and Performing Other Useful Operations with Data

5. Controlling the Flow of Data

6. Transforming Your Data by Coding

7. Transforming the Rowset

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

A. Working with Repositories

B. Pan and Kitchen – Launching Transformations and Jobs from the Command Line

C. Quick Reference – Steps and Job Entries

D. Spoon Shortcuts

E. Introducing PDI 5 Features

F. Best Practices

Summary

G. Pop Quiz Answers

Index

Migrating from file-based system to repository-based system and vice versa

No matter which storage system you are using, file-based or database repository, you may want to move your work to the other system just to try it or for taking advantage of the benefits of the other system, mentioned at the beginning of this appendix. The following table summarizes the procedure for doing that (migrating from a file-based configuration to a database repository):

PDI element	Procedure for migrating from file to repository
Transformations or jobs	From File \| Import from an XML file, browse to locate the `.ktr`/`.kjb` file to import, and open it. Once the file has been imported, you can save it into the repository as usual.
Database connections, Partition schemas, Slaves, and Clusters	When importing from an `XML` file, job, or transformation that uses the database connection, the connection is imported as well. The same applies to partitions, slave servers, and clusters.

PDI element

Procedure for migrating from file to repository

Transformations or jobs

From File | Import from an XML file, browse to locate the .ktr/.kjb file to import, and open it. Once the file has been imported, you can save it into the repository as usual.

Database connections, Partition schemas, Slaves, and Clusters

When importing from an XML file, job, or transformation that uses the database connection, the connection is imported as well.

The same applies to partitions, slave servers, and clusters.

There is also a command-line...