Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference


Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

Source hosts are the servers that contain data sources to which the Delphix Engine links and from which it provisions virtual databases. Collectively, the source host and its databases are referred to as the source environment. This topic describes the requirements for creating connections between the Delphix Engine and SQL Server source hosts and databases.

Requirements for SQL Server Source Hosts and Databases

Each SQL Server source host must meet these requirements:

  • Either the source host must belong to the same Windows domain as the target environments, or the domain that the source environment uses must have appropriate cross-domain trust relationships established with the target environments' domains
  • Source hosts can be running any supported Windows operating system version. For more information, see the topic Supported Operating Systems, Server Versions, and Backup Software for SQL Server.
  • The SQL Server instance on the source host should run as either domain users or local service accounts. Delphix does not support running SQL Server instances as local user accounts or Managed Service Accounts (MSA).
  • The validated sync environment that the Delphix Engine uses must have access to an existing full backup of the source database in order to create the first full copy. Alternatively, the Windows Database User described below must have permissions to initiate a copy-only full backup of the source database.
  • Backup images of the source database, including full, differential, and/or transaction logs, must be available over an SMB share to a staging environment. For more information, see the topic Setting Up SQL Server Environments: An Overview.
  • You must enable TCP/IP access for each SQL Server instance that contains a database to which the Delphix Engine will link
    • To enable TCP/IP access, access the SQL Server Config Manager and select Network Configuration > Protocols > TCP/IP
  • If the source database is backed up with third-party backup software like LiteSpeed or Red Gate SQL Backup Pro, you must also install the backup software on the validated sync environment. For backup software compatibility requirements, see the topic Supported Operating Systems, Server Versions, and Backup Software for SQL Server.
  • Delphix regularly queries "msdb.dbo.backupset" to find out if a new backup image has been created and needs to be synchronized with Delphix. Microsoft recommends maintaining this table with "sp_delete_backuphistory". Periodically deleting rows from this table improves the performance of queries running against it and reduces the load on the source database.

Linking to Databases on Windows Server Failover Clusters

You can use databases on Windows Server Failover Clusters (WSFC) as data sources. Add the environment as described below, based on which WSFC feature the source databases use:

  • Failover Cluster Instances
    Add the environment as a standalone source using the cluster name or address.
  • AlwaysOn Availability Groups
    Add the environment as a cluster source using the cluster name or address.

Windows Domain User Requirements

The source environment must have a Windows Domain user (for example, delphix_src) that the Delphix Engine can use. This is the user that you provide when adding the source environment to the Delphix Engine. The user provides remote read-only access to the Windows Registry for discovering SQL Server instances and databases. This user must meet these requirements:

  • Be a member of the Backup Operators or Administrators group on the source host
  • Be a member of the Backup Operators or Administrators group on the staging host that will be used to create staging copies of the source databases on the source host
  • Be a login with Windows Authentication to each SQL Server instance with which the Delphix Engine will communicate
    • To create a new login, access the SQL Server Management Studio and select Security > Logins
  • Have the database role db_datareader for the master database on each SQL Server instance with which the Delphix Engine will communicate
    • To edit the user properties and set this role, access the SQL Server Management Studio, select Security > Logins > delphix_src > User Mapping 
  • If the source host belongs to a cluster, the user must have these privileges on all hosts that comprise the cluster
  • If the source host belongs to a AlwaysOn Availability Groups then the user must be granted access to the following views:
    VIEW ANY DEFINITION
    VIEW SERVER STATE 

Database User Requirements

There must be a database user (for example, delphix_db) for each source database that will link to the Delphix Engine. This user must meet these requirements:

  • Be able to login with a local database account using SQL Authentication over Java database connectivity (JDBC) to the database.
  • The database account can not use Windows Authentication. Note this user will not perform any action that could affect production operations, only issuing queries for database names, database sizes, recovery mode and backup information.
  • For the master database, have the database role db_datareader
    • To set this role, access the SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings
  • For the msdb database, have the database role db_datareader for reading backup history
    • To set this role, access the SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings
  • If the Delphix Engine will initiate copy-only full backups of the database, the database user must have the database role db_backupoperator for the database
    • To set this role, access SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings
  • The database user should be able to "use" the desired database. Delphix will periodically run a query to find the size of the database ( "SELECT SUM(size) FROM sys.database_files;" ). The results of the query will be reflected on the back of the dSource card.