Sunday, December 15, 2013

Pentaho Data Integration - Configure DI Server for Windows

Step 1 :

Go To "Start > Pentaho Enterprise Edition > Server Management"
Start DI and Tomcat servers using icon "Start Data Integration Server"

Step 2 :

Access DI repository using Spoon design tool.
Spoon is a desktop application that can be used primarily as a graphical interface and editor for transformations and jobs.

Go To "Start > Pentaho Enterprise Edition > Design Tools"
Click on "Data Integration" to start spoon.

Step 3 :

Repository Connection dialogue box will pop up.
Click on "+" button to add new repository connection.

Step 4 :

Repository type dialogue box will pop up.
Select "DI Repository" and then click OK.

Step 5 :

Enter Repository connection information.
Enter suitable names for ID and Name.

Default URL : http://localhost:9080/pentaho-di

Step 6 :

Click on Test to verify whether the URL is correct.

Step 7 :

Provide user name and password.
Click OK to connect to the repository.

Default User Name : admin
Default Password : password

Step 8 :

Logging into the repository.

Step 9 :

DI server repository is connected.


  1. hi, I am very thankful to you. thats great and its been working. Do you have any tutorial/post to get SugarCRM data into Pentaho for reports. Please share

  2. Commenting on a blog is an art. Good comments create relations. You’re doing great work. Great blog and couldn’t be writing much better!
    Oracle Fusion HCM Technical Training

  3. The team of quality data scientist and engineer can solve your all data problems in a few minutes or days, but this is not really easy to find the professional data scientist or engineer for resolving your all data issues and problems. So if you want to contact the competitive, talented and professional data scientist for handling of your data problems than the is the right place for you.