Define JNDI for Pentaho BA server 5.0

Posted on by By Nikhilesh, in Business Intelligence, Open Source Business Intelligence, Pentaho | 0

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- 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. 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.

jdbc/ myDatasource

    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. Save & Close context.xml
    2. Open simple jndi
    3. Open & Modify this file biserver-ce/pentaho-solutions/system/simple-jndi/
    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
  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

0 0 votes
Article Rating
Notify of
Inline Feedbacks
View all comments