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:
- Open the
js_data.sql
script file available ...
Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.