Set up JNDI on Pentaho Data Integration Server

Last modified by Harini Yalamanchili on 2014/07/11 14:36

In the pentaho infocenter http://infocenter.pentaho.com/help/index.jsp it says, you should be able to add JNDI in the file .\data-integration-server\pentaho-solutions\system\simple-jndi. However, if this does not work for some reason, this is how you can use the standard tomcat method:

The files you will need to edit

  • data-integration-server/tomcat/webapps/pentaho-di/META-INF/context.xml 
  • data-integration-server/tomcat/webapps/pentaho-di/WEB-INF/web.xml

Follow the examples for hibernate

In context.xml you will need to add your connection details
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
                factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
                maxWait="10000" username="hibuser" password="password"
                driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/hibernate"
                validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES" />

In web.xml reference the JNDI name from the first

       <resource-ref>
       <description>Hibernate</description>
       <res-ref-name>jdbc/hibernate</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
       </resource-ref>

You will need to redeploy your webapp for this change to take place:

  • Stop Pentaho DI Server
  • Remove the data-integration-server/tomcat/conf/Catalina/localhost/pentaho-di.xml file
  • Remove the data-integration-server/tomcat/work/Catalina/pentaho-di folder(for 5.1.X the path is data-integration-server/tomcat/work/Catalina/localhost/pentaho-di)
  • Start Pentaho DI Server
Tags:
Created by julia on 2012/05/25 19:00

Recently Modified

Tag Cloud

  1. 61 upgrade
  2. address
  3. admin
  4. agreement
  5. ahs
  6. AHS Projects
  7. alternative
  8. analyzer
  9. annotation date
  10. ant
  11. authenticated
  12. B3Way
  13. BA Client
  14. beer
  15. BI Server Set Up
  16. biserver
  17. BizCubed Way
  18. bizcubedlogo
  19. boost
  20. branding
  21. brew
  22. brightcove
  23. bug fix
  24. building manager
  25. bzr
  26. calculated
  27. CalculatedMemberProperty
  28. chrome
  29. cifs
  30. colo
  31. conference
  32. configuration
  33. Core Business
  34. CRM
  35. cryptography
  36. css
  37. dashboard
  38. data-integration-server
  39. Date
  40. date filtering
  41. date range
  42. Day
  43. dev
  44. development
  45. devstorage
  46. DI Server Set Up
  47. dimension
  48. draft
  49. eclipse
  50. Emails
  51. env
  52. epygi
  53. Escalation
  54. ETL
  55. extension
  56. fde
  57. fiscal
  58. framework
  59. git
  60. grand
  61. home
  62. homebrew
  63. hyperlink
  64. ide
  65. iinet
  66. Infobright
  67. internode
  68. IT Support
  69. ivy
  70. jce
  71. Kettle
  72. keytool
  73. LDAP
  74. leave
  75. logging
  76. logo
  77. LVM
  78. map
  79. marketingnotes
  80. maven
  81. MDX
  82. measures
  83. meeting rooms
  84. member
  85. members
  86. nas
  87. new users
  88. nginx
  89. OLD
  90. pentaho backup
  91. Pentaho leads
  92. Phone Conversations
  93. pipe
  94. POC
  95. process
  96. project
  97. Project Report
  98. proof of concept
  99. properties
  100. prototype
  101. proxy
  102. PUC
  103. ReferenceError
  104. reimbursement
  105. relative
  106. REMOVE
  107. Report
  108. resize
  109. restart biserver
  110. Retail Zoo
  111. review
  112. roles
  113. runner
  114. Salesforce
  115. samba
  116. samples
  117. share
  118. shell scripts
  119. sol1
  120. specsavers
  121. ssl
  122. sslmode
  123. standard
  124. startup
  125. subtotal
  126. swiftfox
  127. symbolic links
  128. synology
  129. teleconference
  130. teleconferencing
  131. telephone
  132. template
  133. templates
  134. Timesheets
  135. tomcat
  136. tools
  137. total
  138. Transformations
  139. tweaks
  140. Ubuntu
  141. update
  142. upgrade
  143. vcenter
  144. virtual machine
  145. vnc
  146. vsphere
  147. weeklywebinar
  148. working from home
  149. wotif
  150. y7
  151. yahoo
  152. yahoo7

XWiki Enterprise 3.5.1 - Documentation