Adding SAP HANA support (Data Virtualization)

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

Procedure

  1. Click Data > Data Virtualization > Data sources.
  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:
    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.