Online Help for Administrators > Getting Started > Configuring and managing data collection > Managing the ManagementDB / ProfileDB data collection > Create a new ManagementDB / ProfileDB connection

Create a new ManagementDB / ProfileDB connection

  1. In the Administration Console, click Collection Configuration > ManagementDB / ProfileDB.
    The ManagementDB / ProfileDB page opens.
  2. Under Management Database, click Create New.
    The Connection Parameters dialog box appears.
  3. In the Connection Parameters dialog box, specify or type the connection parameters:
  4. Field Description
    Host name

    Name of the Management database server. Host name is not displayed when Management DB on Oracle RAC is selected or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected.

    Port Port number to query the Management database server. Port number is not displayed when Management DB on Oracle RAC is selected.
    Database instance

    System Identifier (SID) of the Management database instance. Database instance is not displayed when Management DB on Oracle RAC is selected.

    Note: For information about the database host name, port number, and SID, contact your HP Business Service Management administrator.

    Database type The type of database engine that is used to create the Management database. It can either be Oracle or MSSQL.
    Windows Authentication

    If you have selected MSSQL as the database type, you have the option to enable Windows authentication for MSSQL, that is, the user can use the same credentials to access SQL Server as that of the Windows system hosting the database.

    ManagementDB on Oracle RAC This option appears only if you have selected Oracle as the database type. If only ManagementDB on Oracle RAC is selected and Profile DB on Oracle RAC is not selected, the profile database details are configured automatically.
    ProfileDB on Oracle RAC This option appears only if you have selected Oracle as the database type. Configure the profile database parameters only when this option is selected.
    Database name Name of the database. This field appears only if MSSQL is selected as the database type.
    Service name

    This option appears only if Management DB on Oracle RAC is selected

    Note:Service name is displayed instead of the Host name when users select only Management DB on Oracle RAC or both Management DB on Oracle RAC and Profile DB on Oracle RAC.

    User name

    Name of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database.

    Note: If the Windows Authentication option is selected, this field is disabled.

    Password

    Password of the Management database user, which was specified in the BSM Configuration Wizard when setting up the Management database.

    Note: If the Windows Authentication option is selected, this field is disabled.

  1. Click OK.
  2. Click Save.
    A Saved Successfully message appears in the Information message panel.

Note: You can only create a single Management database data source connection, after which the Create New button is automatically disabled.

After you save the newly created Management database connection, SHR retrieves the Profile database information from the Management database data source and lists all the available Profile database data sources under the Profile Database section.

To view details of the Profile database data source connection:

  1. Under Profile Database, in the Host name column, click the icon.
    The pop-up box opens that displays details of the Profile database system.
  2. View:
  3. Field Description
    Host name Name of the Profile database server.
    Port Port number to query the Profile database server.
    Database instance

    System Identifier (SID) of the Profile database instance.

    DB type The type of database engine that is used to create the Profile database. It can either be Oracle or MSSQL.
    Database name Name of the Profile database.
    User name

    Name of the Profile database user.

Note:Set up parameters for the profile management database, only if Profile DB on Oracle RAC is selected, or when both Management DB on Oracle RAC and Profile DB on Oracle RAC are selected. In such an instance, the Create New option under Profile Database is displayed.

Data collection for the Profile database data source is enabled by default. In addition, the collection frequency is scheduled for every one hour.

Note: Copy the seed.properties and encryption.properties files from the %topaz_home%\Conf folder on HP BSM DP Server to the %PMDB_HOME%\config folder on the HP SH Reporter system to discover Profile DB.In case of Oracle RAC copy bsm-tnsnames.ora in addition to these files.


© 2010 - 2013 Hewlett-Packard Development Company, L.P.