Configuring Report Builder to use LQE connection with new data warehouse

Configure Report Builder to use the relational database connection for the following topologies.

About this task

If you have created separate data warehouse DB for Lifecycle Query Engine with relational store indexing, use the following topologies:

Topology 1

About this task

The Lifecycle Query Engine data sources are pointed to the Lifecycle Query Engine server, which is the Lifecycle Query Engine 1 server in the diagram at the beginning of this document. For clarity, you must rename them before creating new data sources and setting them to use Lifecycle Query Engine relational store.

Then, create new data sources in the Report Builder pointing to the Lifecycle Query Engine server, which is the Lifecycle Query Engine 2 server in the diagram at the beginning of this document.

All the Lifecycle Query Engine data sources in the Report Builder are configured to use the data warehouse. Writing reports against the Lifecycle Query Engine 1 data sources in Report Builder allows you to create SQL reports to work with the indexed data in the data warehouse, which is populated by the Lifecycle Query Engine rs server, and compare them with SPARQL reports.

LQE rs architecture

Procedure

In Report Builder, click the Administration icon and then click Data Sources.
You can see the following data sources:
1. LQE
2. LQE scoped by configuration
3. Data warehouse
  This data warehouse data source connects to the data warehouse DB that is used by DCC.
On the Data sources page, click Connect to data sources.
The following data sources are created:
1. LQE 1
2. LQE 1 scoped by configuration
3. Relational store
  The relational store connects to the new data warehouse DB used for Lifecycle Query Engine with rs.
If additional data sources are not created, then create the Lifecycle Query Engine data source:
1. To create a relational store data source, complete the following steps:
  1. Click Create a data source.
  2. Name the new data source as relational store.
  3. Make sure that the data source type is set to datawarehouse.
  4. Enter the database vendor, URL, and password.
  5. Click Save.
2. To create a non-config scoped Lifecycle Query Engine data source:
  - Click Create a data source.
  - Name the new data source as Lifecycle Query Engine rs.
  - Make sure that the data source type is set to Lifecycle Query Engine SPARQL Endpoint.
  - Enter the SPARQL data source URL for the Lifecycle Query Engine data source on the Report Builder server: https://<server name>:<port>/lqe/sparql
  - Set the Authorization Type to Jazz Security Architecture SSO.
  - Set the Lifecycle Query Engine relational store to Relational store.
  - Click Save.
3. To create a config scoped Lifecycle Query Engine data source:
  1. Click Create a data source.
  2. Name the new data source as Lifecycle Query Engine rs scoped by a configuration.
  3. Make sure that the data source type is set to Lifecycle Query Engine SPARQL Endpoint.
  4. Set the SPARQL data source URL for the Lifecycle Query Engine scoped by a configuration data source on the Report Builder server as https://<server name>:<port>/lqe/sparql-variable-config.
  5. In the Authorization Type field, select Jazz Security Architecture SSO.
  6. Select Require a configuration to run a report.
  7. Set the Lifecycle Query Engine relational store to Data Warehouse (indexed by: Lifecycle Query Engine rs).
    Note: Ensure that you select the Data Warehouse via Lifecycle Query Engine rs, rather than the Data Warehouse via Lifecycle Query Engine.
  8. Click Save.
Rename the LQE 1 as LQE rs and LQE 1 scoped by configuration to LQE rs scoped by configuration.
Edit the existing Lifecycle Query Engine data sources.
1. To edit the nonconfig Lifecycle Query Engine data source:
  1. Click the Lifecycle Query Engine data source in the list.
  2. Set the Lifecycle Query Engine relational store to Relational store
  3. Click Save.
2. To edit the config scoped Lifecycle Query Engine data source:
  1. Click the LQE scoped by a configuration data source in the list.
  2. Set the Lifecycle Query Engine relational store to Data Warehouse (indexed by: Lifecycle Query Engine rs).
  3. Click Save.
Archive the data sources that were created in Step 2 or Step 3 to ensure they remain available for back-end use only.

Topology 2

If you have created a separate data warehouse database for storing Lifecycle Query Engine relational store indexing, use the following topology.

About this task

The Lifecycle Query Engine data sources are pointed to the Lifecycle Query Engine rs, which in this topology handles both the SPARQL as well as the relational store data sources. You can also hide options for SPARQL for Lifecycle Query Engine data sources in Report Builder. For the Lifecycle Query Engine data sources, select the SPARQL is disabled checkbox to hide SPARQL options from Report Builder. If the TRS processing in Lifecycle Query Engine Triple Store (TDB) is disabled, and you connect to a data source, then the SPARQL is disabled checkbox is automatically selected.

Note: You see a beta banner on the screen when you go to any Report Builder page. To remove the beta indication, you must contact IBM support and acquire a license key. Add the license key in the Lifecycle Query Engine relational store activation key field on Advanced Properties page in Report Builder.

Procedure

In Report Builder, click the Administration icon and click Data Sources.
1. LQE
2. LQE scoped by configuration
3. Data warehouse
  This data warehouse data source connects to the data warehouse DB that is used by DCC.
On the Data sources page, click Connect to data sources.

The relational store datasource is created. The relational store connects to new data warehouse DB used for Lifecycle Query Engine with rs.
If relational store data sources are not created, then create a relational store data source:
1. Click Create a data source.
2. Name the new data source as relational store.
3. Make sure that the data source type is set to Data warehouse.
4. Enter the DB vendor, URL, and password.
5. Click Save.
Edit Lifecycle Query Engine data source:
1. Set the Lifecycle Query Engine relational store to relational store.
2. Click Save.
Edit Lifecycle Query Engine scoped by configuration data source:
1. Set the Lifecycle Query Engine relational store to data warehouse that is indexed by Lifecycle Query Engine.
2. Click Save.
Archive the data sources that were created in Step 2 or Step 3 to ensure they remain available for back-end use only.