Connecting to SAP HANA Data Source Using ODBC DSN

This article provides a step-by-step guide on how to connect to an SAP HANA data source using ODBC DSN.

Prerequisites

1. Download and install the SQL ODBC driver from the following link:
   https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16
   
   
2. Download and install the hanaclient zip file from the following link:
   https://tools.eu1.hana.ondemand.com/#hanatools
   
   

Installation Steps

1. Extract the contents of the hanaclient zip file. Open the hanaclient-2.21.26-windows-x64 folder and double-click on hdpsetup to install the hanaclient locally.
   
   
2. After installing hanaclient, open the ODBC driver, navigate to the System DSN tab, and click the Add button. The SAP HANA driver, HDBODBC, will be listed.
   
   
   
   
   

Accessing SAP HANA Cloud

1. To access the SAP HANA Cloud trial page, use the following link and create an SAP account with your email:
   https://www.sap.com/india/products/technology-platform/hana/trial.html
   
   
2. After creating your account, access your trial account using the link below:
   https://account.hanatrial.ondemand.com/trial/#/home/trial
   
   
3. On the trial account page, click on the trial account.
   
   
4. In the left pane, select the Spaces option, choose the default dev space, and click on SAP HANA Cloud.
   
   
   
   
   
   
   
   
   
   
   
5. Click on ‘Next step’, enter the instance name and password, then click ‘Next step’ again.
   
   
   
   
   
   
   
   
6. On the next tab, choose ‘Allow All IP Addresses’ and enable the cloud connector. Click ‘Next step’.
   
   
7. Do not check ‘Data Lake’ on the subsequent tab. Click ‘Review and Create’. Then click ‘Create Instance’.
   
   
   
   
   
8. After creating the instance, click Actions, select Copy SQL Endpoint, and copy the host.
   
   
   
   
   

Finalizing ODBC Configuration

1. Open the ODBC driver, navigate to the System DSN tab, and click the Add button. Select the SAP HANA driver and click ‘Finish’. Enter the Data Source Name and Host, then click ‘OK’.
   
   
   
   
   
   
   
   
2. In Bold BI, create an ODBC data source. On the connection page, enter the Data Source Name, select DSN for ODBC Connection Type, choose the created DSN, enter your username (DBADMIN), instance password, and database name (SAPHANA). Click ‘Connect’.You can view the SAP HANA cloud database details using the Database Explorer.
   
   
   
   
   

Additional Notes

To start the server, go to Manage SAP HANA Cloud and click the start option to start the SAP HANA server.

We have attached the video reference in a zip file for connecting to an SAP HANA data source using ODBC DSN.