The MDX query language is a key way to access data in SAP HANA. SAP now has a certification process for BI products that connect to HANA using the MDX query language. arcplan Enterprise is the first company to be certified by the SAP ICC. According to arcplan, “The SAP® Integration and Certification Center (SAP ICC) has certified that arcplan Enterprise 8 successfully passed the testing standards and integrates with SAP HANA® via OLE DB for OLAP (ODBO) connection using the multidimensional expressions (MDX) query of SAP HANA®.” arcplan has always been a first class interface on SAP BW and it is good to see them again taking the lead with SAP HANA. It is also good to see the ecosystem of products that work with SAP HANA grow and mature.
The two primary ways to query and access data in SAP HANA are to use the SQL query language or the MDX query language. SAP previously had SQL certification for HANA and now has also added MDX certification for HANA. Certification means that the product is approved by SAP to work in conjunction with HANA and that it is using an SAP approved interface.
The MDX query language technology in SAP HANA is based on the SimbaProvider OLAP SDK. SimbaProvider is the basis for the MDX technology used for Exasol, Kognitio, Oracle OLAP, SAP BW, SAP HANA, Teradata, and many others. Simba’s MDX query language technology is the key way to connect Excel Pivot Tables and other BI tools to OLAP data sources.