Updating the ADDM Adapter

The ADDM adapter now offers increased support for BMC Atrium Discovery and Dependency Mapping. Additional features introduced with ADDM release 11 require that, if you have previously been using this adapter, you need to update the staging database used for data import.
Note: If you are continuing to use ADDM release 10 or earlier, you do not need to update the staging database schema, and may skip this process. However, if you do apply this update to the staging database schema and continue to use ADDM release 10 or earlier, be sure to also use the latest version of the FnmpADDMStage.exe executable from the same Adapter Tools for FlexNet Manager Suite 2024 R1.zip archive. This executable transfers to ADDM data (for any ADDM version) to the staging database, and is schema-aware for the upgraded staging database.
The update is a straight-forward task, once you have the latest copy of the appropriate script.

To update the ADDM adapter:

  1. Right-click the downloaded zip archive, and choose Extract All..., saving the files in your working location.
    The path of interest in the unzipped archive is Tier 1 Adapter Tools\BMC ADDM - Atrium Discovery and Dependency Mapping Tools, which contains three folders:
    • FnmpADDMStage
    • patterns
    • SQL.
  2. Copy the script ADDM_staging.sql from the SQL\ folder to a temporary folder on your staging server.
  3. Open a command prompt on the staging server, and navigate to the folder containing the script.
  4. In the command prompt window, execute the following command, as amended: 
    sqlcmd -S ServerName\InstanceName -i TemporaryPath\ADDM_staging.sql
    where:
    • ServerName is the name of the database server hosting the staging database, or its IP address, or “.” (dot) if you are running the staging script on the same server as the database instance
    • InstanceName is the name of the database instance to use for the staging tables (this parameter may be omitted if the instance is the default instance)
    • TemporaryPath is the location where you saved the SQL procedure.
    Example: 
    sqlcmd -S 192.100.0.20\Development -i C:\temp\ADDM_staging.sql
    The database ADDM_Staging is created with all necessary tables, indices, and so on.
The schema of your staging database is updated. For more information about the latest ADDM adapter, see the relevant chapter in FlexNet Manager Suite Inventory Adapters and Connectors Reference.