Integrate it! – Qlick View/Sense and SAP HANA integration. Step-by-step guide
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.
Click Start >Enter “ODBC Data Sources (64-bit)”
Select System DSN tab -> Add
Fill the Data source name, Description, Host, Instance number, Multitenant (checked), Tenant Database SID fields
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:
Attribute Views in SAP HANA can be similar to Dimensions in SAP BW.
Analytic Views in SAP HANA can be similar to InfoCubes in SAP BW.
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
SAP HANA DEMO MODEL ADV. 1 (SUPPORT PACKAGES AND PATCHES)
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.
Create a subfolder on HANA DB Server. For example: /distr/SHINE
Upload SHINE installation media to /distr/SHINE
Open CLI and login as XSA_ADMIN
command: xs l
password: <Master password>
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
Select Add data from files and other sources
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 )