Hi Vijayender,
Apologies, I missed the API component of the question.
You will need to upload the properties file first:
I would recommend to keep the "permanent" setting to false the file will be in the Masking engine as long as the database connector is in place and, if you delete the connector, the properties file will be cleaned up automatically.
Expected output is a fileReferenceId:
{
"fileReferenceId": "delphix-file://upload/f_b75cd79849e140eb800646c969d7767d/mssql.properties",
"filename": "mssql.properties",
"fileSize": 72,
"persistenceType": "OBJECT/TEMPORARY"
}
With that information, you can create a new connector as follows:
I used json properties from an existing database connector for MSSQL as a reference and added he password property.
Let us know if you have any further questions.
Thank you.
Sandro
------------------------------
Sandro Latini
Principal Support engineer
Delphix
------------------------------
Original Message:
Sent: 05-23-2023 08:59:52 AM
From: Vijayender Singidi
Subject: Create database connector with properties file
Thanks Sandor, but would like to have the properties file added while creating the connector through API call
------------------------------
Vijayender Singidi
Original Message:
Sent: 05-23-2023 03:48:56 AM
From: Sandro Latini
Subject: Create database connector with properties file
Hi Vijayender,
You can find more information on how to create a properties file and how to provide it to the MSSQL database connector in the following blog article here: https://community.delphix.com/blogs/sandro-latini/2022/07/06/converting-mssql-advanced-database-connectors-to-b (Section Migrating to the Basic Connector with Property File) and also in our KBA here: https://support.delphix.com/Continuous_Compliance_Engine_(formerly_Masking_Engine)/Configuring_a_Masking_Connector_to_Work_with_an_AD_Account_(KBA1820)
Let us know if you have any further questions.
Thank you.
Sandro
------------------------------
Sandro Latini
Principal Support engineer
Delphix
Original Message:
Sent: 05-22-2023 11:57:17 AM
From: Vijayender Singidi
Subject: Create database connector with properties file
HI all,
is there any way to create database connector for SQL server with windows authentication. if so how add properties file while creating the connector.
Thanks in advance
------------------------------
Vijayender Singidi
------------------------------