Configuring Lifecycle Query Engine relational database connection

To configure Lifecycle Query Engine relational database connection, proceed as follows:

Before you begin

You must create a data warehouse databases with DB2 or Oracle beforehand. For more information, see:

Note: Lifecycle Query Engine rs supports only the data warehouse databases that are created with Db2 or Oracle. The Derby databases are not supported.

After you create the data warehouse database, start JTS and run the setup. At step-5: Configure data warehouse of the setup process, update the JDBC location to point to the data warehouse database that you created. Update the JDBC password, and click Test Connection to verify the connection to the data warehouse. When the DW is connected, click Create Tables to create the new schemas and tables for the data warehouse. Alternatively, you can run repotools-jts createWarehouse command to create the tables.

Procedure

Use the following properties to use relational store for reports:
- Use relational store as default for new reports lqe.dw.trs.default=true
- Use a relational store for all reports lqe.dw.trs.override=true
Restart the application server for Lifecycle Query Engine and Report Builder.
On the Lifecycle Query Engine Administration page navigation, under Relational Store, click Settings.
Under Data Warehouse Connection, confirm if the JDBC connection details per-filled from JTS are correct. Enter the JDBC password if needed and then click Save to confirm the connection properties. If information is missing, then you need to add database properties to dbconnection.properties:
```
dw.db.vendor = DB2
dw.db.location = //<host>:50000/jazzdw:user=jazzdb;password={password};
dw.db.password = *******
```
On the Configure Data Warehouse page, provide information to set up a connection to the data warehouse. The data warehouse is a database that is used for reporting and analytics. By default, the application is configured to use the Derby database that is included with the application. However, because Lifecycle Query Engine rs only support Db2 or Oracle, you must configure the Jazz Team Server to connect with the data warehouse database created with Db2 or Oracle.
1. Optional: To defer configuring the Data Warehouse, click I do not wish to configure the data warehouse at this time. If you do not configure the data warehouse, your applications will be functional but you will not store any reporting data and most reports will not work.
2. In the Configure Data Warehouse Database Vendor and Connection Type section, select your Database Vendor and Connection type for that database vendor. In the Configure Data Warehouse Database Connection Properties section, type the connection properties to connect to your newly create data warehouse database. The required values vary depending on your database vendor and connection type.
3. For Oracle , in the Database Table Space Folder field, type the path to an existing directory on the database server where the table space will be created and specify any additional advanced server properties for your database:
  - (Db2 and Oracle only) Temporary Table Space
  - ODS Table Space
  - ODS Index Table Space
  - Star Table Space
  - Star Index Table Space
  - Custom Report Database User
4. Click Test Connection to verify that the server can successfully communicate with the database by using the connection information that you provided.
5. If you did not previously use a repotools command to create the database tables, you might see a warning that the database exists but that it does not contain any tables. To create the tables, click Create tables. You might have to wait several minutes for the command to finish.
  If you are using the default Derby data warehouse, you will not see this warning.
6. Click Next.
If you are upgrading from a prior version of Report Builder for which the relational store was not setup, enable TRS processing into the relational store. For a new Report Builder version 7.1 installation, the Lifecycle Query Engine rs is enabled by default.