Microsoft excel data analysis3/20/2024 ![]() ![]() Step 2: Select the connection type in MS-Excel. Step 1: Download and install the MDX Provider from SAP Support Portal.īefore downloading confirm your version of the Excel 32 bit/64 bit. We will be using MDX Provider to bridge the connection between HANA Database and Excel. Here in this post we are going to discuss how we can utilize the capabilities of MS Excel with HANA. We can extend the capabilities of Excel’s by connecting it to SAP HANA which provides real-time data access. 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 all know that the HANA is a database technology which provides data to the users very fast. 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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |