Delphix Products

 View Only
  • 1.  Create database connector with properties file

    Posted 05-22-2023 11:57:00 AM
    Edited by Vijayender Singidi 05-23-2023 09:01:06 AM

    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 through API.

    Thanks in advance



    ------------------------------
    Vijayender Singidi
    ------------------------------



  • 2.  RE: Create database connector with properties file

    Posted 05-22-2023 12:03:00 PM

    Hi Vijayender,
    I moved your discussion to the Delphix Products community. You should get more traction here.

    Thanks,
    Michael



    ------------------------------
    Michael Torok
    Digital Customer Experience, Senior Director
    Delphix
    ------------------------------



  • 3.  RE: Create database connector with properties file

    Posted 05-23-2023 03:49:00 AM

    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
    ------------------------------



  • 4.  RE: Create database connector with properties file

    Posted 05-23-2023 09:00:00 AM

    Thanks Sandor, but would like to have the properties file added while creating the connector through API call



    ------------------------------
    Vijayender Singidi
    ------------------------------



  • 5.  RE: Create database connector with properties file
    Best Answer

    Posted 05-23-2023 09:21:00 AM

    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
    ------------------------------