Creating the Staging Database Tables

IT Asset Management (Cloud)

Once you have selected your staging server to be used with your adapter, and that staging server can access an operating implementation of Microsoft SQL Server running a database instance you intend to use for the staging database, you should use the script provided to create the staging database and set up the appropriate database tables within it. This can be done from SQL Server Management Studio, or from the command line as described in the following procedure.

To create staging database tables from the command line:

  1. Navigate through the unzipped archive to Adapter Tools for IT Asset Management 2024 > BMC Atrium Discovery and Dependency Mapping Tools > SQL.
  2. If necessary, copy the script ADDM_staging.sql from the \SQL folder of your unzipped adapter archive 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
    • 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.
    sqlcmd -S\Development -i C:\temp\ADDM_staging.sql
    The database ADDM_Staging is created with all necessary tables, indices, and so on.
  5. Ensure that the account under which the adapter executable will run has read/write/execute permissions on this database instance.
    Tip: Configuration of the account is done through SQL Server Management Studio.
    Authentication may be through Windows NT authentication or SQL Server authentication. Using Windows NT authentication:
    • The default account is the username running the FnmpADDMStage.exe adapter
    • The SQL connection is specified as a standard connection string, which you may supply in FnmpADDMSettings.xml, or override with the -c option on the command line.

The staging database is now ready for operation.

IT Asset Management (Cloud)