Adding SAP HANA on SAP Cloud Platform support (Data Virtualization)

You must configure SAP HANA on SAP Cloud Platform before you can use it as a data source in Data Virtualization.

To add the SAP HANA on SAP Cloud Platform data source:

1. Go to SAP Development Tools to install the correct version of the SDK on to the on-premises machine:
   • For Cloud Foundry environments, see SAP Cloud SDK.
   • For Neo environments, you can find SDK packages in the SAP Cloud Platform Neo Environment SDK section.
2. To connect to a SAP HANA instance on SAP Cloud Platform from the on-premises machine, create a secure SSH tunnel to the instance:
   • For Cloud Foundry environments, use the Cloud Foundry CLI from the SDK package you installed in step 1. Log in to Cloud Foundry and create an SSH tunnel by running the following command:

     cf ssh -L localhost:30015:hostname:port database_name -N

     Replace the hostname and port variables with the hostname and port of the SAP HANA database.

     The command creates an encrypted tunnel from port 30015 on the on-premises machine to your SAP HANA instance on the SAP Cloud Platform database.

   • For Neo environments, use the Neo SDK package you installed in step 1 and run the following command to create an SSH tunnel:

     neo open-db-tunnel -a SAP_account_technical_name -h -u -i SAP_ID_or_alias 

   The following example uses a trial SAP Cloud Platform account. The example uses hanatrial.ondemand.com as the public endpoint and "hxe" as the database service ID.

   neo.sh open-db-tunnel -h hanatrial.ondemand.com -a p2001966692trial -u [email protected] -i hxe

   The example command creates a tunnel on localhost:30015.

3. 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.
4. Connect the SAP HANA instance on SAP Cloud Platform to Cloud Pak for Data via the open tunnel you created on the on-premises machine. On the Connections page:
   1. Select SAP HANA as the Connection type.
   2. Enter SAP HANA as the Connection name.
   3. Enter the JDBC URL for the tunnel you created on the on-premises machine. Enter the username and password of the SAP HANA instance on SAP Cloud Platform.
      The JDBC URL must have the following format:

      jdbc:sap://hostname:port[/?<options>]

      Replace the hostname and port variables with the hostname and port 30015 of the on-premises machine.

5. Click Create to add SAP HANA SAP Cloud Platform as a data source connected to Data Virtualization.