How to add a JNDI Database Connection in Admin Console?

[skmindgate]

Hello everybody,

has anyone an idea, how to add a JNDI Database Connection in Pentaho Administration Console (BI-Server Version 3.6.0)?

I can not find any settings for JNDI. It seems so, that in early version of the admin console, the jndi settings are available, but not in the current!??

I'm using Apache Tomcat 6.0.29 and Postgresql 8.4.

Also i'm not sure at which place i should store the JNDI settings:

/opt/pentaho/pentaho-solutions/system/simple-jndi/jdbc.properties

or

/opt/tomcat/webapps/pentaho/META-INF/context.xml

stefan

[TomS]

Hi Stefan,

for adding a JNDI-Connection in the BI-Server you need to start the Pentaho
Administration-Console ($BISERVER/administration-console/start.sh|start.bat), log in
on http://localhost:8099 and go to "Datasources"

There you will be able to create a JNDI Datasource.
(don't forget to put the JDBC-Driver JAR-File into
administration-console/jdbc
and
tomcat/common/lib

before starting the BI-Server and/or the PAC.

HTH,

Tom

[skmindgate]

Hi Tom,

thank you for your answer, but I can not find any possibility to add an JNDI-Connection in the Admin-Console (BI-Server Version 3.6.0)!

I've added a screenshot to show you, that there is nothing about JNDI.

stefan

[TomS]

These datasources which you define in this screen ARE JNDI datasources ;)

[richad3]

Actually, the name that you give to the DB Connection is the JNDI name that you will have to use when you publish a cube for example....
Rich

[skmindgate]

Thanks for your help. I didn't know that the connections are automatically JNDI-Database-connections.

stefan