Overview

The Redgate Test Data Manager GUI provides an intuitive interface for managing your test data operations. This guide walks you through installing and configuring the GUI on Windows systems.

Requirements

The following requirements are for the machine that will be running Redgate Test Data Manager GUI (the host):

Hardware requirements

Software requirements

Step 1: Download the installer

• Download the TDM Hub GUI installer from our download page.
• Extract the zip file to a temporary location
• Locate the .msi file - This is your installer

Step 2: Database setup 

The GUI requires a dedicated SQL Server database for storing operational data.

Quick Setup Checklist

• Create an empty database named "TDM"
• Have a SQL authentication user with db_owner permissions on the TDM database - Microsoft guide
• Ensure TCP/IP protocol is enabled - Microsoft guide
• Ensure mixed mode authentication is enabled - Microsoft guide

Need detailed database setup help? Don't hesitate to contact us for support!

Step 3: Activate your Redgate product license

• Activate your license 

Step 4: Installation procedure

Run the installer 

• Extract the installer zip file you downloaded.
• Run the .msi  file that was extracted.

Welcome and Eula

• Click next, then read and agree to EULA agreement to continue.

Configure port

• Input port numbers that are available.
  • This will be used as a port for hosting the GUI.
  • The application needs two ports to work properly:
    • HTTP port is only there to help redirect users to the secure (HTTPS) one.
    • HTTPS port is the main one used to run the application.
  • If you are unsure, use the given default value.
  • There will be a pop-up to ask for network access, which is solely for port validation only. Please do press allow.
• After the validation was successful, you can click next.

SSL Certificate Password

• Set a password for a self-signed certificate.
  • Record this password for future reference

Security Note: The installer creates a self-signed certificate in this step for the web server to use.

Database Connection

• Edit connection string to be able to connect to the created TDM database and click validate.
  • If you are uncertain, we have a guide on how to edit the connection string.
• After the validation was successful, you can click next.

Editing connection string guide

• Example format: Server=DB_INSTANCE_NAME,DB_PORT;Database=TDM;User Id=USER_ID;Password=USER_PASSWORD;
  • DB_INSTANCE_NAME  is where you put your database instance name (Ex. localhost)
  • DB_PORT  is where you put in a port that your database accept
    • If you don't have any prefer port, remove ",DB_PORT".
  • USER_ID  is where you put your username for connecting to TDM database
  • USER_PASSWORD  is where you replace it with your password for the USER_ID  you use.

Connection failing?

• Verify SQL Server is running
• Check that TCP/IP is enabled
• Ensure your user has db_owner permissions on the TDM database
• Test the connection in SQL Server Management Studio first

GUI login password

• Define a password that will be used for signing in to use the GUI and click next.
  • This is separate from your database password
  • You'll use this to log into the GUI

Install

• Select install (Required Administrator)
• After finished the installation, click Finish.

What's next?

• At this point, you can check the GUI by going to http://localhost:{inputted_port_number}
  • Example: http://localhost:8080 (default port is set to 8080)
• It may take a minute or so for TDM to run its database migrations if there are any, during which time the UI will show this message:
  
• Once this is done, you can check if the upgrade has been successful by highlighting over the name of the application and checking the version.