

Linking

Linking a data source will create a dSource object on the engine and allow Delphix to ingest data from this source. The dSource is an object that the Delphix Virtualization Engine uses to create and update virtual copies of your database.

Prerequisites

• Install delphix engine 6.0.12.x and above.
• Install SAPIQ binaries on staging host.
• Execute Discovery on staging host.
• Create sourceConfig on staging host.

Create Sourceconfig

Every environment contains repositories and each environment may have any number of repositories associated with it. Repository represents the binaries for SAPIQ instance. Each repository can have many SourceConfig which represent SAPIQ instance. There is no sourceconfig generated automatically in SAPIQ-plugin. We need to configure SourceConfig objects through which we can create a dSource.

1. Login to the Delphix Management application.
2. Click Manage.
3. Select Environments.
4. Select the repository

5. Click on + icon ( Shown in next image )

   

6. Add required details in Add database section.

7. SAPIQ Staging Database Name: Provide SAP IQ Staging Database Name

8. SAPIQ Source Database Name: Provide SAP IQ Source Database Name - Needs exact DB name to look for backup files

9. SAP IQ Source Backup Logfile Location: Provide SAP IQ Source Backup Logfile Location

10. Click Add button

    

Create dSource

Steps:

1. Login to Delphix Management application.
2. Click Manage > Datasets
3. Select Add dSource.
4. In the Add dSource wizard, select the SAPIQ source config you just created on the staging host.
5. Enter the SAPIQ-specific parameters for your dSource configuration.
6. Click Next.
7. Enter a dSource Name.
8. Select a Database Group for the dSource.
9. Click Next.

10. Verify the Staging environment and ensure Resynchronize dSource option is selected.

11. Select a SnapSync policy.

12. Click Next.

13. Enter any custom pre or post sync logic as Pre-Sync or Post-Sync hook operations.

14. Click Next.

15. Review the dSource Configuration and Data Management information, and then click Finish.

    The Delphix Engine will initiate two jobs to create the dSource, DB_Link and DB_Sync . You can monitor these jobs by clicking Active Jobs in the top menu bar (like below screenshot).

    

    Or you can view the last running jobs by selecting System --> Events Viewer

    

    Once the jobs have completed successfully, the files 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.

    

dSource Parameters

Parameter	Description
SAP IQ Backup Path	Source DB Backup files location available on staging host.
SAP IQ Binaries Path	Location of the SAP IQ directory on staging host.
SAP IQ Staging DB Port	SAPIQ DB Port available on staging host.
Mount Path in Staging Server	Mount Location for hosting SAP IQ staging DB files.
Staging DB Username	DB Username for SAP IQ Staging database.
SAP IQ Database Password	DB Password for SAP IQ Staging database.