. Download the SAP HANA Client from the SAP software download center and install where the MS SQL Server instance is installed. This includes the SAP HANA ODBC driver that is needed to connect to the SAP HANA database server. Run the SAP HANA Client installation on the MS SQL Server Windows server. After the installation has finished open the ODBC Data Source Administrator on the Windows server. Open the Drivers tab and check that there is a driver installed with the name HDBODBC.
I currently connect to SAP Hana via the SAP Connector. This means having to use the ScriptBuilder QVW every time i need to query a table. This is not ideal. I understand you can connect to SAP Hana via ODBC and JDBC. There is a cost involved if wanting to go the JDBC route, so this is out of the question. Can anyone explain how to connect via ODBC. Network connectivity: HANA system is reachable from PC running MS excel. Steps: Download SAP HANA ODBC client for MS Excel. Go to SAP Software.
![Sap Hana Odbc Sap Hana Odbc](/uploads/1/2/5/6/125600927/328594252.png)
Open the System DSN tab and add a new System DSN by clicking on Add. In the new window click on HDBODBC and choose Finish. In the now opening window define a Data Source Name (that will be used later on), Description and enter your HANA Server (hostname or IP) and Port. For example “hanaserver:30015”:. If you’re connecting to a SAP HANA 1.0 MDC or SAP HANA 2.0, you need to specify the Tenant you’re connecting to, as described in KBA. Click “Settings ” and add a “Special property setting” with Property: “DATABASENAME” and the Tenant name on Value, example:. Click on Connect and enter the SAP HANA database username and password that you want to use for the connection.
![Sap hana odbc driver for power bi Sap hana odbc driver for power bi](/uploads/1/2/5/6/125600927/802973247.png)
You should receive a popup window with the message “Connect successful!”. Now open Microsoft SQL Server Management Studio. In the next step you need to create a linked server connection and authentication with the user you used in step 8. You can do this by following the steps of this msdn help page (Create Linked Servers (SQL Server Database Engine));. Or you can run this 2 statements.