Unknown macro: {scrollbar}

Note: The content on this page is not complete and the features described here are still under development.

Defining a data source on Tomcat

The Pre-configured Installation (PCI) includes sample data and reports; however, if you are evaluating Pentaho you will want to use and display your own data in the BI Platform. The PCI includes an Apache Tomcat 5.5 Application Server, which provides you with the means to connect to your database using JNDI. For the PCI to access your database, you must configure a data source on Tomcat. Defining a data source requires a JDBC class name for the database driver, data source URL (server name, port number, database name) and the user ID and password needed to connect the database. Contact your database administrator to get the specific details about your database.

Follow the instructions below to configure the data source:

In the Administration Console go to Data Source.
Click + (add)
In the Required dialog box, type an easy-to-remember JNDI Name. JNDI is an interface that allows Tomcat to locate your database.
Type or select the Driver Name from the list. The database driver name you select depends on the type of database you are accessing. For example, org.hsqldb.jdbcDriver is a sample driver name for a HypersonicSQL database.
Type or select the Data Source URL from the list. This is the URL of your database. For example, jdbc:hsqldb:hsql://localhost/sampledata. JDBC establishes a connection to a SQL-based database and sends and processes SQL statements.
Type the User ID and Password required to access your database.
Click Test. A success message appears if the connection is established.
Click Update to save your entries.

.04 Configuring Data Sources

Defining a data source on Tomcat