Technical Articles
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
About.
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.
Prerequisites.
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.
Resolution
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)
Links/Notes:
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
-
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:
SQL:
Source Table/Views
non-SQL:
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
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
user: XSA_ADMIN
password: <Master password>
-
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
-
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
sap.hana.democontent.epm.models::PO_ITEM
3. Insert script and load data
4. Create Analyze Sheet and Storytelling
Troubleshooting
Error
ODBC.Driver. Test Connection Error.
Communication link failure: 10709 Connection failed
Resolution:
2213725 – How-To: Troubleshooting of -10709 errors
Conclusion.
SAP BASIS Routine task with examples from real life was provided
Links
QlikView and SAP HANA Connectivity (pdf)
SAP HANA Interactive Education (SHINE) for SAP HANA 2.0 SPS03
for SAP HANA XS Advanced Model (pdf )
Clean & nice summary! Just wondering is the SHINE installation mandatory?
Heading spelling correction 'Integrate it', you have put up as 'Intentegrate it', thanks.
Hello, Mr.Perumal
Thank you for your attention.
SHINE installation is not mandatory
Fixed, thank you!
Can i access qlik dashboard into hana as Data source for hana modelling?