Skip to Content
Author's profile photo Neelkanth Kumar


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.


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


2) Click on DataSources(ODBC)


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.


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.


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.


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

Give the name of the APP


7) Click on Create Button


8) Open the App


9) Add the data



10) Connect the data


11) Select the Provider


12) It should be SAP HANA MDX Provider


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



14) Provide the username and password.


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



16) Select the particular tables

17)  Load and Finish with the table.


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


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


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










Start learning and explore more learning examples at QlikView.

Happy Learning 🙂

Thanks and Regards,


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Neelkanth Kumar
      Neelkanth Kumar
      Blog Post Author

      Hi James,

      Yes It is possible to have Real Time Connection with HANA.

      Author's profile photo ajeet tomer
      ajeet tomer

      Hi Neelkanth and community,

      Pls help me to clarify:

      1. do we need to buy SAP Connector if we are using Qliksense?
      2.  is the same procedure can be applied in Qlikview? without SAP Connector purchase?





      Author's profile photo Juan Manuel Lopez Felizzola
      Juan Manuel Lopez Felizzola

      SAP Connector is mostly used to connect to SAP ERP systems


      for Hana you can just set up the ODBC as Neelkanth explained above.

      Author's profile photo Juan Manuel Lopez Felizzola
      Juan Manuel Lopez Felizzola

      I just created this account to thank you for being this thorough Neelkanth, thank you very much for your time.

      I am a Qlik consultant so I only needed the process to enable the server to configure the DSN, but it was a great help. Thanks again!