Connecting to SAP HANA in Data Virtualization

Before you begin

You must locate the JAR file from the JDBC driver that you downloaded when you configured the connection to the SAP HANA database. For more information, see the SAP HANA product documentation.

Procedure

1. On the navigation menu, click Data > Data virtualization. The service menu opens to the Data sources page by default.

2. Click Add connection > New connection to see a list of data sources that can be added to Data Virtualization.

3. Select the SAP HANA data source connection.

4. Specify the following information:

   • The name of the database
   • The hostname or IP address and port number of the database, which is required to access the connection.

5. Select a JDBC Driver JAR from the drop-down list.

   To upload a JDBC Driver JAR file, follow these steps.

   1. Enter SAP HANA in the Connection type field.

   2. Upload the ngdbc.jar file.

   3. For the driver class name, enter com.sap.db.jdbc.DriverSapDB.

   4. For the JDBC URL prefix, enter jdbc:sap.

   5. Click Upload.

6. Specify the username and password that allow access to the data source.

7. If you want to use SSL to connect to the database, copy the content of the SSL certificate and paste it in the corresponding box.

   Some data sources can use an SSL certificate that is stored as a secret. To use this option, an administrator must enable the vaults feature. For more information, see Enabling vaults for the Cloud Pak for Data web client. Additionally, if you are using secrets from an external vault, you must have the appropriate permissions to connect to external vaults or an administrator must share the appropriate secrets with you. For more information, see Managing secrets and vaults.

8. Click Create to add the connection to the data source environment.

9. Optional: Select a remote connector to associate to the data source and click Add to connector.

   For more information, see Installing remote connectors.

Results