The update to Business Warehouse incorporates what SAP calls an in-memory data fabric
SAP is continuing to merge its HANA in-memory database platform with its Business Warehouse data warehousing software, with the latest update adding support for HANA’s real-time data loading services.
Companies with large data warehouses often load information sets at off-peak times, such as in overnight batch jobs. But with the general availability of Business Warehouse 7.4, HANA’s “smart data access” services can tap any source within or outside a company as it’s needed. SAP is calling the approach an “in-memory data fabric.”
The services don’t actually physically move data into Business Warehouse; rather, the target sources are viewed as virtual tables. This services provide broader access to data sets, as well as the ability to keep frequently accessed information sets inside the core data warehouse while reaching out to ones that are needed only occasionally as desired.
SAP has been pushing the IQ database it gained through the acquisition of Sybase as an ideal option for coring such “cold” data sets.
Real-time data access also helps Business Warehouse users generate better BI (business intelligence) reports, said Neil McGovern, senior director of product and innovation marketing at SAP. “You’re always getting the very latest data because you’re reaching out to the source.”
Monolithic, centralized data warehouses “are no longer viable,” added Ken Tsai, vice president of HANA and data management product and innovation marketing at SAP.
Still, SAP is keen to show the scalability of HANA and Business Warehouse. SAP recently announced it had won a Guinness World Record for the largest data warehouse. It built a 12 petabyte system on Amazon Web Services spanning 111 HANA instances.
This article has been extracted from http://www.computerworld.com, please click on this link to read the article in full http://www.computerworld.com/s/article/9247183/SAP_gets_39_smart_39_about_data_warehousing?taxonomyId=9
Montash is a multi-award winning, global IT recruitment firm. Specialising in permanent and contract positions across mid-senior appointments which cover a wide range of industry sectors and IT functions, including:
ERP, BI & Data, Information Security, IT Architecture & Strategy, Scientific Technologies, Demand IT and Business Engagement, Digital and E-commerce, Infrastructure and Service Delivery, Project and Programme Delivery.
With offices based in London, Montash has completed assignments in over 30 countries and has appointed technical professionals from board level to senior and mid-management in permanent and contract roles.
For more information please visit www.montash.com