{"id":53940,"date":"2019-05-10T11:36:59","date_gmt":"2019-05-10T06:06:59","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53940"},"modified":"2021-12-04T13:10:15","modified_gmt":"2021-12-04T07:40:15","slug":"integrate-sap-hana-with-excel","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/","title":{"rendered":"How to Integrate SAP HANA with MS Excel – A Hassle Free Process"},"content":{"rendered":"

Previously, we learned the Relational\u00a0connection in SAP HANA<\/strong>,\u00a0now, it’s time to integrate SAP HANA with MS Excel. That is, how do we use data from SAP HANA into MS Excel spreadsheets for analysis and reporting.<\/p>\n

So, first of all, we will see how to establish a connection between MS Excel and SAP HANA, then we\u2019ll learn how to create visualizations using the data from SAP HANA.<\/p>\n

Integrate SAP HANA with MS Excel<\/h3>\n

As we know, SAP HANA is an efficient in-memory database technology which provides data to the users in the blink of an eye. On the other hand, MS Excel is one of the most widely used data representation, analysis and reporting software of all time.<\/p>\n

Excel\u2019s capabilities are extended by connecting it to SAP HANA which provides real-time data access and ad-hoc analysis on billions of data rows. MS Excel offers HANA support from the 2003 version to the current version.<\/p>\n

Excel uses an OLAP connection to SAP HANA database and information layers which is a direct connection. The interaction language used is MDX<\/strong> and the connection driver required is ODBO driver.<\/strong><\/p>\n

\"Steps<\/a><\/h2>\n

Connecting MS Excel to SAP HANA<\/h3>\n

In this section, we will learn how to connect to SAP HANA from MS Excel.<\/p>\n

Step 1: Select the connection type<\/strong><\/p>\n

Open the MS Excel spreadsheet. Go to the Data<\/strong> tab. Then select From Other Sources<\/strong> option. From the drop-down list, select From Data Connection Wizard.<\/strong>
\n\"SAP<\/a><\/p>\n

Step 2: Select the data provider type<\/strong><\/p>\n

Select Other\/Advanced<\/strong> option from the Data Connection Wizard dialog and click Next.<\/strong>
\n\"SAP<\/a><\/p>\n

Step 3: Select the data provider<\/strong><\/p>\n

Select the data provider as SAP HANA MDX Provider<\/strong> from the given list. Then, click on Next>><\/strong>.<\/p>\n

Step 4: Enter connection properties<\/strong><\/p>\n

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

A message will prompt confirming a successful connection that says, “Test Connection Succeeded”. Click on OK<\/strong> to continue.<\/p>\n

Step 5: Select the database catalog and view<\/strong><\/p>\n

Next, we will select the schema or table\/cube from the SAP HANA database as per our requirement. You can first select the database from Select the database that contains the data you want<\/strong> option. Then, select the schemas or tables within that database. Click on Next>\u00a0<\/strong>to continue.<\/p>\n

Step 6: Create a Windows connection file<\/strong><\/p>\n

Save the SAP HANA connection we just created and save the password for later use. You can also assign a Friendly Name for the connection file for the sake of easy recognition.<\/p>\n

Along with this, you can write a description for the file, give a file name, specify search keywords and select Excel services. Then, click on Finish<\/strong>.<\/p>\n

Using MS Excel with SAP HANA<\/h3>\n

Once we have created a connection to the SAP HANA system from MS Excel, now in the process to integrate SAP HANA with MS Excel, its time to learn how to perform analytical operations using the data we fetched from SAP HANA information views<\/strong>.<\/p>\n

Step 1: Select the form of data to import<\/strong><\/p>\n

Select in what form, you want to import the data. You can select from a list of options like as a table, pivot table report, pivot chart, or only create the connection. <\/em>Also, select the worksheet on which you want to import this data table or chart (Existing worksheet or New worksheet). Click on OK\u00a0<\/strong>to continue.<\/p>\n

Step 2: Drag & drop the data table field<\/strong><\/p>\n

You will see an empty pivot table template on the worksheet. You can drag and drop the field from the data table to the panel given in the right upper section naming PivotTable Field List<\/strong>.<\/p>\n

Drag and drop the fields to one of the four sections given in the lower half section on the right (below the field list section).\u00a0This section is named Drag Fields between areas below<\/strong>. The section is divided into four small sections; Report Filter, Column Labels, Row Labels, and Values.\u00a0<\/em><\/p>\n

If you want a field as a column in the table, drop it in the column section.<\/strong> Likewise, for rows, report filter, and value sections.<\/p>\n

Step 3: Pivot table creates instantly after drag & drop<\/strong><\/p>\n

SAP HANA responds quickly to the drag and drop you do on the Excel spreadsheet and creates a Pivot table instantly. You can change the rows and columns as per your requirements from the field list. The changes will immediately reflect in the table on the spreadsheet.<\/p>\n

Step 4: Create visualizations using the pivot table data<\/strong><\/p>\n

Now, to create some visualizations using the data in the pivot table, click on the\u00a0PivotChart<\/strong> option (under the Options<\/strong> menu on the menu bar).<\/p>\n

You can choose from a wide range of charts and graphs such as Columns, Line charts, Pie charts, Bar charts, Areas, Radar charts,<\/em> etc. There are many options within a particular chart type as well.<\/p>\n

Step 5: Conduct selections & analysis of table<\/strong><\/p>\n

The chart of your choice will be instantly made based on the data given in the table. You can make selections in the table which will reflect in the charts as well.<\/p>\n

Also, you can conduct analysis as per your liking by changing the fields, columns, and rows and detect the patterns and trends in data.<\/p>\n

We have completed the process to integrate SAP HANA with MS Excel.<\/p>\n

Summary<\/h3>\n

This is all we need to know about using data from SAP HANA in MS Excel. SAP HANA is an efficient and quick tool that enable users to perform reporting on the data fetched from HANA in-memory from tools like MS Excel.<\/p>\n

The in-memory data engine makes data processing many times faster than conventional databases.<\/p>\n

Now, are you clear with the process to Integrate\u00a0SAP HANA with MS Excel? If any queries, just enter in the comments section.<\/p>\n","protected":false},"excerpt":{"rendered":"

Previously, we learned the Relational\u00a0connection in SAP HANA,\u00a0now, it’s time to integrate SAP HANA with MS Excel. That is, how do we use data from SAP HANA into MS Excel spreadsheets for analysis and...<\/p>\n","protected":false},"author":6,"featured_media":54057,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19499,19498],"class_list":["post-53940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-connect-ms-excel-to-sap-hana","tag-integrate-sap-hana-with-ms-excel"],"yoast_head":"\nHow to Integrate SAP HANA with MS Excel - A Hassle Free Process - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn to integrate SAP HANA with MS Excel and perform analytical operations using data from information views through MS Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Integrate SAP HANA with MS Excel - A Hassle Free Process - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn to integrate SAP HANA with MS Excel and perform analytical operations using data from information views through MS Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-10T06:06:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:40:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1201\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Integrate SAP HANA with MS Excel - A Hassle Free Process - DataFlair","description":"Learn to integrate SAP HANA with MS Excel and perform analytical operations using data from information views through MS Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Integrate SAP HANA with MS Excel - A Hassle Free Process - DataFlair","og_description":"Learn to integrate SAP HANA with MS Excel and perform analytical operations using data from information views through MS Excel.","og_url":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-10T06:06:59+00:00","article_modified_time":"2021-12-04T07:40:15+00:00","og_image":[{"width":1201,"height":629,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"How to Integrate SAP HANA with MS Excel – A Hassle Free Process","datePublished":"2019-05-10T06:06:59+00:00","dateModified":"2021-12-04T07:40:15+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/"},"wordCount":985,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg","keywords":["Connect MS Excel to SAP HANA","Integrate SAP HANA with MS Excel"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/","url":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/","name":"How to Integrate SAP HANA with MS Excel - A Hassle Free Process - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg","datePublished":"2019-05-10T06:06:59+00:00","dateModified":"2021-12-04T07:40:15+00:00","description":"Learn to integrate SAP HANA with MS Excel and perform analytical operations using data from information views through MS Excel.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Integrate-SAP-HANA-with-MS-Excel.jpg","width":1201,"height":629,"caption":"Steps to Integrate SAP HANA with MS Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/integrate-sap-hana-with-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"How to Integrate SAP HANA with MS Excel – A Hassle Free Process"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53940"}],"version-history":[{"count":14,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53940\/revisions"}],"predecessor-version":[{"id":104918,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53940\/revisions\/104918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/54057"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}