Configuring Lifecycle Query Engine relational database connection

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

Procedure

  1. 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
  2. Restart the application server for Lifecycle Query Engine and Report Builder.
  3. On the Lifecycle Query Engine Administration page navigation, under Relational Store, click Settings.
  4. 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 = *******
  5. 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.