Connecting to SAP HANA in Data Virtualization

You must configure SAP HANA as a data source before you can create a connection to it 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.

Important: The ability to upload a JDBC JAR file is disabled by default in Data Virtualization. An administrator must enable upload JDBC drivers for users. For more information, see Enabling users to upload JDBC drivers.

Procedure

To connect to SAP HANA in Data Virtualization, follow these steps.

  1. On the navigation menu, click Data > Data virtualization. The Data sources page appears.

  2. Click Add connection > New connection to view a list of data sources.

  3. Select the SAP HANA data source connection.

  4. Specify the following information:

    • Name of the database
    • Hostname or IP address and port number of the database

  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. 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 Accessing data sources by using remote connectors in Data Virtualization.

Results

You can now use your SAP HANA database as a data source in Data Virtualization.