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 Gusman on 2012/05/25 19:00

Tag Cloud

  1. 61 upgrade
  2. admin
  3. alternative
  4. analyzer
  5. annotation date
  6. asset
  7. authenticated
  8. BA Client
  9. backup
  10. bazaar
  11. beer
  12. BI Server Set Up
  13. biserver
  14. bits
  15. BizCubed
  16. bizcubedlogo
  17. boost
  18. branding
  19. brightcove
  20. building manager
  21. calculated
  22. CalculatedMemberProperty
  23. Careflight
  24. chrome
  25. cifs
  26. colo
  27. computer
  28. configuration
  29. Core Business
  30. CRM
  31. css
  32. dashboard
  33. data-integration-server
  34. Date
  35. date filtering
  36. date range
  37. Day
  38. devstorage
  39. DI
  40. DI Server Set Up
  41. dimension
  42. enabled analytics
  43. entering
  44. entry
  45. epygi
  46. ETL
  47. fde
  48. fiscal
  49. framework
  50. grand
  51. home
  52. hyperlink
  53. iinet
  54. Infobright
  55. infrastructure
  56. integration
  57. internode
  58. IT Support
  59. ITS
  60. java
  61. Kettle
  62. keytool
  63. LDAP
  64. leave
  65. logging
  66. logo
  67. LVM
  68. map
  69. marketingnotes
  70. MDX
  71. measures
  72. meeting
  73. meeting rooms
  74. member
  75. members
  76. monday
  77. nas
  78. new users
  79. nginx
  80. notebook
  81. onlinetraining
  82. Pentaho
  83. Pentaho leads
  84. phone
  85. pipe
  86. pits
  87. PO Box
  88. POC
  89. post office
  90. project
  91. proof of concept
  92. properties
  93. prototype
  94. proxy
  95. PUC
  96. ReferenceError
  97. registry
  98. reimbursement
  99. relative
  100. resize
  101. restart biserver
  102. Retail Zoo
  103. review
  104. roles
  105. runner
  106. Sales
  107. Salesforce
  108. samba
  109. samples
  110. server
  111. share
  112. shell scripts
  113. sol1
  114. specsavers
  115. ssl
  116. sslmode
  117. standard
  118. standards
  119. startup
  120. subtotal
  121. support
  122. swiftfox
  123. symbolic links
  124. synology
  125. team
  126. teleconference
  127. telephone
  128. template
  129. tomcat
  130. total
  131. Transformations
  132. tweaks
  133. Ubuntu
  134. upgrade
  135. vcenter
  136. version control
  137. vitual machine
  138. vnc
  139. vsphere
  140. working from home
  141. wotif
  142. y7
  143. yahoo
  144. yahoo7
  145. zero

XWiki Enterprise 3.5.1 - Documentation