Skip to Content

Hello All,

Today I found a new 3rd party reporting tool QlikView / QlikSense . I tried to connect the reporting tool with sap hana and found that it is very easy procedure to connect it with sap hana and do the reporting.

We have to follow some stpes to create ODBC data source and make the successful ODBC connection with sap hana.

Prerequisites:

1) Before creating an odbc connection, it is required to login in sap hana studio with the particular username and password which is going to make the conenction with odbc.

2) HANA CLIENT should be installed in the system.

STEPS for ODBC Conenction


1) Go to control panel ->Administrative Tools

/wp-content/uploads/2015/08/c1_761799.png

2) Click on DataSources(ODBC)

/wp-content/uploads/2015/08/c2_761800.png


3) It will open a popup ODBC DATA source Administrator -> Click on Add button.

It will open to create a new data source. Click on finish.

/wp-content/uploads/2015/08/c3_761888.png

4) It will open a new popup window where you have to give the details of SAP HANA Description like <IP/hostname>:3$$15 where $$ is instance no.

/wp-content/uploads/2015/08/c4_761889.png


5) After that press connect button which will ask for the username and password for the particular system. Provide the correct details and connect with the system. It will show you the message of successfully connected.

STEPS IN QLIK VIEW

6) Now Open your Qlik Sense Software and Create new app.

Give the name of the APP

/wp-content/uploads/2015/08/q1_761890.png

7) Click on Create Button

/wp-content/uploads/2015/08/q2_761891.png


8) Open the App

/wp-content/uploads/2015/08/q3_761892.png


9) Add the data

/wp-content/uploads/2015/08/q3_761892.png

/wp-content/uploads/2015/08/q4_761897.png

10) Connect the data

/wp-content/uploads/2015/08/q5_761898.png


11) Select the Provider

/wp-content/uploads/2015/08/q6_761899.png

12) It should be SAP HANA MDX Provider

/wp-content/uploads/2015/08/q7_761900.png

13) Provide the User DSN which you created as ODBC connector name.

/wp-content/uploads/2015/08/q8_761901.png

/wp-content/uploads/2015/08/q9_761902.png

14) Provide the username and password.

/wp-content/uploads/2015/08/q10_761903.png


15) Which will open the below query. Select the particular Owner

/wp-content/uploads/2015/08/q11_761904.png

  /wp-content/uploads/2015/08/q13_761905.png

16) Select the particular tables

17)  Load and Finish with the table.

/wp-content/uploads/2015/08/q14_761906.png


18) It will show the below message Data was successfully loaded.

/wp-content/uploads/2015/08/q15_761907.png

19) It will show you the different chart list , start creating your own chart list as per your requirement.

/wp-content/uploads/2015/08/q16_761908.png

20) Create the bar chart as below and I have also create 2-3 demo chart example for you.


/wp-content/uploads/2015/08/q17_761915.png

/wp-content/uploads/2015/08/q18_761916.png

/wp-content/uploads/2015/08/q19_761917.png

/wp-content/uploads/2015/08/q20_761927.png

/wp-content/uploads/2015/08/q21_761928.png

/wp-content/uploads/2015/08/q22_761929.png

/wp-content/uploads/2015/08/q23_761930.png

/wp-content/uploads/2015/08/q24_761931.png

/wp-content/uploads/2015/08/q25_761932.png

Start learning and explore more learning examples at QlikView.


Happy Learning 🙂

Thanks and Regards,

Neelkanth

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. James Oswald

    Thanks for the informative blog. Is it possible to have a real-time connection to HANA, though, or are you just sucking the data out and having it be static? Would be nice if Qlikview would let you really use the power of hana.

    (0) 

Leave a Reply