SAP HANA JDBC Data Source

Table of Contents

JDBC Driver Installation
Standard Data Source Connection
Generic JDBC Connection

JDBC Driver Installation

iDashboards can connect to a SAP HANA database using a JDBC (Java Database Connectivity) driver. Before you can connect, the driver must first be installed on your iDashboards server.

1. Check to see if you already have the driver installed. To do so, log on to the iDashboards Admin Application and click Data Sources. Underneath your list of data sources, you will see a list of installed JDBC Driver Classes.
   
   The driver class for the SAP HANA JDBC driver is com.sap.db.jdbc.Driver. Note the absence of a particular driver class from this list does not necessarily mean that it is not installed. To install the driver, proceed to the next step. If you already have the driver installed, you can skip the remainder of this section.
2. Copy the JDBC version of the driver to your iDashboards server from the following location:
   Windows:C:\Program Files\sap\hdbclient\
   Linux: /usr/sap/hdbclient/
3. Copy the ngdbc.jar file to your <ivizgroup home>/drivers Note: For iDashboards production installations deployed using the automated Windows installer, the default <ivizgroup home> directory is C:\Program Files (x86)\iDashboards_SRV
4. Restart your iDashboards Server service to complete the driver installation.

Standard Data Source Connection

Once the JDBC driver is properly installed, you can make the connection in iDashboards. Note that the iDashboards server must have access to your database server, and you will need a username and password with at least SELECT privileges to your desired database.

1. Log on to the iDashboards Admin Application and click Data Sources
2. In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC, and then Add Data Source
   
   
3. You will be presented with the Add Data Source screen. The following fields are required:
   
   Data Source Name: This can be anything you like and is for reference only
   UserID: A database user with at least SELECT privileges to your database
   Password/Confirm Password: The user’s password
   Database URL: The host name or IP address of the server with your database server instance
   JDBC Driver Class: Your database server's port
   
   
4. Click Save. If all of the information is correct and there are no connectivity issues, your data source is now available

Generic JDBC Connection

Alternatively, you can use the Generic JDBC option to construct a custom connection string to your database. This can be useful if there are special parameters that need to be added to your connection string that would otherwise not be possible with the standard Add Data Source options.

1. Log on to the iDashboards Admin Application and click Data Sources
2. In the (new) row below your existing data sources, click the (Select Type) dropdown, select Generic JDBC
   
   
3. You will be presented with the Add Data Source screen. The following fields are required:
   Data Source Name: This can be anything you like and is for reference only
   Database URL: The connection string to your database which should begin with

   jdbc:sap://

   
   Example Connection String:

   jdbc:sap://ServerName:30015/?autocommit=false

   
   JDBC Driver Class:

   com.sap.db.jdbc.Driver

   
   The UserID and Password fields are required only if you do not include these values in your connection string. All other fields are optional. Please refer to the iDashboards Admin Manual for details on all of the fields.
   Port: The port is identified by a 3 then the instance number "00" followed by the number 15. Ending as 30015.
4. Click Save. If all of the information is correct and there are no connectivity issues, your data source is now available

• SAP Reference: https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.00/en-US/ff15928cf5594d78b841fbbe649f04b4.html

 Applies To

• iDashboards Enterprise