Installing Database Mapper Software

Update: SentryOne Document is now SolarWinds Database Mapper (DMR). See the Database Mapper product page to learn more about features and licensing. Want to explore Database Mapper? An interactive demo environment is available without any signup requirements.

Introduction

Database Mapper Software is an on-premises, browser-based option for documenting your data estate. This product is a replacement for the DOC xPress product and is the self-hosted version of Database Mapper cloud.

Important:  If you are using the cloud version of Database Mapper at https://document.sentryone.com/, this article is not applicable to you.

System Requirements

  • Database Mapper System Requirements
  • IIS must be installed and enabled in your Windows OS 
    • Additional Information: See the Installing IIS article on Microsoft Docs for details on installing or enabling this features in Windows
  • Windows Authentication for IIS must be turned on
    • Additional Information: See the Windows Authentication article on Microsoft Docs for details on enabling this feature in Windows IIS
  • It uses port 44302 for the UI host and port 44322 for the API.
  • SQL Server 2012 or later (to host the Database Mapper database)

Additional Permissions

By default, the IIS application pools run as the NETWORK SERVICE account. This user (or the account you change it to) must have read/write access to:

  • C:\Program Files (x86)\SentryOne\SentryOne Document (or your custom installation directory)
  • C:\Windows\Temp
  • C:\ProgramData\SentryOne\Document\_blobStorage

If you are using Windows authentication to access the Database Mapper database, the user account must:

  1. Exist as a login account on the database server
  2. Have access to the Database Mapper database
  3. Be added to the db_datareader, db_datawriter, and db_ddlamin roles on the Database Mapper database

Note:  The Database Mapper Software installer grants the required access to the Database Mapper database for the NETWORK SERVICE account.

Installation Instructions

Where to Install

Database Mapper Software supports both single-server and multi-server setups. There are additional steps needed multi-server configurations.

Additional Information: See the blog post A New, On-Premises Approach to Documentation and Data Lineage: Database Mapper Software for details about the steps needed for multiple-server setup.

There are two install files for Database Mapper Software:

  1. SolarWinds-DatabaseMapper-Host-2021.12.exe is the file used to install Database Mapper Software on premises as shown in the steps below. It is the web client software.
  2. SolarWinds-DatabaseMapper-RemoteAgent-2021.12.msi is the file used to install the Database Mapper Remote Agent and Configuration Tool. This file should be installed after the SolarWinds-DatabaseMapper-Host-2021.12.exe installation is complete (as described below). This does not need to be installed on the same server as the web client software. It can be installed on a web server, database server, or other server entirely (as long as it has the needed access to both the web server hosting the Database Mapper web client and the database server hosting the Database Mapper database).

.NET Core Framework and Windows Hosting Services

The first part of the installation process ensures that you have the Microsoft .NET Core Framework required for Database Mapper Software. It installs Windows Server Hosting (if necessary). IIS must be installed before starting this process.

  1. Execute SolarWinds-DatabaseMapper-Host-2021.12.exe on the machine where you want to install the web client to get started.
  2. Select Accept and Install to continue.Database Mapper setup window prompting you to Accept and Install.
  3. You may need to install Windows Server Hosting (if so, you'll see a series of popups similar to the ones below). Select the box next to I agree to the license terms and conditions, then select Install, wait for the installation to complete, and then select Close.
    MS .NET Core 3.1.3 Windows Server Hosting EULA prompting you to accept terms and install.MS .NET Core 3.1.3 Windows Server Hosting Setup Progress displaying a green progress bar.MS .NET Core 3.1.3 Windows Server Hosting Setup Installation Successfully Completed message.
  4. The Setup Progress window will remain open while the installation continues.Database Mapper Setup Progress displaying a green progress bar.

Database Mapper Setup

  1. Select Next on the Database Mapper Setup screen.Database Mapper Wizard Welcome message prompting you to select Next to continue.
  2. Select the box next to I accept the terms in the License Agreement, then select Next.Database Mapper Setup EULA prompting you to agree to terms and select Next.
  3. Accept the default destination folder for installation, or use Change to specify a non-default location, then select Next.Destination Folder displaying the default installation destination and allowing you to change the destination.
  4. Enter a Server name where the Database Mapper database will be hosted. Enter a Username and Password if you want to use SQL Server authentication. Leave those fields blank to use integrated security through Windows authentication. Select Test to validate the configuration. Once the test has completed successfully, select Next.
    Configuration page prompting you to enter the Server name, Username, and Password with the option to Test the connection.Connection test pop up displaying Connected Successfully.
    Test results popup

    Note:  If your Test fails, check for firewall rules that may be blocking the connection, and ensure that you have entered your credentials correctly.

    Note:  The SQL Server Name\Instance format may be used for Server.

  5. Enter a Hostname for the server that will host the Database Mapper Software website (web client), then select Next.Website Hostname Config page prompting you to enter your Hostname in IIS used to access Database Mapper.

    Note:  You may need to enter the fully qualified domain name (FQDN) for your host. This value may be changed after installation through IIS, if needed.

  6. Select Install to begin the installation process with the configured settings. You may go Back to change any settings or select Cancel to exit the process without installing Database Mapper.Database Mapper Setup Ready to Install prompting you to select Install to begin installation.
  7. The installation process will proceed.Installation progress displaying a green progress bar.
  8. The web client for Database Mapper has been installed. Select Finish to complete the process.Completed Setup Wizard prompting you to select Finish to complete the installation.

Success: The web client for Database Mapper is now installed.

Database Mapper Setup Successful message.

What's next?

Opening Database Mapper

Open Database Mapper in your browser.

  1. Navigate to your server:port (In this example, it is http://localhost:44302)Browser window navigated to the Server port displaying a windows security login prompt requesting a username and password.
  2. Log in using your Windows credentials. Note:  You may need to use the format DOMAIN\User name (depending on your environment).
  3. Enter your Username and Password on the second Sign in screen for port 44322.Second sign in for port 44322

Success: The self-hosted Database Mapper application is ready for you to begin.

Browser window displaying the Database Mapper Solutions dashboard for the Server Port with no data to display.

Note:  There's not much to see at this point. You'll need to configure a solution and generate some documentation to see the real magic of Database Mapper.

Installing Database Mapper Remote Agent and Configuration Tool

See the Installing Remote Agents and Remote Agents articles for more information and step-by-step instructions.

Updating IIS Binding Information

See the Database Mapper Software IIS Bindings article if you need to update the IIS binding Type, IP address, Port, or Host name.

Using Database Mapper

After you install the Database Mapper Remote Agent and Configuration Tool, you can proceed to configure your first solution, then continue to the Using Database Mapper section for guides to using all the features.

Upgrading

To upgrade Database Mapper Software, run the latest DatabaseMapperSetup.exe file and follow the installation instructions above. The defaults for the server and host names may have changed since your previous installation. Please verify those values are correct for your configuration when upgrading. 

No additional configuration (re-adding) is required for the remote agents when upgrading Database Mapper Software. If an update is available for the remote agent software, that will need to be applied separately. To update a remote agent, see the Database Mapper Remote Agents article.

Download: Get the latest SolarWinds-DatabaseMapper-Host-2021.12.exe from the SolarWinds Customer Portal.

Uninstalling

Uninstall Database Mapper through Add or remove programs in Windows.

Note:  This does not remove the Database Mapper Remote Agent software, which must be uninstalled separately. To delete a remote agent, see the Database Mapper Remote Agents article.

Troubleshooting

See the Database Mapper Troubleshooting article.