Install DI Design Tool and Plugins
Overview
Provides design tool and plugin installation steps.

There is one DI design tool (Spoon) and many plugins, including Instaview and Big Data. This step explains how to install them.
Choose Installation Method
There are two methods by which you can install the design tools and plugins: wizard and manual. Review the table to determine which method is best for you.
If You Are Interested In | Choose Options | |
---|---|---|
Wizard | Manual | |
| The Wizard is the easiest way to install the DI Design Tool and Plugins. The Wizard allows you to install design tools and plugins on the server or client workstations. | The manual method allows you to manually copy design tool and plugin installation files to any directory on the server or client workstations. |
| Basic computer knowledge. | Basic computer knowledge. |
| 15 minutes. | 15 minutes. |
| This is the preferred method. Use for the Pentaho Trial Download, evaluating, and rapid development. | Use for rapid development. Use this method if you want to manually install design tools in any directory. |
Now that you have selected the installation method, follow the instructions in that section to install the design tool and plugins.
Install the Design Tool and Plugins
Install the design tool and plugins using the Wizard or Manual Methods.
Use the Wizard to Install DI Design Tool and Instaview Plugin
The easiest way to install the DI design tool, utilities, and Instaview plugin is to use the BA Installation Wizard using the custom method. As you follow the instructions, select the Data Integration (ETL) option when the Pentaho Applications window appears.
Use the Manual Method to Install DI Design Tool, Utilities, and Plugins
Use the Manual Method to Install DI Design Tool and Utilities
Perform the following steps to manually install the PDI client and utilities:
- Download the pdi-ee-client-5.0.0-dist.zip file.
- Use a zip tool to extract the file you just downloaded.
Do not use Unarchiver 3.3 to unzip files; it may corrupt the plugin file names.
- Open a Command Prompt or Terminal window and navigate to the folder that contains the files you just extracted.
- Enter one of the following commands at the prompt:
For Windows:
install.bat
For Linux:
./install.sh
- Read the license agreement that appears. Select Accept, then click Next.
If you are unpacking the file in a non-graphical environment, open a Terminal or Command Prompt window and type java -jar install.jar -console and follow the instructions presented in the window.
- Specify where you want the file to be unpacked. This location can be temporary because you will be manually placing the files in the appropriate directories later in these instructions.
- Click the Next button. The Installation in Progress window appears.
- When the installation progress is complete, click Quit to exit the Unpack Wizard.
- Create a directory for your tools and utilities. If you are unsure of what directory to create, we suggest that you create a pentaho directory and design-tools subdirectory on your workstation. If you choose this option, the directory path should look like the example shown below:
pentaho/design-tools
- Copy or move the extracted files to the pentaho/design-tools directory. The design tool and utilities appear in the following path:
pentaho/design-tools/data-integration (Spoon, Kitchen, Pan, Carte)
Use the Manual Method to Install Plugins
Download the plugin and unzip it in the appropriate subdirectory in pentaho/design-tools/data-integration/plugins. To determine the correct subdirectory, see the instructions for the plugin you are installing for more instructions.
Use the Marketplace to Install Plugins
- Start Spoon.
- Select Help > Marketplace. The PDI Marketplace window appears.
- The name of the plugin appears in the Detected plugins section of the page. Note which plugins are installed. You can filter the list by typing the name of the plugin in the Detected Plugins textbox.
- Click the name of the plugin to expand it. Information about the plugin, including the documentation, source code, and support information appears.
- Click Install this plugin.
- The Progress Information dialog box appears, indicating the operation is in process. When the plugin has been successfully installed, a message appears indicating that you will need to restart your client, which is Spoon.
- Click OK.
- Restart Spoon.
- To verify that the plugin was installed, open the PDI Marketplace window again. The plugin is listed as installed. The plugin should appear in the logical place in the Spoon interface. For example, if the plugin that you install is the CMIS Input plugin, it will appear in the Design tab in the Output Steps category.
Configuring MonetDB for Instaview
- Download the "Jul2012-SP2" version of MonetDB and install it on your computing environment. See MonetDB's documentation if you need help completing this step.
- Configure Instaview/Kettle to use Monetdb.
For Windows
- In <user home>/.kettle/spoonrc, add these properties.
MonetDBDatabaseName=pentaho-instaview MonetDBDefaultBufferSize=100000 MonetDBDefaultEncoding=UTF-8 MonetDBDefaultLogFile= MonetDBDefaultSchemaName= MonetDBDefaultTableName=tmp_agile_data #port that monet db is running on, 50000 is the default for Monetdb MonetDBPort=50000 MonetDBProcessName=mserver5.exe
- In <user home>/.kettle/kettle.properties, add these properties:
AgileBIDatabase=AgileBI #path to the Instaview templates folder InstaviewTemplates=C:\\PROGRA~1\\pentaho\\design-tools\\data-integration\\plugins\\spoon\\agile-bi\\platform\\pentaho-solutions\\system\\instaview\\templates
- In <user home>/.kettle/.spoonrc, add these properties, verifying that the paths are correct for your system.
#Full path to the monetdb process/executable MonetDBCmd=/usr/local/monetdb/bin/monetdb #Name of the database used for instaview MonetDBDatabaseName=pentaho-instaview MonetDBDefaultBufferSize=100000 MonetDBDefaultEncoding=UTF-8 MonetDBDefaultLogFile= MonetDBDefaultSchemaName= MonetDBDefaultTableName=tmp_agile_data #port that monet db is running on, 50000 is the default for MonetDB MonetDBPort=50000
- In <user home>/.kettle/kettle.properties, add these properties:
AgileBIDatabase=AgileBI #path to the Instaview templates folder InstaviewTemplates=/home/joe/pentaho/design-tools/data-integration/plugins/spoon/agile-bi/platform/pentaho-solutions/system/instaview/templates
- Create a .monetdb file in your user home folder, /home/<userName>/.monetdb.
- Add these two entries:
user=monetdb password=monetdb
- In <user home>/.kettle/spoonrc, add these properties.