How to Locate the MSSQL Dataset Based on Staging Database Identifier (KBA6911)

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0
5.3	5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0
5.2	5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
5.1	5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0
5.0	5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4
4.3	4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0
4.2	4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1
4.1	4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

How to Relate Staging ID to Dataset

All Delphix MSSQL dSources require a staging database instance for recovery operations.  In some instances, it may be necessary to reconcile the dSource with a staging database instance based on the instance name or filesystem path under the Connector directory:

Taking an example from the screenshot above, a given staging database instance / path such as:

564dc311-0d9b-21cb-3682-e020616764cc-staging-85

There are two unique identifiers in this path (highlighted in bold); the Engine UUID, and the internal "container" reference.

The Engine UUID can be reconciled by viewing Engine details under Help - About in the Admin menu.  This will reconcile to the Server ID and Serial:

Once the Engine is identified, the internal "container" reference ID from the path can be used in the Engine web UI to locate the dataset, by adding the ID to the path after "MSSQL_DB_CONTAINER-":

http://<ENGINE>/Server.html#/dataset/MSSQL_DB_CONTAINER-##/config/source

Using the previous example, we find the container reference to be 85, from our example Engine name "DelphixEngine.delphix.com".  The hyperlink would therefore be entered into the Browser address bar as:

http://delphixengine.delphix.com/Server.html#/dataset/MSSQL_DB_CONTAINER-85/config/source

The Dataset configuration details will then be presented, and can be used to confirm the expected Staging Environment association: