

Overview

The Delphix Select Connector for SAPIQ plugin is developed to virtualize SAPIQ data source leveraging the built-in Backup and Restore procedures.

SAP IQ is a high-performance decision-support server designed specifically for mission-critical business intelligence, analytics, and data warehousing. Component Integration Services within SAP IQ provide direct access to relational and non-relational databases on mainframe, UNIX, or Windows servers.

Note: SAP IQ is formerly known as SAP Sybase IQ or Sybase IQ; IQ for Intelligent Query.

The SAPIQ plugin addresses the following use case:

• Ingest SAPIQ source databases which are backed-up using SAPIQ built-in backup mechanism.
• The Staging host will read the backup files made available on the staging host and recover them through a Staging Database which will be set up on Delphix NFS storage.
• Data Ingestion to Delphix Engine will always start with a full DB backup.
• Once recovery is complete, the backup data is incorporated into the Delphix Staging dSource as a new snapshot and is available for use to provision a new virtual database.

Architecture

Support Matrix

SAPIQ Instance / OS Support Matrix

Supported OS Version	SAPIQ 16.0	SAPIQ 16.1
RHEL 7.0
RHEL 7.4
RHEL 7.9
Windows x.x

Engine Compatibility Matrix

Delphix Engine Versions	SAPIQ 1.4.0
>6.0.12.0

SAPIQ Version Compatibility

• SAPIQ version can be same or higher than source host SAPIQ version in staging / target environment.
• For example, we can ingest from SAPIQ 16.0 backup on staging host with SAPIQ 16.1 binaries installed.
• However as best practices, it is recommended to keep a similar SAPIQ version in all environments (source, staging and target).

Prerequisites

Source Requirements

Database instance

• Database backup files from source host to staging host.
• Latest backup.syb log file from the source host which is only required to read Source DB backup information.

Staging Host Requirements

O/S user with following privileges

• Staging host should have similar SAPIQ version as the source database.
• Create OS user delphix which will be the owner for SAPIQ binaries.
• Empty folder on host to hold delphix toolkit [ approximate 2GB free space ]
• Empty folder on host to mount nfs filesystem. This is just an empty folder with no space requirements and act as base folder for nfs mount - must be owned by Delphix OS user.
• Access to source database backup file(s) from Staging host logged as delphix OS user.

• $IQDIR16 must be setup in .bash_profile and .bashrc for O/S user.
  Note: IQDIR16 identifies the location of the SAP IQ directory and is the location for other directories and files under that directory.

• Sudo privileges for mount, umount. See sample below assuming delphix is used as delphix user.

Defaults:delphix !requiretty
delphix ALL=NOPASSWD: \
/bin/mount, /bin/umount

Target Host Requirements

O/S user with following privileges

• Target host should have similar SAPIQ version as the source database.
• Create OS user delphix which will be the owner for SAPIQ binaries.
• Empty folder on host to hold delphix toolkit [ approximate 2GB free space ]
• Empty folder on host to mount nfs filesystem. This is just an empty folder with no space requirements and act as base folder for nfs mount - must be owned by Delphix OS user.

• $IQDIR16 must be setup in .bash_profile and .bashrc for O/S user.

  Note: IQDIR16 identifies the location of the SAPIQ directory and is the location for other directories and files under that directory.

• Sudo privileges for mount, umount. See sample below assuming delphix is used as delphix user.

Defaults:delphix !requiretty
delphix ALL=NOPASSWD: \
/bin/mount, /bin/umount

Limitations

• No Point in time recovery support.
• V2P not supported.
• Password Vault not supported.
• SDD not supported.