Skip to Content
Technical Articles
Author's profile photo Roshan Kumar

Connect MS-Excel to SAP HANA Database/Analysis in excel with HANA data

SAP HANA is a high-performance in-memory database that accelerates data-driven, real-time decision-making and actions and supports all workloads with the broadest advanced analytics on multi-model data, on premise and in the cloud. We all know that the HANA is a database technology which provides data to the users very fast.

On the other hand, MS Excel is one of the most widely used data representation, analysis and reporting software of all time and still it is one of the most important software used throughout the world.

We can extend the capabilities of Excel’s by connecting it to SAP HANA which provides real-time data access. Here in this post we are going to discuss how we can utilize the capabilities of MS Excel with HANA.

We will be using MDX Provider to bridge the connection between HANA Database and Excel.

Step 1: Download and install the MDX Provider from SAP Support Portal.

Before downloading confirm your version of the Excel 32 bit/64 bit.

Link: https://launchpad.support.sap.com/#/softwarecenter/support/index

Step 2: Select the connection type in MS-Excel.

Open the MS Excel . Go to the Data tab. Then select From Other Sources option. From the drop-down list, select From Data Connection Wizard.

Step 3: Select the data provider type

Select Other/Advanced option from the Data Connection Wizard dialog and click Next.

SAP HANA with MS Excel - Selecting Other Advanced option

Step 4: Select the data provider

Select the data provider as SAP HANA MDX Provider from the given list. Then, click on Next>>.

Step 5: Enter connection properties

Enter connection parameters specific to SAP HANA user account like Host name, Instance number, User name, Password, and Preferred language. You can instantly test a connection from this dialog by clicking on the Test Connection option.

A message will prompt confirming a successful connection that says, “Test Connection Succeeded”. Click on OK to continue.

Note: Make sure the checkbox multi database and user database is ticked.

Step 6: Select view and create chart

Once the connection established you will be able to see the package and there views built through the HANA Studio.

Choose the object which is required for your analysis and use chart or any other excel features to represent your data.

Note: Slow internet connection may throw connection error.

 

There is no doubt SAP has provided us lots of resources and features to make our business easy and simplified.

I will be here to answer all your questions in case you find any issue.

Thank you.

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Navya Singh
      Navya Singh

      Hi,

      Does this Analysis plugin also work in SAP HCM environment or need SAP BW?

      Thanks,

      Navya

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

      HCM Environment not sure but definitely it will work on BW.

      Author's profile photo Syed Hassain
      Syed Hassain

      Hello,

       

      Can anyone help me how to link SAP Query to excel. Please help me out.

      I would be thankful to you.

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

      Please be precise with your question. Can you add some more detail?

      Author's profile photo vijaysureyen ap
      vijaysureyen ap

      what to do if it is showing like this  ??

      Author's profile photo Roshan Kumar
      Roshan Kumar
      Blog Post Author
      vijaysureyen ap : Please send me the check boxes you have selected.
       Also make sure your internet has good speed. Definitely you have entered some wrong inputs as target machine is refusing it.
      Author's profile photo vijaysureyen ap
      vijaysureyen ap

      Ok brother I'll check on Monday and I'll comment u .. thanks for your reply

       

      Author's profile photo Zeeshan Haryani
      Zeeshan Haryani

      the performance is very slow for a small query, any way to improve