delphix / dxm-toolkit

The DXM-Toolkit is a collection of compiled Python command line interface (CLI) executables to assist in automating or extending the Delphix Masking Engine functionality via the APIs.
Apache License 2.0
6 stars 15 forks source link

"September 24th 2021: To allow creating db connectors with custom properties files" #56

Open carloscuellar87d opened 2 years ago

carloscuellar87d commented 2 years ago

Is your feature request related to a problem? Please describe. A recent request from a customer is to be able to create Masking DB connectors with an option to specify a custom properties file that will be uploaded to the Masking engine.

Describe the solution you'd like To add an option in "dxmc connector add" to be able to specify a "properties" files that will be uploaded and linked to this db connector

Describe alternatives you've considered At this time, this can be done by executing straight APIs as follows:

CURL example to upload properties file:

curl -X POST --header 'Content-Type: multipart/form-data' --header 'Accept: application/json' --header 'Authorization: 3771c2bf-c5bd-4979-b72f-0502189e7bb4' {"type":"formData"} 'http://dlpxcarlos609msk.dlpxdc.co/masking/api/v5.1.9/file-uploads'

CURL output: { "fileReferenceId": "delphix-file://upload/f_d0bb53fc54104c7cbe9c84f30e65f9b3/mssql.properties" }

With that fileReferenceId, we can create a DB connector.

CURL example to create DB connector with custom properties file:

curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' --header 'Authorization: 3771c2bf-c5bd-4979-b72f-0502189e7bb4' -d ' { \ "connectorName": "test2_auto", \ "databaseType": "MSSQL", \ "environmentId": 1, \ "databaseName": "test", \ "host": "test", \ "instanceName": "test", \ "port": 1433, \ "schemaName": "test", \ "username": "test", \ "kerberosAuth": false, \ "enableLogger": false, \ "fileReferenceId": "delphix-file://upload/f_d0bb53fc54104c7cbe9c84f30e65f9b3/mssql.properties" \ }' 'http://dlpxcarlos609msk.dlpxdc.co/masking/api/v5.1.9/database-connectors'

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