Hitachi Vantara Pentaho Community Wiki

.04 Configuring Data Sources

Skip to end of metadata
Go to start of metadata

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.
 

 
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. JDBC establishes a connection to a SQL-based database and sends and processes SQL statements.
  8. Click Test. A success message appears if the connection is established.
  9. 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

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.