Define JNDI for Pentaho BA server 5.0

Note: For illustration, I’m showing Oracle 11g configuration. Replace the Resource name, username, password, driverClassName, and URL parameters, or any relevant connection settings.

Add Driver

Place appropriate driver for Oracle 11g which is ojdbc6-11.2.0.2.jar to this directory for the BA Server: /pentaho/server/biserver-ee/tomcat/lib/.

Note: There should be only one driver for one database in this directory. Ensure that there are no other versions of the same vendor’s driver in this directory. If there are, back up the old driver files and remove them to avoid version conflicts.

Specify JNDI connections

1. 1. Stop server & BA server.
   2. Edit the /tomcat/webapps/pentaho/WEB-INF/web.xml file.
   3. At the end of the <web-app> element, in the same part of the file where you see <!– insert additional resource-refs –>, add this XML snippet.

myDatasource
jdbc/ myDatasource
javax.sql.DataSource
Container

1. 1. Save & Close web.xml
   2. Open & modify this file /tomcat/webapps/pentaho/META-INF/context.xml.
   3. Add this XML snippet anywhere in context.xml

1. 1. Save & Close context.xml
   2. Open simple jndi
   3. Open & Modify this file biserver-ce/pentaho-solutions/system/simple-jndi/jdbc.properties.
   4. Add these lines

myDatasource /type=javax.sql.DataSource
myDatasource /driver= oracle.jdbc.OracleDriver
myDatasource /url= jdbc:oracle:thin:@//localhost:1521/sysdba
myDatasource /user=dbuser
myDatasource /password=password

1. Save & Close jdbc.properties.
2. Delete the pentaho.xml filed located in the /tomcat/conf/catalina/directory.
3. Start tomcat & BA server.

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download