Configuring repositories and connecting to the database

You need to configure the repositories and define the QMF connection to the database.

About this task

Repositories provide a logical grouping of QMF objects (queries, procedures, visual reports, and visual dashboards) and contain the database connection information and resource limits. Generally speaking, only administrators work with repositories.

The tasks required to configure repositories and connect to a database vary, depending on whether you are configuring QMF for yourself or for multiple users.

If you are configuring QMF for multiple users, you perform the following tasks:
  1. Define the JDBC driver library
  2. Configure the repository storage
  3. Create a shared repository
  4. Define the connection to the database
  5. Create the repository connection
  6. Export the configuration to the users
The tasks for configuring repositories and connecting to a database are described in the following table:
Table 1. Configuring repositories and connecting to a database task descriptions
Task Purpose Information

Defining JDBC Driver Library

Define the location of the driver files for the database that you intend to access with QMF.

You can connect to database repositories and data sources by defining the JDBC driver library or by using DRDA.

JDBC driver files are not included with QMF, but QMF does include the configuration data for the most commonly used JDBC drivers.

You need to define the JDBC driver files so that QMF for Workstation and QMF for WebSphere® can load and use the driver.

See Defining the JDBC driver library for detailed steps.

See Using DRDA to connect to database repositories and data sources for detailed steps.

Configuring repository storage

Configure the storage that is used to hold database connection and resource limit information, as well as the database objects to be used by developers.

Configuring shared repository storage involves the following tasks:
  • Specifying connection parameters and user login information
  • Creating and updating tables
  • Protecting repository storage tables and granting user permissions
  • Setting maximum number of simultaneous database connections

Creating a repository

Create repository into which users can save queries, reports, and other data objects.

See Creating repositories for detailed steps.

Defining a connection to the database

Add a relational data source or multidimensional data source to define the QMF connection to the database.

The connection information is stored in the Repository.

See Defining a connection to the database for detailed steps.

Creating the repository connection

Provide QMF for Workstation and QMF for WebSphere with information needed to connect the repository

See Creating the repository connection for QMF for detailed steps.

Providing access to the configured product

Allow multiple users to install and access QMF for Workstation or access QMF for WebSphere configuration from their web browser.

See Exporting the configuration data to users for detailed steps.