

Provisioning

This topic describes the basic concepts involved with provisioning VDBs from SAPIQ dSources using SAPIQ plugin.

A dSource is a virtualized representation of a physical or logical source database. As a virtual representation, it cannot be accessed or manipulated using database tools. Instead, you must create a virtual database (VDB) from a dSource snapshot. A VDB is an independent, writable copy of a dSource snapshot. You can also create VDBs from other VDBs. Once you have provisioned a VDB to a target environment, you can also implement snapshot and retention policies for the VDB, which will determine how frequently Delphix Engine will take a database snapshot and how long the snapshots will be retained for recovery and provisioning purposes.

Snapshots accumulate over time. To view a snapshot:

1. From the Datasets panel, click the group containing the dSource.
2. Select dSource.
3. Click the TimeFlow tab.

The TimeFlow appears as a list of dates, each of which expands to show snapshots from that date. Times, when the VDB has been refreshed, are marked by a blue line between dates.

On the TimeFlow, you can also filter by type of snapshot. To do so, click the filter button, which is shaped like an eye.

You can scroll through these lists to select the one you want, or you can enter a date and time to search for a specific snapshot.

Once you have provisioned a VDB, you can also take snapshots of it. As with the dSource snapshots, you can find these when you select the VDB in the Datasets panel. You can then provision additional VDBs from these VDB snapshots.

Dependencies

If there are dependencies on the snapshot, you will not be able to delete the snapshot free space; the dependencies rely on the data associated with the snapshot.

Provisioning VDB

This topic describes how to provision a virtual database (VDB) from a SAPIQ dSource.

Prerequisites

• Install delphix engine 6.0.12.x and above.
• Install SAPIQ binaries on staging host.
• Execute Discovery on staging host.
• Create dSource on staging host.
• Add target environment to delphix engine.

Create VDB

Steps:

1. Login to the Delphix Management application.
2. Click Manage.
3. Select Datasets.
4. Select a dSource.
5. Select a snapshot from which you want to provision.

6. Click Provision VDB icon to open Provision VDB wizard.

   

7. Select a target environment from the left pane.

8. Select an Installation to use from the dropdown list of available SAPIQ binaries on that environment.

9. Select the Environment User.

   

10. Enter the SAPIQ-specific parameters for your VDB configuration.

    

11. Select a Target Group for the VDB.

    

12. Select a Snapshot Policy for the VDB.

    

13. Click Next.

14. Select the masking option if you wish to mask this VDB.

    

15. Click Next.

16. Specify any desired hook operations.

    

17. Click Next.

18. Review the Provisioning Configuration and Data Management information.

    

19. Click Submit.

    When provisioning starts, you can review the progress of the job in the Databases panel, or in the Job History panel of the Dashboard.

    

    When provisioning is complete, the VDB will be included in the group you designated and listed in the Databases panel. If you select the VDB in the Databases panel and click the Open icon, you can view its card, which contains information about the database and its Data Management settings.

VDB Provision Parameters

Parameter	Description
vDB Name	Virtual Database Name to be created on target host.
SAP IQ vDB DB Port	SAPIQ DB Port available on target host.
SAP IQ Binaries Path	Location of the SAP IQ directory on target host.
Mount Location on Target Host	Mount Location for hosting SAP IQ target virtual DB files.
vDB DB Username	DB Username for SAP IQ Target database.
vDB Database Password	DB Password for SAP IQ Target database.