This topic describes the process of linking to a source database and creating a dSource.
Prerequisites
Procedure
- Login to the Delphix Admin application using Delphix Admin credentials.
- Click Manage.
- Select Databases.
- Select Add dSource.
Alternatively, on the Environment Management screen, you can click Link next to a database name to start the dSource creation process. In the Add dSource wizard, select the source database.
- Enter your login credentials for the source database and click Verify Credentials. If you are linking a mounted standby, click Advanced and enter non-SYS login credentials as well. Click Next.
See the topics under Linking Oracle Physical Standby Databases for more information about how the Delphix Engine uses non-SYS login credentials. - Select a Database Group for the dSource, and then click Next.
Adding a dSource to a database group lets you set Delphix Domain user permissions for that database and its objects, such as snapshots. See the topics under Users, Permissions, and Policies for more information. - Select an Initial Load option.
By default, the initial load takes place upon completion of the linking process. Alternatively, you can set the initial load to take place according to the SnapSync policy, for example if you want the initial load to take place when the source database is not in use, or after a set of operations have taken place. - Select whether the data in the database is Masked.
This setting is a flag to the Delphix Engine that the database data is in a masked state. Selecting this option will not mask the data. - Select a SnapSync policy.
See Advanced Data Management Settings for Oracle dSources for more information. - Click Advanced to edit LogSync, Validated Sync, and Retention policies.
See Advanced Data Management Settings for Oracle dSources for more information. - Click Next.
- Review the dSource Configuration and Data Management information, and then click Finish.
The Delphix Engine will initiate two jobs, DB_Link and DB_Sync, to create the dSource. You can monitor these jobs by clicking Active Jobs in the top menu bar, or by selecting System > Event Viewer. When the jobs have successfully completed, the database icon will change to a dSource icon on the Environments > Databases screen, and the dSource will be added to the list of My Databases under its assigned group.