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

Prerequisites

Ensure that you have correctly set up the source and target environments, as described in Managing SAP ASE Environments.

Procedure

1. Login to the Delphix Management application.
2. Click Manage.
3. Select Datasets.
4. Click the Plus icon. 
   
5. Select a Add dSource.
6. Alternatively, on the Environment Management screen, you can click the Add dSource link next to a database name to start the dSource creation process.

7. In the Add dSource wizard, from the Requirements tab select Next.

   Changing the Environment User

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

8. Select a data source.

9. Enter your login credentials for the source database.
10. Click Verify Credentials.
11. Click Next.
12. 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, Permissions, and Policies for more information.
13. Click Next.
14. From the Data Management tab under the Initial Load option select and enter any additional settings needed. There are two different options for the initial load of the dSource:
    1. New Full Backup– Lets Delphix create a new full backup file and load it. Note that when Delphix creates the backup, it is dumped to Delphix storage, not the Backup Location specified in the next step. It will dump to the staging database's NFS mounted "temp" directory on the server hosting the staging ASE instance. This means that this option will work under two scenarios:
       1. If the source ASE instance resides on the same server as the staging ASE instance, the staging database's NFS mounted "temp" directory will be present for the source database to write to in response to the "DUMP DATABASE" command.
       2. If the source and staging ASE instances are configured to allow remote access to the backup servers and the dSource is linked using the "Remote Server" option as described below. Delphix will then issue the "DUMP DATABASE" command and append the "AT <staging_backup_server_name>" clause so that the dump is written to the staging backup server.
    2. Most Recent Existing Full Backup – Find the most recent existing full backup file in the Backup Location and load it. Choosing this option can delay completion of the dSource link as Delphix attempts to find and catalogue every single backup listed in the source database's backup server log file.

    3. Specific Existing Full Backup – Specify which backup files in the Backup Location you want to load. Choosing this option is much faster because Delphix will skip directly to loading the desired backup and only start to search for and catalogue backups in the background after the linking of the source database has completed.

       When using a dump taken with the deprecated compression syntax, select the Specific Existing Full Backup option for Initial Load and, for each stripe, type compress::<file name> into the text box.

15. Enter the Backup Location. This is the directory where the database backups are stored. Delphix recursively searches this location, so the database backups or transaction logs can reside in any subdirectories below the path entered. 
16. Select Staging Environment and ASE instance name.

17. Enable or disable Validated Sync Mode. Validated Sync Mode (also known as ValidatedSync) is the background process that monitors the ASE Backup Server's log file for new database or transaction log dumps. When Delphix detects a new dump is available it attempts to load it into the staging ASE database.

18. Enable or disable Use Dump History. If Dump History is enabled, Delphix uses ASE Dump History file to find information about backups being performed on source database and to find the next backup to be used for Validated Sync.

19. Enable or disable LogSync. LogSync copies the transaction logs to Delphix storage which enables provisioning VDBs from a specific point in time in rather than just a particular backup.

    LogSync support limitations

    Due to ASE CR 800569, Delphix can only support transaction logs generated in intervals greater than one minute apart in ASE versions 16.0 SP02 through ASE 16.0 SP02 PL04. This ASE bug inadvertently removed the second and millisecond precision from the dump header sequence dates preventing Delphix from knowing what order to apply the transaction logs in when there are multiple transaction logs dumped within the same minute.

20. Select Backup Location Type.

21. Click Advanced to edit Source of Production Dump, External Data Directory, Retention policies, or Dump Password.

    External Data Directory

    The External Data Directory feature is not currently used with ASE dSources and is targeted for removal in a future release of Delphix.

    Remote Server should be selected when database dumps cannot be found on the Staging Environment. This options can be used with any of the initial load selections (New Full Backup, Most Recent Existing Full Backup or Specific Existing Full Backup). If selected, fill out additional settings as needed:

    1. Enter the Remote Server Name. This is the name of the backup server used when the dump was created.
    2. Select the Remote Host and Remote User that the backup server is located on.
    3. As noted, the interfaces file on both the staging and remote environments must be modified to point at each other's backup servers.

    The Create Dump Password sets a dump password for the dSource. Select this only if the dump password option was used to create a password on the database dump or transaction log dump files. Setting this option causes Delphix to add the "WITH passwd=" clause to the "LOAD" commands.

22. Click Next.
23. Specify any Pre and Post Scripts.
24. Review the dSource Configuration and Data Management information.
25. Click Submit.

The Delphix Engine will initiate two jobs, DB_Link and DB_Sync, to create the dSource. You can monitor these jobs by clicking Actions 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 Datasets under its assigned group.

Related Links

• Managing SAP ASE Environments
• Requirements for SAP ASE Target Hosts and Databases
• Managing SAP ASE Environment Users
• Users, Permissions, and Policies
• Support for Dump History File