This topic describes the process of linking to a source database and creating a dSource.

Prerequisites

Procedure

  1. Login to the Delphix Engine using the Delphix Admin credentials.
  2. Click Manage.
  3. Select Datasets.
  4. Click the plus icon.
  5. Select Add dSource.
    Alternatively, on the Environment Management screen, you can click Link next to a database name to start the dSource creation process.
  6. In the Add dSource wizard, select the source database.

    Changing the Environment User

    If you need to change or add an environment user for the source database, see Managing Oracle Environment Users.

  7. 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 platform uses non-SYS login credentials.
  8. In Add dSource/Add Environment wizard, you can set the Toolkit Path to /tmp (or any unused directory).
  9. Select a Database Group for the dSource.
  10. 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.
  11. 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.
  12. Select a SnapSync policy.
    For more information, see Advanced Data Management Settings for Oracle dSources.
  13. Click Advanced to edit LogSync, Validated Sync, and Retention policies.
    For more information, see Advanced Data Management Settings for Oracle dSources.
  14. Click Next.
  15. 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 Datasets under its assigned group.

After you have created a dSource, you can view information about it on the dSource's Configuration tab, where you can also modify its policies and permissions. The Configuration tab provides information such as the Source Database and Data Management configuration. For more information, see Advanced Data Management Settings for Oracle dSources.

Related Links