Time for action – populating the Jigsaw database

To load data massively into your Jigsaw database, you must have the Jigsaw database created and the MySQL server running. You already know how to do this. If not, refer to Chapter 1 Getting started with Pentaho Data Integration, for the installation of MySQL and to Chapter 8, Working with Databases, for the creation of the Jigsaw database.

Note

This tutorial will overwrite all your data in the js database. If you don't want to overwrite the data in your js database you could simply create a new database with a different name and run the js.sql script to create the tables in your new database.

After checking that everything is in order, follow these instructions:

1. Open the js_data.sql script file available in the code bundle.

   Note

   If you created a new database, edit the script and replace the js name by the name of your new database.

2. Run the script by opening a terminal window and typing the following:

   mysql js < js_data.sql

   Note

   If you...