SAP HANA Connector > SAP HANA connections > Prerequisites
  

Prerequisites

Before you create an SAP HANA connection to read from or write to SAP HANA databases, ensure to complete certain prerequisites.
An SAP HANA administrator must perform the following tasks on a Windows or Linux machine where the Secure Agent is installed:
  1. 1Install the 64-bit HANA ODBC driver.
  2. 2Append an entry to the odbcinst.ini file on Linux.
  3. 3Download and configure the ngdbc.jar file.
After the administrator completes the configurations, you can set up and use an SAP HANA connection in mappings and mapping tasks.

Configure the ODBC driver on Linux

To use SAP HANA Connector on a Secure Agent machine on Linux, install the 64-bit HANA ODBC on this machine. Additionally, you need to add the HANA driver details to the odbcinst.ini file.
The odbcinst.ini file is available in Secure Agent installation directory.
Append the following HANA driver details to the odbcinst.ini file in Linux to connect to the HANA database as shown in the following example:
[HDBODBC]
Driver=/usr/sap/hdbclient/libodbcHDB.so
Description=HANA Driver
Setup=/usr/sap/hdbclient/libodbcHDB.so
CPTimeout=0
Note: In the example, the following path is the location for the driver installation:
/usr/sap/hdbclient/
The odbc.ini and odbcinst.ini files must be in the same location.

Download and configure the SAP HANA libraries

SAP HANA Connector uses JDBC to import the metadata. Hence, to read data from the SAP HANA database, download the ngdbc.jar file and configure it on the Secure Agent machine. Contact SAP Customer Support if you encounter any issues with downloading the file.
    1Go to the SAP Service Marketplace: http://service.sap.com/connectors
    Note: You need SAP credentials to access the Service Marketplace.
    2Download the ngdbc.jar file on the Linux or Windows machine where the Secure Agent runs.
    Verify that you download the most recent version of the file.
    3Copy the ngdbc.jar file to the following directory:
    C:\Program Files\Informatica Cloud Secure Agent\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\HANA
    Create the deploy_to_main\bin\rdtm-extra\HANA directory if it does not already exist.
    4Restart the Secure Agent.