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.
To configure the database owner
- On the BMC Client Management master, navigate to the directory where BMC Client Management is installed (typically
\Program Files\BMC Software\Client Management\Master). - Open the
Vision64Database.inifile from the\Master\configdirectory. - Locate the
User=line, theusernamespecified here is the database owner.
To configure the schema prefix
- Open SQL Management Studio on the SQL server where the BMC Client Management database resides.
- 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).
- 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:
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.
Comments
Log in or register to comment.