Monday, January 20, 2014

Pentaho Data Integration 5.0.2 - Configure DI server ( Linux )

Basic configuration steps for Pentaho Data Integration server given below. PDI installation using installation wizard on Linux OS is used for demo purposes. The server was installed on an included Apache Tomcat server.

Step 1 : Start DI Server

Script "" can be used to manage the DI server. Here are the available script arguments.

• start
• stop
• restart
• status
• help

Starting the DI server 

[root@localhost pentaho]# /opt/pentaho/ start data-integration-server
Using CATALINA_BASE:   /opt/pentaho/server/data-integration-server/tomcat
Using CATALINA_HOME:   /opt/pentaho/server/data-integration-server/tomcat
Using CATALINA_TMPDIR: /opt/pentaho/server/data-integration-server/tomcat/temp
Using JRE_HOME:        /opt/pentaho/java
Using CLASSPATH:       /opt/pentaho/server/data-integration-server/tomcat/bin/bootstrap.jar
/opt/pentaho/server/data-integration-server/scripts/ : data-integration-server started
[root@localhost pentaho]# 

Step 2 : Start Spoon

Use script "" to start spoon on Linux OS.

[root@localhost data-integration]# /opt/pentaho/design-tools/data-integration/
DEBUG: Found JAVA two folders up
DEBUG: Found Pentaho License two folders up
DEBUG: _PENTAHO_JAVA_HOME=/opt/pentaho/design-tools/data-integration/../../java
DEBUG: _PENTAHO_JAVA=/opt/pentaho/design-tools/data-integration/../../java/bin/java
DEBUG: PENTAHO_INSTALLED_LICENSE_PATH=/opt/pentaho/design-tools/data-integration/../../.installedLicenses.xml

Step 3 :

Connect to Pentaho Data Integration repository via option "Tools >> Repository >> Connect".

Step 4 :

Repository connection wizard will pop up.
Use "+" button to create a new repository.

Step 5 :

Choose "DI Repository" as the repository type.

Step 6 :

Repository Configuration screen will pop up. Replace default URL if needed. 
Enter meaningful ID and Name.

Step 7 :

Click on "Test" button to verify repository URL.

Step 8 :

Provide user credentials for the repository.

Default User Name : admin
Default Password   : password

Step 9 :

Repository Log in - In progress.

Step 10 :

Use option "Tools >> Repository >> Explore" to view and manage Repository.


  1. very interesting article i feel very enthusiastic while reading and the information provided in this article is so useful for me.content in this article guides in clarifyingsome of my doubts of oracle fusion financials

    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad