the data management environment

HP and Microsoft Data Management solutions

Complete, optimized, agile solutions for data warehousing and business intelligence.

Brochure

SIMPLIFY

2

Comprised of the Microsoft Application Platform and HP Converged Infrastructure, this family of optimized appliances:•Integrates the assets, knowledge, expertise and resources of two of the leading

IT companies in the world

•Minimizes deployment risk by providing services and support from HP and Microsoft Partners; you receive the services need, when you need them, from people you trust

•Bridges the path to cloud by unifying technologies and enabling applications that run partially in the cloud; you can move down the path at your own pace, using ‘hybrid’ applications that leverage the advantages of the cloud while remaining rooted in the physical data center

As the value of information—as well as the volume—continues to rise, growing companies like yours are searching for a more effective and efficient way to

manage data. HP and Microsoft have the answer: pre-configured appliances that contain all the software, hardware and services you need to quickly deploy

data warehousing and business intelligence (BI) environments, while speeding your time to value.

3

“Two-thirds of global industries are now in fundamental flux; finding profitable growth will challenge even the best companies in the unstable recovery ahead.” Profit from the Core: A Return to Growth in Turbulent Times, Bain & Company, March 2010

Find the value of informationYour organization faces numerous challenges today, with greater demands being placed on fewer resources and increasing pressure to improve performance. You strive to control IT costs, while also ensuring that workers have the information and tools they need to make good, fast decisions that drive continued growth. In addition, your organization needs to boost competitive advantage by delivering new products and services that attract and retain customers, as well as expand into new markets and geographies.

In today’s challenging economic climate, immediate access to relevant, timely business information is often the most critical factor for success. Strategic decisions are impossible without the right information at your fingertips. Today, however, you may find it difficult to access the business intelligence you need, when you need it because:

•As your organization has grown, information has becomes scattered in disparate places such as individual spreadsheets, application databases, online transactions and third-party sources. The result is a fractured, incomplete view of your business.

•Custom-built BI solutions are costly and time-consuming to implement, placing the technology beyond the reach of your organization. Like many mid-size organizations, your IT department may not have expertise in BI best practices or may lack the engineering expertise to integrate multiple BI technologies within your infrastructure.

•Purpose-built BI solutions are typically designed to serve a select set of workers. Casual users are often overwhelmed by sophisticated, unfamiliar tools. Rather than struggle in vain, casual users turn to IT to manually process ad hoc report requests. At the same time, power users with specialized data needs may bypass IT altogether to build their own unsanctioned resources, making it difficult for IT to control how BI tools and the underlying data are being used.

•Critical business applications are developed piecemeal, requiring large investments to optimize, maintain and integrate the applications, tools and infrastructure into the services needed to support end users. A typical business service can take up to 18 months to deploy, with no guarantees of success.

In today’s new era of convergence, it’s time to rethink traditional solutions and create open, modular systems that deliver complete business-critical applications with confidence. It’s time for easily accessible data management and business intelligence solutions that can overcome your tough business challenges without becoming a burden to IT. It’s time for solutions that are:

•Complete: with all the hardware, software and services you need to get up and running quickly

•Optimized: with the software optimized to run on industry-standard servers and storage

•Agile: to flex with your changing business requirements

It’s time for data management appliances from HP and Microsoft, delivered by our Partners.

4

Pre-configured and pre-tested by HP and Microsoft, data management appliances are designed to be easy to operate, be useable in minutes, and provide strong reliability and security for the workloads they run. Focusing on the needs of today’s growing organizations, these data management appliances help you overcome many key issues:

•Complexity. Today’s challenging marketplace is driven by rapid technology evolution in all areas of infrastructure, increasing exposure to global markets and increased competition partly generated by difficult economy.

•Time. The increasing requirement for business services to drive competitive advantage and greater efficiencies means IT is expected to deliver solutions faster, with a higher success ratio.

•Risk. Failed projects cause immediate and long-term impact to stakeholder satisfaction, with resulting losses of sales opportunities, revenue and customers; successful service delivery is imperative.

•Extensibility. In today’s rapidly evolving market, it’s important for you to future-proof your infrastructure so that you can capitalise on the right solutions to support your business model today and in the future.

Achieve self-service business intelligenceBy combining the most prolific BI tools in the industry, including SQL Server 2008 R2 and SharePoint 2010, HP and Microsoft deliver the HP Business Decision Appliance—the industry’s first self-service BI environment that can be deployed in less than an hour. Adding to the value of this turnkey offering is the award-winning Excel-based PowerPivot—built into the Appliance.

The HP Business Decision Appliance incorporates familiar Microsoft technologies that empower business users to rapidly gain insight from real-time business data with minimal IT involvement. Excel power users can now quickly and easily create PowerPivot workbooks that support their decision-making processes—helping drive growth, reduce costs and mitigate risks.

Backed by the deep BI expertise of HP and Microsoft, the HP Business Decision Appliance simplifies and accelerates deployment of your business intelligence system with a fully integrated stack of hardware and software, including HP ProLiant servers and HP Insight

Control Management technologies. The appliance is built on “golden images” that have been jointly tested, tuned and validated by HP and Microsoft labs, with components pre-configured at the factory. This pre-integrated architectural approach ensures a simplified and accelerated deployment with reduced configuration time and streamlined data loading and data center integration. The appliance can be up and running in about an hour—enabling fast return-on-investment and immediate business impact, while also minimizing implementation costs and risks. In addition, a preconfigured appliance means a more balanced system that delivers optimal performance.

Key features and business benefitsHP Business Decision Appliance enables you to:

•Secure important business data with an essential and fault tolerant platform delivered by the HP ProLiant DL360 G7 server.

•Increase manageability by integrating the hardware and software infrastructure into a single technology stack.

•Reduce complexity, setup and configuration with a customized management dashboard and automated deployment wizard.

Solution components

*Software licenses must be purchased separately to activate pre-installed software.

HP Business Decision Appliance

Servers ProLiant DL360 G7 (X5650 processor) with 96GB RAM

Storage 8 x internal 300GB SFF SAS disks

Software Microsoft Windows Server 2008 R2 Enterprise Edition

Microsoft SQL Server 2008 R2 Enterprise Edition

(PowerPivot for SharePoint 2010 included)*

Microsoft SharePoint Server 2010*

HP Insight Control

Infrastructure None (install in existing rack)

Services HP 3-year 24x7 hardware and software support with 4 hour on-site hardware response is included. HP Support covers all components of the appliance, including the Microsoft software.

5

“In an environment of growing data volumes and a growing number of business end users requesting access to information to improve their own decision-making capabilities, there is a need for more pre-packaged data warehousing solutions that enable simpler purchasing of the technology, rapid deployment, single-vendor responsibility for ongoing support, and technical performance optimization to address specific requirements of each organization.”IDC, Benefits of Investing in Data Warehousing to Enable BI and Analytics, July 2010

The Business Intelligence ContinuumThe end-to-end Microsoft Application Platform, powered by SQL Server 2008 R2, enables your entire organization to be aligned with a common view of the business, while powerful BI tools extend real-time insights to teams and individual users for faster, better decision-making.

Create a single view of informationA scalable, high performing SQL Server-based solution, the HP Enterprise Data Warehouse System delivers enterprise-class scalability and a single view of the truth across your organization’s data. Built on a tightly integrated architecture, the HP Enterprise Data Warehouse Appliance combines high-density capacity and performance to provide a very large data warehouse with market-leading cost-per-storage. Able to support from tens to hundreds of terabytes (TB) of data, this dedicated appliance is a fully integrated stack incorporating HP ProLiant servers, HP StorageWorks storage and HP ProCurve networking products, combined with backup tools and management software from both HP and Microsoft, pre-installed and pre-configured in the HP factory to simplify implementation and quicken time to business value.

Powered by SQL Server 2008 R2 Parallel Data Warehouse, the HP Enterprise Data Warehouse Appliance offers highly reliable and massive parallel scale-out query processing—without the complexity of deploying extremely large data marts. The HP Enterprise Data Warehouse Appliance offers a balanced system that ensures high-performance and scalability at reduced cost and with a faster time-to-deployment. For example, an integrated appliance on industry-standard hardware and software can reduce setup, configuration and expansion time by one to six months on average, to minimize implementation costs and risks.

Strategy-DrivenBusiness

Compliance & Risk

Management

ConsistentMeasurement

& Rewards

InnovationOrganization

Organizational BIThe Org’s Context

BI Solution created by IT, Established corporate

context and is reusable, scalable, and backed up.

Team BIOur Context

BI Solution created by power user. Context is for a

small team and it is managed on a server.

Personal BIMy Context

BI Solution created by user, Context is only for user and

exists as document.

SQL Server 2008 R2 extends reach from organizational BI to team and personal BI

Local Decision-Making

Aligned Empowered

6

Solution architectureConsisting of one control rack and up-to-four data racks, this dedicated, fully integrated appliance combines industry-leading HP server, storage and networking components with Microsoft application platform software and integrated management.

Solution components

*Software license for Parallel Data Warehouse must be purchased separately to activate pre-installed software.

HP Enterprise Data Warehouse

Servers 2x HP ProLiant DL360 G7; 1x DL370 G6; 3x DL380 G7

Storage HP StorageWorks MSA P2000 G3 (+ internal) storage

Software Microsoft Windows Server 2008 SP2

Microsoft SQL Server 2008 R2 Parallel Data Warehouse*

Infrastructure Infrastructure InfiniBand, FC, Ethernet switching, 42U rack

Data Rack Servers 10 active + 1 passive HP ProLiant DL360 G7 compute nodes

Storage 10x HP StorageWorks MSA P2000 G3

Software Microsoft Windows Server 2008 SP2

Microsoft SQL Server 2008 R2 Parallel Data Warehouse*

Infrastructure InfiniBand, FC and Ethernet switching, 42U rack

Expansion Grow from 1–4 data racks, storage options, test/dev system

Services Industry-leading reactive and mission critical support jointly delivered by HP and Microsoft to provide integrated and end-to-end coverage of both the hardware and software components of the appliance.

Key features and business benefitsHP Enterprise Data Warehouse Appliance enables you to:

•Deliver 10 times faster throughput and 100 times faster query response, offering constant performance regardless of scale.

•Reduce deployment time from months to days with an integrated solution that features familiar Microsoft software, HP industry-standard technology, and a complete range of optional consulting services from HP Partners.

•Increase performance per compute node with fewer racks, using HP ProLiant DL360 and DL380 G7 servers and HP StorageWorks P2000 G3 Modular Smart Array storage.

Control rack Data rack (s)

•Simplified: Choice of deployment options

•Complete: designed for mission-critical environments

•Massively Parallel Processing (MPP) design

7

Transform your data warehouseIn addition to converged appliances, HP and Microsoft also offer a portfolio of HP Fast Track 3.0 Data Warehouse Reference Architectures. These proven solutions can help you capitalize on information to transform your data warehouse.

Many hardware configurations respond slowly to data warehouse queries because they are tuned for generic transactional systems. But the HP Fast Track 3.0 Data Warehouse Reference Architectures take a different path. They are balanced and tuned for relational online analytical processing solutions—enabling them to provide superior and scalable performance for data warehouse workloads, as compared to traditional, random I/O methods.

Available in Entry Level, Basic, Mainstream and Premium configurations, these HP and Microsoft reference architectures integrate:

•Highly reliable HP ProLiant servers•Affordable HP StorageWorks P2000 G3 Modular

Smart Array (MSA) disk arrays •Flexible HP ProCurve switches •HP StorageWorks B-series SAN solutions – the

industry’s most complete and comprehensive range of SAN solutions, from embedded switches to enterprise-class directors

•Powerful Microsoft SQL Server 2008 Enterprise Edition

Key features and business benefitsWith the ability to scale from 4 TB to 80 TB, these reference architectures offer a smaller footprint than competitors’ offerings. They also help boost the speed of data access and integration as you:

•Accelerate data warehouse implementations – reducing costs and facilitating successful deployments

•Improve agility and responsiveness – while reducing risks by applying rigorous best practices and industry-standard solutions

•Reduce total cost of ownership – with cost-efficient hardware, decreased cost of deployment and operation, faster time to solution and lower TCO

•Choose HP Factory Express – to pre-integrate your solution

Receive the services you need, when you need themIn addition to software and hardware, your converged data management solution also includes professional services. You can chose from assessment, design, proof of concept and implementation services for your appliance.

•HP Enterprise Data Warehouse Appliance: Consulting services accelerate deployment, by speeding data integration into the data warehousing appliance and simplify planning, implementation, data quality/management and information governance.

•HP Business Decision Appliance: Consulting services provide actionable intelligence through enabling deployment the appliance in one hour to realize business intelligence in one week.

Key features and business benefits•Leverage the expertise of HP, Microsoft and certified

HP and Microsoft Partners in delivering the most complete, simplified data management, business intelligence and data warehouse solutions

•Define a clear path that enables you to achieve better business results

•Reduce complexity by providing you with a single-point of contact to purchase, deploy and support your appliance—resulting in fast and accurate problem resolution

See the competitive differenceWith data management appliances, HP and Microsoft combine their expertise to deliver solutions that offers greater scalability and higher performance than any other SQL Server data management deployment existing today. In addition, the appliances bring real and measurable benefits over competitive solutions:

•25% greater processor scalability, better performance and scalability per data rack1

•25% greater scalability of storage capacity per data rack, which lowers costs by supporting larger data warehouses with fewer racks2

•Up to 50% better tempdb performance for complex queries and staging-to-production operations, to achieve performance targets with fewer nodes and better performance and scalability per rack3

•Up to 1.5x superior scan-rate performance by leveraging small form-factor disks for the data nodes, at similar cost-per-terabyte to large form-factor configurations

•Only HP offers the end-to-end value chain from sale and build to support for end-to-end simplicity and support peace-of-mind

1, 2 Source: HP Engineering data, August 20103 Source: Based on Oracle public pricing lists: Exadata price list and Oracle

database price list. Assumes the following costs: Hardware $650K (168 TB of raw space/~60 TB actual data space); Storage software $1.68M ($10,000/drive); Database $2.99M (8 dual processor, quad core servers with 11g, EE+RAC+Partition+Compression)

This is an HP Indigo digital print.

Get connectedwww.hp.com/go/getconnected

Get the insider view on tech trends, alerts, and HP solutions for better business outcomes

© Copyright 2011 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.

Microsoft and Windows are U.S. registered trademarks of Microsoft Corporation. Oracle are registered trademarks of Oracle and/or its affiliates.

4AA3-3999ENW, Created March 2011

Share with colleagues

Trust HP and Microsoft PartnersFor more than 20 years, HP and Microsoft Partners have served as trusted, responsive professionals to customers around the world. With a keen understanding of regional businesses and their challenges, local-accredited HP and Microsoft Partners are close at hand to maximize the benefits of complete, optimized and agile data management solutions from HP and Microsoft.

Drive greater value As companies turn to new architectures and new tools to help make sense of big data, you can trust HP and Microsoft to deliver solutions that meet your needs. By providing faster, more scalable and affordable IT, HP and Microsoft data management solutions drive excellent value across your organization:

Simplify – wide range of purpose-built offerings that simplify everything.

•Turnkey experience – converged appliances built for specific data management workloads, combining hardware, software, deployment and support services

•Choice for every requirement – right-fit offerings, from reference architectures to custom integration to appliances tailored for a wide range of workloads

•Snap-in usability – an open, modular approach, leveraging existing investments in productivity tools and infrastructure

Optimize – mission-critical reliability with standards-based solutions for unmatched TCO.

•Risk reduction – mission-critical-ready performance, scale and availability, delivered with a unique collaborative support model

•Total cost advantage – appliances that are configured, tuned and optimized for precise workloads, providing unmatched TCO

•Ready to grow – scale-up and scale-out solutions with flexibility to grow as business needs change

Accelerate – rapid delivery of applications to accelerate ROI and business results.

•Faster time to solution – appliance model that can be deployed in days rather than months

•Roadmap for innovation – long-term development roadmaps for data warehouse as well as BI offerings

•Rapid business results – extensive services and partner ecosystem to speed time to benefit, from proof of concept to enterprise-wide adoption

Learn moreYour use of Microsoft SharePoint Server 2010, Microsoft SQL Server 2008 R2 Enterprise Edition, Microsoft SQL Server 2008 R2 Parallel Data Warehouse Edition and Microsoft HPC Pack 2008 with SP1 and SP2 software provided on this server hardware is subject to the terms and conditions of the Volume License program agreement under which you have acquired licenses to these Microsoft products. You may not use the above software without first acquiring valid server and/or client access licenses from Microsoft or its authorized distributor or reseller. For more information, please visit: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx.