Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Add a JNDI data source

Parent aricle

You should already have established a JNDI data connection in your application server before continuing.

Follow this procedure to establish a connection to a JNDI data source.

Procedure

  1. Quit Report Designer if it is currently running.

  2. Edit the .pentaho/simple-jndi/default.properties file.

    The .pentaho directory is in the home or user directory of the user account that runs Report Designer. If you have multiple copies of Report Designer installed to multiple user accounts, each default.properties file will have to be edited.
  3. Add your JNDI connection information, beginning with the JNDI name on each line, as shown in the example below:

    SampleData/type=javax.sql.DataSource
    SampleData/driver=org.hsqldb.jdbcDriver
    SampleData/url=jdbc:hsqldb:hsql://localhost/sampledata
    SampleData/user=pentaho_user
    SampleData/password=password
  4. Save and close the file, then start Report Designer.

  5. To add this data source to a report, add a JDBC data source, choose JNDI as the connection type, and type in the JNDI name in the appropriate field.

Results

Report Designer can now access your JNDI data sources.