Connecting to SAP HANA in Data Virtualization

Last updated: Mar 17, 2025
Adding a connection to a SAP HANA data source 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.
Note: SAP HANA connections in Data Virtualization do not support columns with the ST_GEOMETRY data type. Tables that have columns with this data type are not virtualized properly. You must edit the column data type before you visualize the tables.

Procedure

To connect to SAP HANA in Data Virtualization:

  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.

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

Results

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