Delphix Products

 View Only
  • 1.  Masking with Api-client

    Posted 01-12-2021 08:17:00 AM
    Edited by Anu Shruthi Sathyanathan 01-12-2021 08:34:38 AM
    Hi Team,

    we are doing making api-client but one difference i could see while manually creating data base connector in engine , there will be no SID but with POST query in API-client for Database connector asks for SID, what to provide in that.

    ------------------------------
    Anushruthi Sathyanathan
    Delphix Community Members
    ------------------------------


  • 2.  RE: Masking with Api-client

    Posted 01-12-2021 04:21:00 PM

    Hello Anushruthi, 
                              SID is normally required for database connectors. What type of database connector (Oracle. Sql Server etc) are you trying to create?  Database connectors use jdbc connection to connect to the database and without SID, the connector will not be able to contact the database.


    Please share more details around it. Screenshot from masking engine UI will be very helpful which you use to create connector without SID.



    ------------------------------
    Jatinder Luthra
    Principal Architect, Field Services
    Delphix
    ------------------------------



  • 3.  RE: Masking with Api-client

    Posted 01-14-2021 02:28:00 AM
    Hi Jatinder,

    Thank you for the response, In manual connector creation, we normally wont provide any SID (MS SQL SERVER -Database type), if that is the case , while creating job via api-client , how that works in Put (api-client swagger page) , what is the value to be provided for SID?

    where to check for SID ?

    Database type - MS SQL SERVER

    Thanks!
    Anu Shruthi

    ------------------------------
    Anushruthi Sathyanathan
    Community Member
    Liberty Mutual Insurance
    ------------------------------



  • 4.  RE: Masking with Api-client
    Best Answer

    Posted 01-14-2021 03:12:00 PM
    Hello Anushruthi,        
                              SID is only for the Oracle database. For SQL Server database, you need to use the database name.

    Here is an example of API call to create an MSSQL connector.

    curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' --header 'Authorization: 5831cd68-122f-4269-b40d-accef05b3677' -d '{ \
    "connectorName": "Test123", \
    "databaseType": "MSSQL", \
    "environmentId": 4, \
    "host": "10.0.1.60", \
    "password": "delphix", \
    "port": 1433, \
    "schemaName": "DBO", \
    "databaseName": "vdev", \
    "username": "delphix" \
    }'
    http://10.0.1.10/masking/api/database-connectors



    ------------------------------
    Jatinder Luthra
    ------------------------------