Linking data sources with SQL server

Linking a dSource will ingest data from the source and create a dSource object on the engine. The dSource is an object that the Continuous Data Engine uses to create and update virtual copies of your database. As a virtualized representation of your source data, it cannot be managed, manipulated, or examined by database tools. 

For an overview of all dSource related actions, please Managing Data Sources and Syncing Data.

When linking a dSource from a SQL Server source database, Delphix offers several different methods of capturing backup information:

• SQL Server Managed Backups, where the SQL Server source database schedules and initiates backups and the Delphix Engine captures them

  • Full backups

  • Full or differential backups

  • Transaction log backups (with LogSync disabled)

  • Transaction log backups (with LogSync enabled)

• Delphix Managed Backups, where the Delphix Engine schedules and initiates the backups from the source database, and captures them.

Source databases cannot be in Read-Only mode at the time that a backup is taken. While the snapshot will succeed, attempts to provision VDBs from those snapshots may fail with an error during the provision process.

Temporarily setting the database to read-write mode, and taking a new backup and snapshot while the database is in in this state, will allow VDBs to be provisioned successfully.

Procedure

1. Login to the Delphix Management application.

2. Navigate to Manage > Datasets.

3. Click the plus icon and select Add dSource.

4. In the Add dSource wizard, select the source database with the correct environment user-specified.

5. Select user type for source database authentication and enter the login credentials. Enter username and password for Database user or Domain (Windows) user. For Environment User, select a source environment user from the dropdown list and click Next.

6. Enter a name and select a group for your dSource.
   Adding a dSource to a dataset group lets you set Delphix Domain user permissions for that database and its objects, such as snapshots. See the topics under Users and Groups for more information.

7. Select the Data Management settings needed. For more information, Data Management Settings for SQL Server Data Sources.

8. Select the Staging environment and SQL Instance that will be used to manage the staging database used for validated sync of the dSource.

9. Select any policies for the new dSource.

10. Enter any scripts that should be run on the Hooks page.

11. Review the dSource Configuration and Data Management information, and then click Submit.