SQL Server Video
110 page views
6372 video views
2024, May 17, Friday

How to: Connect to SAP Hana Database in SQL Server

How to: Connect the SAP Hana Database Directly Associated to SQL Server Using Linked Server Functionality

We will know the techniques

:How to install ODBC driver from SAP HANA (ODBC, HANA CLIENT);
Download at:

🔹https://tools.hana.ondemand.com/#hanatools
🔹Configure ODBC Data Source Administrator (ODBC. System DSN); Create Linked Server in
graphical mode (SSMS, LINKED SERVER, PROVIDERS); View SAP Hana database tables (SAP HANA DATABASE EXPLORER, OPEN DATA); Query SAP Hana database in SQL Server (SELECT, OPENQUERY); Delete Linked Server using SQL code (sp_dropserver, droplogins); Create Linked Server using SQL code (sp_addlinkedserver, 🔹
🔹
🔹
🔹
🔹 PROVIDER);
🔹Add user and password to access the Linked Server (sp_addlinkedsrvlogin);
🔹Create view with query statement of SAP Hana data (CREATE VIEW).