Note: The content on this page is not complete and the features described here are still under development.
Configuring 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 Web Server, which provides you with the means to connect to your database. To access your database, you must configure a data source on Tomcat. The data source stores information, such as the database name, the required database driver, and the user ID and password required to connect the database. You may need to contact a system administrator to get the specific information about your database.
Follow the instructions below to configure the data source:
- In the Administration Console go to...
- 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.