Configuring the SQL database for CMDB integration

The configuration for the integration component is stored in the BCM configuration form. If your BMC Client Management database resides on a Microsoft SQL server, some database specific configuration will be required. Follow the ensuing steps to add this configuration to the BCM configuration form.

Previously, when the InstallerFramework package was used, the BCMConfig.properties file contained the database configuration details. Now, with removal of this file, this configuration is done through a new form called BCM:Configuration. You have to access this form and modify the configuration or use the default values. For more information, see Managing-the-Development-to-Production-D2P-Package.

For Microsoft SQL databases, the database owner name, and schema prefix will need to be added to the BCM configuration form. Follow the ensuing steps to locate this information, and add it to the configuration form.

Related topics

Managing-the-Development-to-Production-D2P-Package

BMC-Helix-CMDB-BMC-Client-Management-class-mapping

Filters-for-integration-with-BMC-Helix-CMDB

Updating-the-BMC-Helix-CMDB-database-with-BMC-Client-Management-data

To configure the database owner

  1. On the BMC Client Management master, navigate to the directory where BMC Client Management is installed (typically \Program Files\BMC Software\Client Management\Master).
  2. Open the Vision64Database.ini file from the \Master\config directory.
  3. Locate the User= line, the username specified here is the database owner.

To configure the schema prefix

  1. Open SQL Management Studio on the SQL server where the BMC Client Management database resides.
  2. After logging into Management Studio, in the Object Explorer section on the left side of the window, expand Databases > Your Database > Tables (replace Your Database with the name of your BMC Client Management database, typically bcmdb).
  3. Note the name appearing to the left of the dot in the table names; this is the schema owner. As an example, in the following screenshot, we can see that the schema owner is bcmdbuser:
    atrium_int_bcmdbuser.jpg  

After identifying the database owner, and schema prefix, please add these values to the SQLDBOWNER and SQLSCHEMAPREFIX parameters in the BCM:Configuration form (for information on how to access the configuration form, see Managing-the-Development-to-Production-D2P-Package). For example, if the schema prefix and database owner are both bcmdbuser, these parameters should be entered as shown (note the dot at the end of the SQLSCHEMAPREFIX parameter, please ensure this dot is entered in your configuration file also):

SQLDBOWNER=bcmdbuser
SQLSCHEMAPREFIX=bcmdbuser.