Adding a Read-Scale Availability Group database to Delphix (KBA7150)

Issue

• A Read-Scale Availability Group (Read-Scale AG) does not have or need a cluster context, therefore the environment must be added as standalone.
• However, the Delphix engine does not discover AG databases configured in the Read-Scale AG if the environment has been added as standalone. 

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, 6.0.6.0, 6.0.6.1
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

Resolution

Once the environment has been added as standalone, you need to create the database configuration manually via the CLI.
There are three fields required:

1. databaseName
2. environmentUser
3. repository

The TAB key can be used to auto-complete the fields:

ssh admin@delphix

delphix > sourceconfig create
delphix sourceconfig create *> set databaseName=McLaren
delphix sourceconfig create *> set environmentUser=source.delphix.com/domain\username
delphix sourceconfig create *> set repository=sandro9src.dcol1.delphix.com/SQL2017
delphix sourceconfig create *> ls
Properties
    type: MSSqlSIConfig (*)
    databaseName: McLaren (*)
    environmentUser: source.delphix.com/domain\username (*)
    linkingEnabled: true
    mirroringState: (unset)
    recoveryModel: (unset)
    repository: sandro9src.dcol1.delphix.com/SQL2017 (*)
delphix sourceconfig create *> commit
    `MSSQL_SINGLE_CONFIG-3

• After creating the configuration, it is possible to navigate to Manage / Environments, select the source environment and then, on the Databases tab, click Add dSource next to the database name.
• From there, the workflow to add the dSource is the same.
• Check that the type is set to MSSqlSIConfig before committing.