Managing Jazz Reporting Service data sources

As an administrator with Jazz™ administrative privileges, or a report manager, you can add and edit Jazz Reporting Service data sources. For example, you can update the password that is required to connect to a data source, or specify a new location for a data source as part of balancing workload amongst servers in a distributed environment.

Before you begin

The following conditions must be met:

About this task

Data sources identify the location of the data stores that are used by queries.

Connecting to data sources

After a data source is added, or immediately after the installation of Jazz Reporting Service, an administrator must establish a connection to it before users can use reports on their dashboard.

Before you begin

A data source must be installed, and you must know its password.

About this task

There are two scenarios for connecting to data sources:
  • Immediately after installing and configuring Jazz Reporting Service

    An administrator with Jazz administrative privileges must connect to the data source that was installed as part of the Rational product or solution that uses Jazz Reporting Service.

  • After adding subsequent data sources

    After an administrator or a report manager adds a data source, they must also establish a connection to it.

Procedure

  1. In a browser window, open the Setup page: https://server:port/rs/setup
  2. Click Connect to data sources.
  3. Optional: To view or edit the data source properties, click Data Sources on the product banner or in the Connect to data sources pane.

Results

The Setup page confirms that Jazz Reporting Service can communicate with the data source. You can now import queries and select report managers. Report managers can then add and edit data sources.

Adding data sources

If a data source for Jazz Reporting Service does not exist, an administrator with Jazz administrative privileges or a report manager can add one.

Before you begin

You must know the data source type, and depending on the type and vendor, the properties that are required to connect to it.

Procedure

  1. In a browser window, open the Setup page: https://server:port/rs/setup
  2. Click Data Sources on the product banner or in the Connect to data sources pane.
  3. Click Create a Data Source.
  4. Enter the data source name, description, type, and required properties; then, click Save.

Results

The data source is displayed in the list of data stores used by queries. You must connect to the data source, as described in the preceding section.

Editing data sources

In general, do not edit data sources because it can have implications for data collection jobs and reports. If you must change a data source property, ensure that you understand other corresponding changes that you must make.

Before you begin

You must be connected to a data source. You must be an administrator with Jazz administrative privileges or a report manager.

Procedure

  1. In a browser window, open the Setup page: https://server:port/rs/setup
  2. Click Data Sources on the product banner or in the Connect to data sources pane.
  3. In the Actions column beside the data source, click Actions, and select the action to complete.
  4. If you edit any of the data source properties, click Save.
  5. Return to the Setup page, and click Connect to data source to ensure the connection is established.

Feedback