This topic describes basic concepts behind the creation of a dSource for a HANA database.
The steps required to link a HANA database are dependent on whether a customer chooses:
- Delphix Initiated Backups. Backups on the source tenant database will be created and transferred to the Delphix Engine during the dSource linking process.
- External Backups. The customer will provide a “Backup Path” containing FULL and Incremental backups. These files will be copied to the Delphix Engine during the dSource linking process. In this scenario the Delphix Engine will not require any credentials of source database; operating system credentials will be required to effect file transfer via rsync.
- Backup files must meet the required file naming convention, prior to linking using the External Backup option. The naming convention is:
The UTC_END_TIME of any backup is available by querying the catalog of a tenant database. For example the following SQL query will return all possible values for the tenant:
select ENTRY_ID,ENTRY_TYPE_NAME,BACKUP_ID,UTC_END_TIME from M_BACKUP_CATALOG order by ENTRY_ID desc;
- Optionally, users can choose to manually adjust file names or automate this using scripting. The plugin includes a script designed to work remotely in source environments, see HANA 2.0 Plugin Tools.
- Where a dSource will be linked using Delphix Initiated Backups, access to the system database user on the source must be available, the HANA system must be running and the source tenant must be online.
- Ensure that the source host and database both meet the requirements set out in Requirements for HANA Source Hosts and Database.
- Login to the Delphix Management application.
- Select Manage > Environments. Then select the Datasets tab.
- Create a source configuration on which to build the dSource. You can do this by clicking on the + symbol. The source configuration can have any name.
- In the Add dSource wizard, select the required source configuration.
- After selecting the source, below are the details required to create the dsource for the two approaches:
Delphix Initiated Backups:
Select the checkbox Allow Delphix to initiate backup operations on source database.
The following parameters are required to create the dsource:
- SAP HANA Source Tenant Database Name
- Source SystemDB User Name
- Source SystemDB Password
- Source Tenant Database User Name
- Source Tenant Database Password
Enter the backup location. This represents the path to the location of the customer provided backup files. The path entered should exclude the final directory in the hierarchy which must be “BACKUP”.
- For example, external backups have been generated and placed in the following location:
In this example, the backup path entered in the User Interface should be
/usr/sap/HDB/HDB00/SAP_BACKUPImportant: file transfer during dSource linking relies on rsync against all directories at the same level as the “BACKUP” directory. To prevent the transfer of unneeded files (which extends the duration of linking and may cause recovery failure during provision) avoid creating directories at the same level in the directory hierarchy as the “BACKUP” directory itself. If this situation can not be avoided, use the exclude path option during dSource creation.
- 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.
- Configure the SnapSync and Retention Policy. The SnapSync policy can be set to ‘None’ for customers who wish not to run a scheduled SnapSync job.
- Optionally, users can provide the bash script as a plugin defined hook. Both Pre-Snapshot and Post-SnapShot hooks can be used Select Next.
- At the end of the workflow, review the dSource Configuration in the Summary pane as shown below:
Once the dSource linking job is submitted it is possible to monitor progress by selecting “Active Jobs” in the top menu bar. On successful completion of the new dSource will be visible in the list of Datasets under its assigned group.