Delphix Products

Expand all | Collapse all

Details for connecting Production(on premises mssql server ) with delphix vir and masking

  • 1.  Details for connecting Production(on premises mssql server ) with delphix vir and masking

    Posted 04-15-2021 11:52:00 AM
    Hi Team,


    Am planning to connect Production database(on- premises - mssql server type) with delphix engine( vir and masking).so need solutions for doing a basic connection with the below queries:

    1)What are basic Database access required for connecting (example: server roles, User roles similarly other..)

    2)If DB owner access is necessary to connect, if my client denies to provide DB owner access, they are providing only DB- reader access, what is the possible access necessary for doing connection.

    3)Is it compulsory to have DB owner access?

    4)what is the most necessary access to have basic connection and update Database in case of masking.

    5)DB-reader access is alone enough to make the entire connection?

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


  • 2.  RE: Details for connecting Production(on premises mssql server ) with delphix vir and masking

    Posted 04-16-2021 02:16:00 AM
    Hi Anushruthi

    The requirements for connecting to a new SQL Server DB are outlined in our doc - Quick Start Guide for SQL Server (Microsoft SQL Server on Windows)

    For a masking engine, please follow the steps in our documentation, starting with Managing Environments

    Many thanks

    ------------------------------
    Andrew McLennan
    Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Details for connecting Production(on premises mssql server ) with delphix vir and masking

    Posted 04-16-2021 01:57:00 PM
    Edited by John Leser 04-16-2021 01:57:21 PM
    Hi Anushruthi,

    You may find these two doc pages helpful for determining your requirements for masking:

    General Permissions need for masking: https://maskingdocs.delphix.com/Preparing_Data/Managing_Permissions/
    SQL Server specific setup information: https://maskingdocs.delphix.com/Preparing_Data/Preparing_SQL_Server_Database_For_Profiling_and_Masking/

    Regards,

    ------------------------------
    John Leser
    Staff Engineer
    Delphix
    ------------------------------