Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Participant
You can find information about Qlick Sense with SAP HANA Integration. For testing purpose, we will install SHINE demo content for SAP HANA and consume it into Qlick Sense


Qlik Sense is a popular data discovery and analysis tool. It provides an interactive user interface where you can use the tools for modelling and managing data, creating visualizations, layouts, and stories.


You want to know more about SAP HANA - Qlick View/Sense integration

In Part 1 - Integrate it! – Qlick View/Sense and SAP integration. Step-by-step guide

You can find information about how to Install Qlick Connectors into ERP/BW system and setup SAP Extractor connection in Qlick

In Part 2 you can find information about Qlick Sense with SAP HANA Integration.


Step 1. Download and install HANA ODBC Driver

1.Download HANA ODBC Driver and SAPCAR archiver

2. Logon to the QlickSense host

3.Upload and Extract HANA ODBC Driver to the QlickSense host

4.Install HANA ODBC Driver (GUI installer - hdbsetup.exe)


Step 2. Configuring SAP HANA ODBC Driver

The ODBC Data Source Administrator is a Windows component. Use the ODBC Data Source Administrator to create and manage ODBC data sources.

  1. Click  Start >Enter "ODBC Data Sources (64-bit)"

  1. Select System DSN tab -> Add

  2. Fill the Data source name, Description, Host, Instance number, Multitenant (checked), Tenant Database SID fields

  1. Test connection...

Fill the Login tab

N.B. By default in HDBODBC driver port is  3<instance number>13

Correct port number 3<instance number>15

The result must be:

Step 3. Data Extraction Intro

QlikSense with the SAP HANA ODBC driver provides access to the next sources on the SAP HANA side:


Source Table/Views


Analytics Views

Attribute Views

Calculation Views

Attribute Views

Attribute  Views in SAP HANA can be similar to Dimensions in SAP BW.

Analytics Views

Analytic Views in SAP HANA can be similar to InfoCubes in SAP BW.

Calculation Views

Calculation Views are used to consume Analytic, Attribute, and other Calculation Views. Calculation views can be referred to as a combination of tables, attributes views, and analytical views to deliver a complex business requirement. They offer to combine different analytical and other calculation views into one source of data for reporting.

For testing purposes, we need demo content. Install it in the next Step.

Step 4. SHINE Installation

SAP HANA Interactive Education (SHINE) brings to our HANA system demo Tables, Calculation Views, User Authentication, and Authorization and other artifacts that we will consume in QlickSense.

Install SHINE via XSA CLI.

N.B. SHINE must be installed ONLY in the DEV system.

Step 4.1. Download SHINE

Goto Downloads section in the Launchpad


Download package relevant for you version of database SPS and XS runtime and component version

Prerequisites in this pdf file.

Step 4.2. Install SHINE.

  1. Create a subfolder on HANA DB Server. For example: /distr/SHINE

  2. Upload SHINE installation media to /distr/SHINE

  3. Open CLI and login as XSA_ADMIN

   command:  xs l

  user: XSA_ADMIN

  password: <Master password>

  1. Install SHINE

command: xs install /distr/SHINE/<SHINE .ZIP file>

The result must be:

Step 4.3. Configure SHINE.

1. Check running apps

command: xs apps

The result must be:

2. Login to xsa-cockpit URL in your browser with XSA_ADMIN user credentials

 3. Create user SHINE and assign to it role SHINE_ADMIN

4.Login to shine-web URL in your browser with SHINE user credentials

 5. Generate test data

Step 4.4. Browse SHINE artifacts.

1. Open Eclipse (SAP HANA Administration console perspective) or HANA Studio.

2. Explore Schema SHINE_CORE_SCHEMA

For example Calculation Views:

For example Views:

Consume this artifact

into QlickSense in the Next Step

Links for this step:

2239095 - SAP HANA XS ADVANCED DEMO MODEL - SHINE XSA Release & Information Note

SAP HANA Interactive Education (SHINE) for SAP HANA 2.0 SPS03 for SAP HANA XS Advanced Model

openSAP Course. SHINE Reference for Native SAP HANA Application Development

Step 5. Extraction for SAP HANA view/tables

Use HANA View PO.Items (Process Order items) for extraction.

Open QlickSense DataHub in the browser

url: https://<qlicksensehost>/hub/my/work/language/en (for English interface)

0. Create App

  1. Select Add data from files and other sources

  2. DataSource type - ODBC

3. Data Source Name (DSN) from Step 2 - SHINE

4. Username/password - credentials from SHINE user from Step 4.2

5. Browse owner schema - SHINE_CORE_SCHEMA and View PO.Item

6. Insert script and load data

7.Create Analyze Sheet and Storytelling

Step 6. Extraction for SAP HANA Calculation views

1. Select app from Step 5

2. Browse owner schema - SHINE_CORE_SCHEMA and Calculation view


3. Insert script and load data

4. Create Analyze Sheet and Storytelling



ODBC.Driver. Test Connection Error.

Communication link failure: 10709 Connection failed


2213725 - How-To: Troubleshooting of -10709 errors


SAP BASIS Routine task with examples from real life was provided


QlikView and SAP HANA Connectivity (pdf)

SAP HANA Interactive Education (SHINE) for SAP HANA 2.0 SPS03

for SAP HANA XS Advanced Model (pdf )

Labels in this area