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 22 days ago
    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 21 days ago
    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 21 days ago
    Edited by John Leser 21 days ago
    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
    ------------------------------