Configuring the data warehouse database connection

To support the reporting functions provided by BMC Database Automation, or to use BMC Decision Support – Database Automation to create reports for your environment, you must configure a connection to the data warehouse database where the data to create the reports is stored. This topic describes how to configure the data warehouse database connection.

To configure the data warehouse database connection

1. In the Context Frame, select Configuration > Configuration.

2. In the Configuration page, provision the following fields.

   Section	Field	Description
   Reporting Database	Connection String	Define the location of the external monitoring target. Example of a valid connect string: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=10.100.5.181) (PORT=1521))) (CONNECT_DATA=(SID=ORA10G)))
   	Username	Enter the user name for the BMC Database Automation Data Warehouse user database account (DWDB_USER from To create a new data warehouse database schema).
   	Password	Enter the password for the BMC Database Automation Data Warehouse user database account (DBDW_PASSWORD from To create a new data warehouse database schema).

3. To ensure that the settings are accurate before you save them, click Test Connection to test the connection to the data warehouse database.
4. If the test is successful, go on to the next step.
   If the test is unsuccessful, verify that the Connection String value and user credentials are correct.
5. Click Save Settings.

Where to go next

Schedule the exporting of data from the Manager to the data warehouse database.