Skip to main content
Delphix

Installation and Configuration of the SAP HANA Extended Connector for Masking (KBA7133)

 

KBA

KBA# 7133

Applicable Delphix Versions

Click here to view the versions of the Delphix Engine to which this article applies
Click here to view the versions of the Delphix Engine to which this article applies
Major Release All Sub Releases
6.0 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0

How to Install Extended Connector for SAP HANA

To facilitate the ability to connect and mask a wide range of database types the Delphix Masking Product incorporates third party JDBC drivers. This feature is known as Extended Connectors. In the context of Extended Connectors, licensing and support for JDBC drivers remains the responsibility of the relevant third party providers.

The latest SAP HANA Driver is available on Maven from: https://repo1.maven.org/maven2/com/s...db/jdbc/ngdbc/
Note these JDBC drivers are provided by SAP to Maven.

1. Download the desired driver release. The file you need will have the format "ngdbc-<version>.jar", for example:

ngdbc-2.7.9.jar 

2. Determine the Class Name for the driver, substituting a slash with a period and removing the trailing ".class": com.sap.db.jdbc.Driver

$ jar tvf ngdbc-2.7.9.jar |grep Driver.class
  2689 Fri Dec 11 20:58:08 AEDT 2020 META-INF/versions/9/com/sap/db/jdbc/Driver.class
  2934 Fri Dec 11 20:57:54 AEDT 2020 com/sap/db/jdbc/Driver.class

The class name is unlikely to change, however for transparency the method to make this determination is provided above.

3. Prior to uploading the jar, the file must be zipped. Use the following approach:

$ zip ngdbc.zip ngdbc-2.7.9.jar
  adding: ngdbc-2.7.9.jar (deflated 6%)
$

4. Login to the Delphix Masking Engine and navigate to the JDBC pane:

1-select-jdbc.png

5. In the top right hand corner, select "+ Add Driver"; populate the form; select and upload the zipped driver; save the form:

2-Add-driver.png

6. Navigate to the "Environments" Tab. Select the Environment.

7. Select the "Connector" Tab and then click on "+ Create Connection":

3-Create-connector.png

8. Complete the "Create Connection" form. The customer should at a minimum know:

- The database name to connect to
- The IP address or fully qualified domain name
- The login ID and password
- Optionally the Schema Name

The customer may not know which port to connect to on the SAP HANA database. This can be discovered as follows:

(i) We know the database name is "PRD", so lets determine the Instance of that database in case it is non-zero. In the following text we see HDB00 indicates an instance number of zero ("00").

$ ps -ef |grep sapstartsrv |grep PRD
prdadm    1774     1  0 Mar08 ?        00:00:00 /usr/sap/PRD/HDB00/exe/sapstartsrv pf=/usr/sap/PRD/SYS/profile/PRD_HDB00_hana -D -u prdadm

(ii) Connect using hdbsql or hdbuserstore. In the example we have connected to the database host using SSH, hence the use of localhost.  The command options to be used are listed below:

-n <hostname>
-u <system user or user with similar privileges>
-d <database/tenant name>
-i <instance number>

hdbsql -n localhost -u system -d PRD -i 0

(iii) The JDBC driver should connect to the Master Indexserver. To determine the port associated with the Master Indexserver, run the following SQL:

hdbsql PRD=> SELECT sql_port FROM m_services WHERE service_name='indexserver' AND coordinator_type='MASTER';
SQL_PORT
30015

Note, in the following screenshot the IP address has been obfuscated: 

4-Configure.png

The following link from the SAP HANA documentation provides the required JDBC string format. In release 6.0.6.7 and later additional, optional JDBC properties may be included in the "Custom Properties File":

https://help.sap.com/viewer/1efad1691c1f496b8b580064a6536c2d/Cloud/en-US/e0d189d8e28b40099062a138ab5b7ae3.html

The following link provides details relating to JDBC connection properties for the SAP HANA driver:

https://help.sap.com/viewer/1efad169...94f4cf75e.html

Related Articles

The following articles may provide more information or related information to this article: