Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Connection to SAP HANA and exposing data in Design Studio
There are different scenarios you can use to connect Design Studio to HANA database. It primarily depends on Design Studio installation. If you are using Design Studio locally on the system, you can connect to HANA database using an ODBC connection. When Design Studio is available via BI platform, you need to create an ODBC connection in CMC and that can be used to connect to HANA.
To use ODBC connection in Design Studio, you have to create a User/System DSN.
If you are using the 64-bit version of Design Studio, navigate to the following folder on your local system: C:\Windows\System32. Open the odbcad32.exe file and open User DSN tab -> Click on Add button and select HDBODBC driver -> Finish.
When you have a 32-bit version of Design Studio, navigate to the following folder on your local system: C:\Windows\SysWOW64. Open the “odbcad32.exe” file. And navigate to User DSN tab -> Click on Add and select the HDBODBC32 driver -> Finish.
For more details, you can navigate to this link: https://blogs.sap.com/2016/03/29/connecting-hana-to-design-studio/
98 Views
