German enterprise software maker SAP AG says the latest version of its data warehouse solution will enable companies to access large data sets not only during off-peak periods.
SAP recently introduced version 7.4 of the SAP Business Warehouse (BW) powered by the company’s in-memory data architecture HAHA.
Traditionally, many organizations have to conduct data analytics tasks outside of normal business operating times SAP’s in-memory data fabric speeds business intelligence to front-line employees making businesses more productive and competitive in real time, while significantly reducing the overhead of duplicating data, the company said.
With the HANA integration, BW 7.4 is able to simplify data modelling, data access, data provisioning and governance in the in-memory data fabric. The new version also leverages HANA smart data access technology to enable the end user to virtually incorporate data from any sources or systems without having to physically move the data.
“We are completely changing the game for the traditional Data Warehouse market,” said Steve Lucas, president, Platform Solutions Group, SAP. “By dramatically simplifying, extending and reducing the complexity inherent in traditional data warehouse architectures, SAP BW on HANA will help our customers achieve real-time analytics not possible before.”
The power of the solution was demonstrated with the earlier announcement of the company’s achievement of a Guinness World Record for the largest data warehouse. At over 12 Petabytes, the record is three times larger than the prior record.
The scalability of the solution was also demonstrated on a public cloud based solution that loaded 8 million rows per second on 111 HANA instances using 1776 cores. The resulting queries ran in 330 mS, versus single instance performance of 250 mS, demonstrating the ability to scale massively with little impact on performance overhead.
One company considering whether or not to use Business Warehouse 7.4 is Molson Coors, the beer company created with the merger of Canada’s Molson and the United States’ Coors breweries.
Molson Coors is currently using version 7.3 of Business Warehouse and it also took part in a version 7.4 pilot project.
“At Molson Coors, our SAP data warehouse provides mission critical support for key decisions across the company,” said Lyne Strasbourg, global BI business alignment lead, Molson Coors. “With SAP BW 7.4, we’ll be able to deliver information to end users more efficiently and develop new solutions twice as fast.”