Sap Hana Integration With Microsoft Excel

Microsoft Excel can be integrated with SAP HANA using MDX language with the help of pivot tables. SAP HANA client software is needed to make MDX connections which should be configured in the client system. Once this client software is downloaded and installed, you ca go ahead with the following procedure:

Step 1 : Launch MS Excel and go to the Data menu.

Step 2 : Select ‘From Data Connection Wizard’ option

Step 3 : Go to ‘Other/Advanced’ option and select ‘SAP HANA MDX Provider’.

Step 4 : Now, SAP HANA Login window will appear where you will provide the credentials, i.e., Host, Login, Instance, etc., and click on the ‘Test Connection’ button.

Step 5 : After successful completion of the test click ‘OK’ to enter into a new window asking to choose modeling views. Select the package.

Step 6 : Click on the name of analytic view or calculation and hit the ‘Finish’ button.

Step 7 : A dialog box will appear informing you about saving the password in the Excel file which will save you from entering password over and over again. Click on ‘Finish’ button and you connection with SAP HANA database is made.