Skip to content

"September 27th 2021: To add a feature to switch from authentication user/method for MSSQL dSources" #192

@carloscuellar87d

Description

@carloscuellar87d

Is your feature request related to a problem? Please describe.
IHAC that has deployed a large number of MSSQL dSources and they are using Domain authentication for all of them.
However, we need to switch them to use SQL Server DB authentication and we would like to have an option with dxtoolkit to do it.

Describe the solution you'd like
There is an option to UPDATE dsources using dx_ctl_dsource, so if we could reuse the same binary with only few mandatory options would be great.

Something like this:

./dx_ctl_dsource -d dxcarlos6010 -type mssql -sourceinst MSSQLSERVER -sourceenv carloswinsrc -dbusertype database -dbuser "testuser" -password ***** -group Sources -dsourcename Macaroon -action update

Describe alternatives you've considered
At this time, this can be achieved with straight APIs:

API: === POST /resources/json/delphix/sourceconfig/MSSQL_SINGLE_CONFIG-7 ===
Payload:
{
"type": "MSSqlSIConfig",
"mssqlUser": {
"type": "MSSqlDatabaseUser",
"user": "usertest",
"password": {
"type": "PasswordCredential",
"password": "*****"
}
}
}

Additional context
Add any other context or screenshots about the feature request here.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions