delphix / dxtoolkit

Scripts that remotely interact with Delphix engine APIs
Apache License 2.0
38 stars 32 forks source link

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

Open carloscuellar87d opened 3 years ago

carloscuellar87d commented 3 years ago

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.