The Forrester Wave: Enterprise Data Warehousing Platforms

February 10, 2011 The Forrester Wave™: Enterprise Data Warehousing Platforms, Q1 2011 by James G. Kobielus for Business Process Professionals Making Leaders Successful Every Day For Business Process Professionals February 10, 2011 The Forrester Wave™: Enterprise Data Warehousing Platforms, Q1 2011 Teradata, oracle, Sybase (SaP), iBm, SaP, Emc Greenplum, netezza (iBm), and microsoft lead, With vertica Systems as a Strong Performer by James G. Kobielus with Boris Evelson, connie moore, and charles coit ExEcuT i v E S u m ma ry In Forrester’s 56-criteria evaluation of enterprise data warehousing (EDW) platform vendors, we found the EDW market increasingly competitive, as illustrated by tighter clustering of top vendors. Teradata, Oracle, Sybase (SAP), and IBM lead by offering high-performance, scalable, flexible, and robust EDW solutions. Teradata provides the most scalable, flexible, cloud-capable EDW solution in today’s market. Oracle has built its Exadata Database Machine into a formidable new product family. Sybase, recently acquired by SAP, continues to enhance IQ’s massively parallel columnar technology for real- time analytics. IBM has ramped up its EDW solution focus and now sets the pace on petabyte-scale Hadoop integration. SAP is rapidly evolving and converging BW and BWA into a high-performance EDW with an in-memory, columnar infrastructure optimized for real-time analytics. EMC Greenplum demonstrates solid execution and continued innovation. Netezza (recently acquired by IBM) has integrated in-database analytics into its high-performance EDW appliances. Microsoft has launched cost-effective EDW appliances for midmarket and large enterprises, and Strong Performer Vertica Systems continues to enhance its high-performance all-columnar EDW architecture. TaBl E o F co nTE nTS n oT E S & rE S o u rcE S 2 EDW Provides Core Infrastructure For Agile Forrester conducted product evaluations in Q3 Business Processes 2010 and interviewed nine vendor companies: 6 EDW Platforms Evaluation Overview Emc Greenplum, iBm, microsoft, netezza (now owned by iBm), oracle, SaP, Sybase (now owned 10 Leading EDW Platforms Are Shifting To A by SaP), Teradata, and vertica Systems. We also Solution And Services Focus used an online survey to gather feedback from 12 Vendor Profiles customer references provided by each of these 22 Supplemental Material vendors. Related Research Documents “The roi of Data Warehousing appliances: Benefits, costs, and risks” november 10, 2010 “The roi of Data Warehousing appliances: Flexibility” november 10, 2010 “in-Database analytics: The Heart of The Predictive Enterprise” november 12, 2009 © 2011 Forrester Research, Inc. All rights reserved. Forrester, Forrester Wave, RoleView, Technographics, TechRankings, and Total Economic Impact are trademarks of Forrester Research, Inc. All other trademarks are the property of their respective owners. Reproduction or sharing of this content in any form without prior written permission is strictly prohibited. To purchase reprints of this document, please email clientsupport@ forrester.com. For additional reproduction and usage information, see Forrester’s Citation Policy located at www.forrester.com. Information is based on best available resources. Opinions reflect judgment at the time and are subject to change. 2 The Forrester Wave™: Enterprise Data Warehousing Platforms, Q1 2011 For Business Process Professionals EDW PROVIDES CORE InFRASTRuCTuRE FOR AGILE BuSInESS PROCESSES Successful business processes depend on a steady stream of high-quality decisions. Your enterprise data warehouse (EDW) can provide the core infrastructure driving smart decisions across your company and extended value chain. An EDW’s core purpose is to deliver actionable, timely, and trustworthy intelligence to a wide range of business processes. As a best practice, an EDW organizes analytical, historical data into functional domains — such as customer, finance, manufacturing, and human resources — that align with key processes, roles, and applications. Just as important, an EDW offers high performance, 24x7 availability, modular scalability, stringent security, and other robust features to support the most demanding business requirements.1 Business process and information management professionals regularly make substantial investments in EDW software, hardware, services, and personnel that consume millions of dollars. If you have introduced business intelligence (BI) across your enterprise, you will typically need an EDW (physical or logical) to populate reports, queries, dashboards, and other analytic applications with trusted, reconciled, and integrated data. Likewise, if you have invested in customer relationship management (CRM), enterprise resource planning (ERP), or other line-of-business (LOB) apps, you need an EDW to consolidate data from these transactional sources, offload compute-intensive analytical applications, and drive high-quality decision support to the operational frontlines. next-Generation EDW Powers “next Best Actions” Everywhere Enterprises increasingly incorporate their EDW into continually agile and self-optimizing business processes. An EDW — extended through in-database analytics, embedded statistical algorithms, predictive models, and complex business rules — can function as the core of a “recommendation engine” that drives “next best actions” across all processes. This allows you to design closed-loop back-end processes that are continuously optimized through inline analytics. EDW-powered recommendation engines can also continuously extend targeted offers to customers through the call center, self-service portal, point of sale, and other channels — maximizing customer lifetime value (see Figure 1).2 February 10, 2011 © 2011, Forrester research, inc.