Post Installation Tasks: PDI software

After you have installed the Pentaho Data Integrator client (Spoon), you must set the Java home directory. Make sure you have Java 8 installed.

2. Right click My Computer (This PC) -> Properties -> Advanced Settings

3. The System Properties window will appear. Make sure you are in the Advanced Tab

4. From the Advanced tab, click Environment Variables

5. Under System Variables, click New

6. Enter Variable Name as PENTAHO_JAVA_HOME

7. Enter the install directory of you Java as Value

8. Click OK. Sign-out of your workstation for the changes to take effect

9. Importing the Self-Signed Certificate to the client workstation

10. Copy .keystore and tomcat.cer of the server to your local. This is the SSL Certificate of the development server

11. Import the tomcat.cer to your local machine. Locate the keytool (<JAVA Install Directory>\Java\jre6\bin) command and enter the following command.

keytool –import –alias tomcat –file <location of the tomcat.cer> -keystore cacerts –storepass password

Type yes to trust the certificate

12. Edit your spoon.bat file. Location: <Pentaho design tools install directory>\data-integration\spoon.bat

13. Locate set OPT line then add the following parameters

"-Djavax.net.ssl.keyStore=CC:\Pentaho_Versions\710\server\pentaho-server\tomcat\conf\.keystore" "-Djavax.net.ssl.keyStorePassword=changeit" "-Djavax.net.ssl.trustStore=C:\Pentaho_Versions\710\java\lib\security\cacerts" "-Djavax.net.ssl.trustStorePassword=changeit" "-Djavax.net.ssl.keyStoreType=JKS" "-Djavax.net.ssl.trustStoreType=JKS"

14. Edit the following parameters:

a. "-Djavax.net.ssl.keyStore= - SET THE LOCATION OF THE KEYSTORE FILE

b. "-Djavax.net.ssl.keyStorePassword = password

c. "-Djavax.net.ssl.trustStore= - SET THE LOCATION OF THE KEYSTORE FILE

d. "-Djavax.net.ssl.trustStorePassword = password

15. Save the file

16. Locate the hosts file of your local machine C:\Windows\System32\drivers\etc

17. Add the following line

192.168.11.97 DILG

18. Navigate to C:\<PDI Client Install Directory>\license-installer

19. Run the following command

install_license.bat install <Location of PDI License>\PDI.lic

20. Run Spoon.bat (PDI)

21. Create a new connection to the repository

a. Click Connect (located in the upper right hand of the IDE)

b. Click Get Started

c. Enter a Display Name for your connection

d. Enter the URL of the server

e. Click Finish

f. Once your connection is establish. Click Connect Now or Finish