How to determine the name of the Data Aggregator user for querying the Data Repository database

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

When querying the Data Repository it may be required to use the Data Aggregator user to make sure the correct schema is used for the queries.

Environment

Release : DX NetOps Performance Management All Supported Relases

Resolution

The Data Aggregator user can be found in the  /opt/IMDataAggregator/apache-karaf-2.4.3/etc/dbconnection.cfg file as:

dbUser=<username>

For example:

dbUser=dauser

Additional Information

NOTE: Above uses the default installation path, your installation path may vary.