![Hana Hana](https://anibalg.files.wordpress.com/2012/08/arquitectura-del-driver-mdx-de-simba-para-sap-hana.png?w=302&h=588)
After install and be sure that I was able to add HDOBDC at ODBC Driver administration on Windows, I add a connection called HANA Database, and in Qlikview add the connection string on the script. Let me know if you succeed. This tutorial provides the Steps to Install SAP HANA Studio & HANA Client on a Windows System with helpful screen shot and How to download HANA Client, HANA Studio and SAPCAR. To Install SAP HANA Studio on a Windows System, we will first install the client which provides connectivity from the windows box to the HANA Server. Apr 11, 2017 To install the necessary drivers, just open the SAP_HANA_CLIENT directory that the extraction creates and run the hdbsetup.exe. /Karri 2 of 2 people found this helpful. How to Install HANA Client and Create ODBC Connection Determine if you have a 32-bit or 64-bit. Installing the SAP HANA client, you will need to. SAS, or STATA. If you want to use a 32-bit HANA driver (via the 32-bit client installation) on a Windows64-bit system, the 32-bit driver will not appear in the “ODBC Data Source Administrator.
Notes:
- Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016
- This feature only available in Excel for Windows if you have Office 2019 or an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.
- Before you can connect to an SAP HANA database using Power Query, you need the SAP HANA ODBC Driver on your computer. Select the driver that matches your Power Query installation (32-bit or 64-bit).
- You will need an SAP account to login to the website and download the drivers. If you are unsure, contact the SAP administrator in your organization.
![Sap Hana Odbc Driver Download Sap Hana Odbc Driver Download](https://www.ibm.com/developerworks/library/l-sap-hana-spark-controller-integration-hdp/image007.png)
Download Hana Client
To connect to an SAP HANA database:
- Click Data > New Query > From Database > From SAP HANA Database.
- In the SAP HANA Database dialog box, specify the server you want to connect to. The server name should follow the format ServerName:Port.
- Optionally, if you want to import data using native database query, click Advanced options and in the SQL Statement box enter the query.
- Click OK.
- If the SAP HANA server requires database user credentials, then in the Access an SAP HANA database dialog box, do the following:
- Click the Database tab, and enter your username and password.
- Click Connect.