Redgate Test Data Manager

Connections

This page will explain what connections are and how to manage them in Test Data Manager.

What is a connection?

A connection in TDM is:

  • A link to a server, database or TDM Clone instance (all generalized here as an "instance")
  • Coordinates and credentials for said instance
  • Mapped drives that instance has access to that TDM should scan for backups

Once created, a connection allows you to create images and clones, the key actions of Test Data Manager.

Legacy connections

If you set up your TDM Hub when only TDM Clone was supported as a connection type (<v0.8.15), you will have entered connection details to your singular clone instance via the config.yml file using fields like RgCloneApiToken. This approach is no longer supported, but those details will have been migrated and imported as a new connection called tdm-rgclone.


It is recommended that you delete the RgClone_ parameters in the config.yml, as changing them will no longer work and leaving them in will result in tdm-rgclone being automatically recreated if it is deleted. Should you need to edit the details of this connection, please do so in the UI.

Managing connections

This section will cover how to view, add, edit and remove connections.

Only administrators can manage connections.

The Connections Page

The connections page can be accessed via the Connections link in the navigation drawer.

There, you will be greeted with a page that looks like this

The page features:

  • A list of connections, each with an actions button
  • A button to add new connections, level with the page heading.

Adding a connection

To add a connection, click the "Add connection" button. This will open the add connection sidebar.

Here, you will be asked what you would like to name the connection, and the connection type.

Test Data Manager Clone

Test data manager clone connections require you to have set up a TDM Clone (also known as Redgate Clone) instance.

TDM Clone is a system that allows users to create whole virtualized servers in Kubernetes.

For more information about Redgate and how to set it up, please see its documentation.

Use cases

TDM Clone's key advantages over database servers are:

  • As many clones of databases can be spun up simultaneously without changing the names of the databases to avoid conflicts.
  • Whole instances (multi-database) can be restored together
    NOTE: This feature is not yet supported in TDM Hub. This must be achieved via the standalone CLIs for now.

It's disadvantages are:

  • Generally slower to restore to than database servers
  • Due to some performance limitations, it may not be the best choice for masking and subsetting operations.

To summarize, TDM Clone is mostly recommended for use to deploy clones for with test data to developers, not to perform heavy subsetting and masking operations on production data.

Connection details

The connection details needed to connect to a TDM Clone instance are:

Database servers

Database servers are typically standalone, physical servers owned or managed by your organisation. For example, a bespoke Microsoft SQL Server.

At the moment, cloud servers e.g. Azure databases are not supported.

The currently supported platforms for database servers are:

  • Microsoft SQL Server
  • Postgres
  • MySQL
  • Oracle

Use cases

Database servers key advantages over TDM Clone are:

  • Greater restore and masking / subsetting speed.
  • No need to set up new bespoke infrastructure if you already have a serviceable server.

It's disadvantages are:

  • You cannot restore whole instances (multi-db)
  • Clone database names are typically randomized to prevent collisions, so they don't always make for very good clones for developers to use.

To summarize, Database servers are best used to preform masking and subsetting operations on production data, which can then be transferred to TDM Clone to host clones for developers.

Database servers are typically the best choice for subsetting and masking operations that can be too heavy for TDM Clone.

Connection details

The only thing you need to connect to a database server is a connection string. Currently, only ADO (.NET) format connection strings are supported.

The credentials provided should typically have sysadmin or superuser privileges. You can check whether you have enough permissions using the test connection feature.

File shares

Both types of connections allow you to specify files shares.

These file shares are where the connection will look for backups to use as sources for image creation.

Currently, TDM Hub only supports one file share per connection.

For instances running on Windows machines, it is worth noting that services cannot always access network drives mapped to drive letters, so instead of using Z:\backups you might need to use the underlying address, like \\mysmbfile share\backups.

Testing the connection

All connection types feature a connection testing feature. This will use the credentials you have provided and attempt to connect to the server and check that you have sufficient permissions to perform the typical operations that must be performed on connections.

The test connection button does not currently check your access to file shares.

Editing connections

To edit an existing connection, find it in the connections list and click the actions (⁝) button, then click Edit.

You will be provided with a simplified version of the add connection sidebar.

Obfuscated fields

Note that some fields will be greyed out and either fully or partially obfuscated.

The obfuscated connection string field

This is done for security, as we do not want to fetch and expose credentials.

If untouched, these fields will remain unchanged when the save button is pressed.

If you need to update the credentials, you will need to click the edit (pencil) button, which will clear the field and allow you to enter it again.

Deleting a connection

Similarly to editing a connection, deleting is done by finding your connection in the list clicking the actions (⁝) button, then clicking Delete.

Deleting a connection will prevent users from being able to create new images and clones.

It is not possible to delete a connection if any images, and therefore also any clones, exist on the connection.



Didn't find what you were looking for?