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!
cancel
Showing results for 
Search instead for 
Did you mean: 
gorbenkoteh
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



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.




  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:


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.





  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

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 )


3 Comments
Labels in this area