{scrollbar}
{quote}
*{_}Note{_}*: The content on this page is not complete and the features described here are still under development.
{quote}

h1. 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.
 
!data_sources0421.png|align=center!
 

\\ Follow the instructions below to configure the data source:
# In the Administration Console go to *Administration* > *Data Source*.
# Click + (add) if you cannot find your data source in the list.
# In the left panel, type an easy-to-remember *JNDI Name*. JNDI is an interface that allows an application server to locate your database.
# Enter the maximum number of active instances, (*Max Active Conn*), that can be allocated from this pool at the same time.
# Type or select the *Driver Class* 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.
# Enter the maximum number of connections that can sit idle (*\# Idle Conn*) in this pool at the same time.
# Type the *User ID* and *Password* required to access your database.
# Type or select the *URL* from the list. This is the URL of your database. For example, _

Important: The content on this page is not complete. The community is actively encouraged to add to, edit, and improve this document. Installation and configuration instructions are documented for Release Candidate 2.0.0.

Defining a data source

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. Defining a data source requires 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.
 
Image Added
 
Follow the instructions below to  configure a "General" data source:

1. In the Administration Console go to Administration > Data Sources.
2. Click General to display basic configuration options.
3. Click + (add) if you cannot find your data source in the list.
4. In the left panel, type an easy-to-remember Connection Name.
5. Type or select the Driver Class 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.
6. Type the User Name and Password required to access your database.
7. Type or select the URL from the list. This is the URL of your database. For example, jdbc:hsqldb:hsql://localhost/sampledata

...

1. .

...

1. JDBC

...

1. establishes

...

1. a

...

1. connection

...

1. to

...

1. a

...

1. SQL-based

...

1. database

...

1. and

...

1. sends

...

1. and

...

1. processes

...

1. SQL

...

1. statements

...

1. .
2. Click Test. A success message appears if the connection is established.
3. Click OK to save your entries.
    

Advanced Configuration

Follow the instructions below complete an advanced configuration:

1. In the Administration Console go to Administration > Data Sources.
2. Click Advanced to display advanced configuration options.
3. Enter the maximum number of active instances, (Max Active Conn), that can be allocated from this pool at the same time.
4. Enter the maximum number of connections that can sit idle (# Idle Conn) in this pool at the same time.
5. Enter a Validation Query. This SQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query must be an SQL SELECT statement that returns at least one row.
6. Enter the maximum number of milliseconds that the pool will "wait" (when there are no available connections) for a connection to be returned before throwing an exception.
7. Click Test. A success message appears if the connection is established.
8. Click OK to save your entries.
    

Editing and Deleting Data Source Configurations

You can edit or delete a data source configuration when necessary.

Editing a Data Source Configuration

To edit a data source configuration:

1. Select the data source name from the list under Data Sources.
2. Make the appropriate changes in the right pane.
3. Click Test to test the connection.
4. Click Update to save your changes.
    

To delete a data source configuration:

1. Select the data source name from the list under Data Sources.
2. Click the minus sign (-) to delete the configuration. A confirmation message appears.
3. Click Update to save your changes.
    

See also:

http://wiki.pentaho.com/display/ServerDoc1x/Managing+Data+Sources+in+the+Pentaho+BI+Platform
http://wiki.pentaho.org/display/Reporting/Creating+a+Data+Source+for+Tomcat

...

http://wiki.pentaho.org/display/Reporting/4.+Data+Sources

...