Configuring LQE relational database connection

To configure LQE relational database connection, proceed as follows:

About this task

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 LQE 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 Relational Store is enabled by default.