Delphix Products

 View Only
  • 1.  Create database connector with properties file

    Posted 10 days ago
    Edited by Vijayender Singidi 9 days ago

    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 10 days ago

    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 9 days ago

    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 9 days ago

    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 9 days ago

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