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

 | rebecca

Tag Cloud

  1. account management
  2. acquisition framework
  3. admin
  4. agreement
  5. AHS Projects
  6. alternative
  7. Analyst
  8. analyzer
  9. annotation date
  10. architecture diagram
  11. assessments
  12. authenticated
  13. BA Client
  14. beer
  15. BI Server Set Up
  16. biserver
  17. bizcubedlogo
  18. boost
  19. branding
  20. brew
  21. brightcove
  22. bug fix
  23. build
  24. building manager
  25. bzr
  26. calculated
  27. CalculatedMemberProperty
  28. chrome
  29. cifs
  30. colo
  31. compile
  32. conference
  33. configuration
  34. control framework
  35. Core Business
  36. courses
  37. CRM
  38. cryptography
  39. css
  40. custom training
  41. dashboard
  42. data acquisition
  43. data-integration-server
  44. Date
  45. date filtering
  46. date range
  47. Day
  48. delete
  49. dev
  50. development
  51. devstorage
  52. DI Server Set Up
  53. dimension
  54. distinct capability
  55. draft
  56. eclipse
  57. Emails
  58. employee details
  59. enabled analytics
  60. env
  61. epygi
  62. Escalation
  63. extension
  64. Facebook
  65. Facebook Acquisition
  66. facebook page
  67. facebook post
  68. fde
  69. file sharing
  70. fiscal
  71. flurry
  72. flurry Acquisition
  73. framework
  74. git
  75. grand
  76. Grid
  77. hadoop
  78. home
  79. homebrew
  80. hyperlink
  81. ide
  82. iinet
  83. Infobright
  84. internal
  85. internode
  86. IOOF refresh from production
  87. IT Support
  88. ivy
  89. jce
  90. Kettle
  91. keytool
  92. knowledge
  93. LDAP
  94. leave
  95. logging
  96. logo
  97. LVM
  98. management7
  99. map
  100. marketingnotes
  101. md5
  102. MDX
  103. measures
  104. meeting
  105. meeting rooms
  106. member
  107. members
  108. migration
  109. nas
  110. new users
  111. nginx
  112. OLD
  113. onedrive
  114. onlinetraining
  115. payroll
  116. pentaho backup
  117. Pentaho leads
  118. Phone Conversations
  119. pipe
  120. PO Box
  121. POC
  122. post office
  123. process
  124. project
  125. Project Report
  126. project template
  127. proof of concept
  128. properties
  129. prototype
  130. proxy
  131. PUC
  132. ReferenceError
  133. register
  134. reimbursement
  135. relative
  136. Report
  137. resize
  138. restart biserver
  139. restore
  140. Retail Zoo
  141. review
  142. roles
  143. runner
  144. samba
  145. samples
  146. sanity checklist
  147. scentre
  148. share
  149. shell scripts
  150. skills
  151. skills register
  152. sol1
  153. solutions delivery
  154. specsavers
  155. sslmode
  156. standard
  157. startup
  158. Streamhub
  159. streamhub api
  160. subtotal
  161. support
  162. swiftfox
  163. symbolic links
  164. synology
  165. team meeting
  166. teleconference
  167. teleconferencing
  168. telephone
  169. Timesheets
  170. tomcat
  171. tools
  172. total
  173. Transformations
  174. tweaks
  175. Ubuntu
  176. update
  177. upgrades
  178. vault
  179. vcenter
  180. vision
  181. vm
  182. vnc
  183. vsphere
  184. weekly
  185. wiki
  186. working from home
  187. wotif
  188. yahoo
  189. zero

XWiki Enterprise 3.5.1 - Documentation