![SAP HANA BI Development Tutorial](/sap_hana_bi_development/images/sap-hana-bi-development-mini-logo.jpg)
- SAP HANA BI Development Tutorial
- Home
- Introduction
- Reporting and Dashboard Tools
- Different BO Tools Connection to HANA
- Creating a Relational Connection
- Creating an OLAP Connection
- HANA Modeling Views
- Input Parameters in HANA
- Using Attribute View
- Using Analytic View
- Using Calculation View
- Using Tables in HANA DB
- Connecting Webi to HANA
- Universe Development
- User Prompts and Filter in IDT
- Webi Report Development
- Lumira Connection to HANA
- Dashboard Development in Lumira
- Dashboard Designer Connection to HANA
- Dashboard Development in DD
- Connecting Crystal to HANA Views
- Crystal Report Development on HANA
- BW on HANA Connection
- Design Studio Connection with HANA
- Development in Design Studio
- Publishing BI Reports on HANA
- Benefits of Using HANA
- Connecting HANA with Other BI Tools
- Interview Questions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Design Studio Connection with HANA
Using SAP Design Studio, you can create new Analysis applications. SAP Design Studio provides a list of predefined template suitable to open in the web browser.
![Web Browser](/sap_hana_bi_development/images/web_browser.jpg)
You can create an analysis application using different data sources - SAP BW or SAP HANA. To connect to SAP HANA, use the existing backend connections. Navigate to Tool → Preferences.
![Analysis Application](/sap_hana_bi_development/images/analysis_application.jpg)
In the Preferences window, navigate to Application Design tab → Backend Connections.
![Backend Connections](/sap_hana_bi_development/images/backend_connections.jpg)
How to Create a New Connection?
To create a new connection to SAP HANA using HDB ODBC drivers, click the icon to add a connection.
![Create New Connection](/sap_hana_bi_development/images/create_new_connection.jpg)
In the ODBC Data Source Administrator, go to System DSN → click Add.
![System DSN](/sap_hana_bi_development/images/system_dsn.jpg)
In a new window, search for the HDB ODBC database drivers. These drivers get installed when you install SAP HANA client. Click the Finish button.
![SAP Client](/sap_hana_bi_development/images/sap_client.jpg)
In the new window, enter the following details of the HANA system.
- HANA Host name
- Port Number/Instance Number (3xx15, xx-instance number)
- User name and Password for authentication and click OK
![HANA Host Name](/sap_hana_bi_development/images/hana_host_name.jpg)
To perform the connection check, click the Connect button → Connection Successful. To see the new connection, click the Reload connection. To use the connection, you may need to reopen the Design Studio.
![Design Studio](/sap_hana_bi_development/images/design_studio.jpg)