Discovering SAP HANA installations

Discovery is a process that allows the SAP HANA connector to gather information about the SAP HANA installation details in an environment. The database’s discovery typically occurs as part of the initial environment setup process. 

During the discovery process, the SAP HANA connector identifies the installations from the running SAP HANA instances on the host. 

A staging environment must be added to the Delphix Continuous Data Engine before linking. Similarly, a compatible target environment, with equivalent SAP HANA binaries, must be added to the Delphix Continuous Data Engine to provide a provisioning location. 

Installation of the SAP HANA connector, uploaded via a plugin, is required before the discovery of an SAP HANA environment can occur. 

Once an environment is added to the Delphix Continuous Data Engine, environment discovery takes place automatically. Environment discovery is a process that enables the SAP HANA connector to determine SAP HANA installation details on a host. The same Environment Discovery process can be repeated during an Environment Refresh to detect new SAP HANA installations. 

Prerequisites

Please note that the SAP connector must be installed before adding an environment and discovering its installations.  

Adding an environment 

This topic describes adding an SAP HANA staging and target environment. On completion, the SAP HANA installation will be automatically discovered.

Prerequisites 

To set up an SAP HANA staging environment, ensure all the essential requirements, as described in Requirements and Prerequisites are met. 

Procedure 

Perform the following steps to add an environment to the Delphix Continuous Data Engine: 

  1. Login to the Delphix Management application. 

  2. Navigate to the Manage > Environments page. 

  3. Click the Actions ... menu and select Add Environment. 

  4. From the Add Environment dialog window, select Unix/Linux. 

  5. Select Standalone Host. 

  6. Click Next. 

  7. Provide the name of the environment. 

  8. Provide the Host IP address or host FQDN. 

  9. Provide the SSH port. The default value is 22. 

  10. Provide an Environment Username for the environment.  

  11. Choose the Login Type that fits your setup.  

    1. Username and Password – provide the environment username and password 

    2. Username and Public Key – provide the environment username  

    3. Password Vault – select from an existing Enterprise Password Vault 

Using Public Key Authentication
If you want to use public-key authentication for logging into your Unix-based environment, you have two options:  

  1. For Password, enter the password associated with the user in step 11. 

  2. If you want to use Public Key Encryption for logging into your environment: 

    1. Select Public Key for the Login Type 

    2. Click View Public Key 

    3. Copy the public key that is displayed, and append it to the end of your ~/.ssh/authorized_keys file. If this file does not exist, it must be created. 

Note: The addition of the public key is a one-time requirement per user and per environment. Additionally, you have the option to add public key authentication to an environment user's profile via CLI (for details, refer to the CLI Cookbook: Setting up SSH key authentication for UNIX environment users topic).

  1. For Password Login, click Verify Credentials to test the username and password. 

  2. Enter Toolkit Path (ensure that the toolkit path does not have any spaces). 

  3. To provide your own Oracle Java Development Kit, select the Provide my own JDK checkbox and click Next. 

  4. On the Java Development Kit page, provide an absolute path to your Oracle JDK and click Next.  

  5. Click Submit. 

After successfully adding and discovering the environment, you should be able to view the newly added environment listed under the Environments tab. In case it does not appear, click the refresh icon in your browser. 

Perform the following steps to access environment information. 

  1. Navigate to Manage > Environments. 

  1. Select the environment name. 

  1. Review the Details and Databases tabs. 

In case it does not appear, click the refresh icon in your browse:discovering SAP Hana installations

Once you have successfully added a staging environment, you can configure source database links by adding a Source Configuration to the discovered Installation. This is typically performed during the following linking data source process. Target environments do not have source database links. 

Installation discovery

Unlike Oracle or Microsoft SQL Server connectors, installations are managed automatically with SAP HANA. If you have added a new SAP HANA Installation to your staging or target environment and want it to be reflected in the Delphix Continuous Data Engine UI, you must refresh the environment. For more information, refer to the "Environment Refresh" section on the Managing environments and environmentspage.