SAP Hana Connection

Sap Hana is currently is Beta.

This is a step-by-step tutorial for creating our SAP Hana connection.

Prerequisites

Create Credential for Authenticated Access to Source System

Connection Procedure

SAP Hana can be accessed in two different ways:

• Credentials
• SSH Tunnel

To create a connection with Credentials, complete these steps:

1. Fill in the Connection's Name and Host.
2. Input Port and Database.
3. Enter User Name and Password.
4. Use the Test Connection function to see if your connection is up to the task. If the connection succeeded, you can now use this connection in Rivery.
   

To create a connection with an SSH Tunnel:

Configure your SSH Tunnel server in your network to use SSH Tunneling via Rivery. This server will be able to connect to your database server via the internal IP or address, and will accept SSH connections from Rivery IPs.

After you've set up SSH tunneling, go through the following steps:

1. Click on SSH Tunnel and check Use SSh Tunnel at the bottom of the window.
   

2. Input Hostname and Port.

3. Enter User Name and Password.
   

4. There are two SSH Tunnel options:
   a. Upload PEM file
   b. Auto Generated

   a. To upload a PEM file, complete the next steps:

   1. Click on **Choose File **
   2. Input SSH KEY File Password

   

   b. Follow the steps below for Auto Generated:

   1. Click on **Select key pair **
   2. Select Create new key pair
      

5. Use the Test Connection function to see if your connection is up to the task. If the connection succeeded, you can now use this connection in Rivery.