Database Mapper Configuration Utility

Prerequisites

Before installing Database Mapper Software, ensure your credentials and machine(s) meet the System Requirements as well as the security and additional requirements listed below.

Additional Requirements

  • Chrome and Microsoft Edge (the Edge version based on Chromium) are the recommended browsers for using Database Mapper Software.
    • Note:  Only Windows devices are officially supported.
  • The preferred IP address and port that Database Mapper software should use to listen for HTTP traffic.

Note: 

  • If you plan to change the binding address or port, ensure that there isn't already something listening to that address and port on the machine.
    • If you are running Database Mapper Software on a virtual machine, it's recommended to keep the default IP address of 0.0.0.0. Setting it to 127.0.0.1 may make it so that it can be accessed from the local host, but not other locations in the domain.
  • The default port for the Database Mapper Software Host is 44302.
  • The default port for the Database Mapper Software API is 44322
  • It's recommended to set the IP address to 127.0.0.1 if you're planning to route requests through IIS or other reverse proxy on the same machine as the service. This will prevent external requests from directly reaching the service.

Database Mapper Software Configuration Utility

Changes to your Database Mapper Software configuration must be made through the Database Mapper Configuration Utility (DMCU).

Installing the DMCU

The Database Mapper Configuration Utility is installed through the Database Mapper Software Installer

Accessing the DMCU

Database Mapper Software

After installing Database Mapper Software, the Database Mapper Configuration tool is set to launch by default. You can also locate the DMCU through the file directory or use the Windows Start menu as Database Mapper Configuration Utility . When you open the DMCU, use the Run as administrator option to open it.

Database Mapper Configuration Utility Run as administratorDatabase Mapper Configuration Utility

File path:

  1. Navigate to the SentryOne DocumentConfigUtility directory in your Database Mapper Software installation. The default path is C:\Program Files (x86)\SentryOne\SentryOne Document\SentryOneDocumentConfigUtility. In this example, we are using the default file path.
  2. Locate the SentryOne.Document.WebClient.ConfigurationUtility file and use the Run as administrator option to open it.

    Database Mapper Configuration Utility Run as administratorDatabase Mapper Configuration Utility File Path example

Using the DMCU

The DMCU allows you to change database, network, security, and web server binding-related properties for Database Mapper Software. Select the Verify & Save button to apply any changes.

The DMCU also provides an option to stop/start the Database Mapper Host and API Services (Database Mapper Host and Database Mapper API in Windows Services).

Important:  If the Database Mapper Services failed to install, open the Event Viewer for more information.

Connect to Database

Database Mapper Configuration Utility Database Connection

Option Description
ServerThe Server name where Database Mapper software is installed.
Database NameThe Database name for your Database Mapper software installation. Note:  The Database Name is SentryOneDocument by default.
UsernameThe login used for the Database Mapper Remote Agent service.
PasswordThe password for the Database Mapper Remote Agent service login.
Windows Login / SQL LoginThe Windows or SQL Server credentials for your Database Mapper software server connection.

Advanced Options

Database Mapper Configuration Utility Connect to Database Advanced Options

OptionDescription
PortThe port used to connect to your Database Mapper software site.
Packet SizeThe network packet size for your Database Mapper connection. Select an option from the drop-down list.
Encrypt Network TrafficSelect the checkbox to encrypt network traffic.
Trust Server CertificateSelect the checkbox to trust the server certificate.
Multi SubnetSelect the checkbox to apply multi subnet to the connection.

Additional Information: For more information about the settings in the Advanced Properties:

Hosting Account

Database Mapper Configuration Utility Hosting Account

OptionDescription
UsernameThe username for the hosting service.
PasswordThe password for the hosting service username.
IP
The binding IP address for your connection. Use the drop-down list to select an IP address.
Host DomainThe friendly name of the host domain.

Advanced Options

Database Mapper Configuration Utility Hosting Account Advanced Options

OptionDescription
API PortThe port used to connect to the API Service. Note:  The default API Port is 44322.
Host PortThe port used to connect to the Host Service. Note:  The default Host Port is 44302.
Use HTTPSSelect the checkbox to Use HTTPs and enter a TLS certificate.

Use TLS

To use TLS for SolarWinds Database Mapper: 

  1. Select the box next to Use HTTPS. Once selected, you'll see the TLS Certificate section.
  2. Enter the name of the certificate in Subject.
  3. Select Next to continue with the Database Mapper configuration.
    Database Mapper Configuration Utility Hosting account Use HTTPS TLS cert example

Success: You have enabled TLS for SolarWinds Database Mapper. Use HTTPS:// at the beginning of the URL to open it in your browser.

Note: 

  • For a signed certificate from a trusted authority, you must register it on the machine so it goes into the LocalMachine/My store.
  • When updating a certificate, you need to add it to the machine. Database Mapper will use the latest valid certificate (by expiration date) without requiring a restart of the machine or service. Older, invalid, and expired certificates will be ignored.

Review

Database Mapper Configuration Utility Review screen

The Review screen displays your configured options for your Database Connection and Hosting Connection.

Services

Database Mapper Configuration Utility Services screen

The Services screen displays after you've completed your configuration settings. The Host Service and API Service are installed automatically after configuration, and can be started/stopped from this screen. 

OptionsDescription
Uninstall ServicesUninstalls the API and Host services.
Edit ConfigurationOpens the Connect to Database screen and allows you to change your configuration options.
ResetSelecting this option resets the state of the services. Note:  Use the Reset option when the API and Host Services indicate they are running but they are actually stopped. 
Copy LinkCopies your Database Mapper connection URL to the clipboard.
Start HereOpens your Database Mapper URL connection.

Establishing your Connection

Use the Database Mapper Configuration Utility to create a site for your Database Mapper Software environment. Establish a connection by completing the following steps:

1. Open the Database Mapper Configuration Utility as an administrator.

Database Mapper Configuration Utility Run as administrator

2. Enter your Database Server for your Database Mapper Software connection. Database Mapper Configuration Utility Connect to Database enter server name

Note:  The database for Database Mapper Software is named SentryOneDocument. If you don't have a Database Mapper Software database, the SentryOneDocument database will be installed onto your Database Server.

3. Select the credentials to use for your database connection, and then enter a valid username and password.Database Mapper Configuration Utility Database Connect to Database enter server credentials

Note:  If you select Windows Login and don't enter a username, the Database Mapper Configuration Utility will use the Windows Service account.

4. Select Advanced Options and configure any applicable options for your database connection. Select Next to continue to the Hosting Account configuration.Database Mapper Configuration Utility Connect to Database Advanced Options select Next

Additional Information: For more information about Advanced Options within the Database Mapper Configuration Utility, see the Advanced Options sections. 

5. Enter the username and password that will be used for the service account.Database Mapper Configuration Utility Hosting Account enter service user credentials

Note:  The username should use the following syntax: <server\username>.

The DMCU will use the local service account if the Service user username and password are left blank.

6. Select the IP address you want to use from the drop-down menu and then enter the domain name (friendly name) in the Domain field.

Database Mapper Configuration Utility Hosting Account select IP

7. Select Advanced Options and configure any applicable options for your hosting account. Select Next to continue to the review screen.Database Mapper Configuration Utility Hosting Account Advanced options select Next

8. Review the information you've entered for the Database Connection and Hosting Connection. Select Next to continue.Database Mapper Configuration Utility Database Connection and Hosting Connection review select Next

Note:  Selecting Next automatically installs the Host and API services.

9. Select Start for the Host Service and API Service.

Database Mapper Configuration Utility Services start service

10. Select Start Here to open your Database Mapper Software connection in your web browser. Note:  You can also select Copy Link to copy the Database Mapper URL to your clipboard. Your URL will use the following syntax: http://ServerName:HostBinding or http://IpAddress:HostBinding.

Database Mapper URL http://ServerName:HostBinding example
http://ServerName:HostBinding example

Database Mapper URL http://IpAddress:HostBinding example
http://IpAddress:HostBinding example

Note:  In this example, our Database Mapper Software URL is http://localhost:44303 or http://127.0.0.1:44303. You will be prompted to login with your Integrated or SQL Server Credentials used for the Hosting Services account.Database Mapper Windows Security prompt

Important:  If you selected the Use HTTPS checkbox, your URL will begin with https:// .

What's Next?

After configuring your Database Mapper Software installation you need to install the Remote Agent(s) and Solution Configuration Tool.