Skip to content

HP Enterprise Data Warehouse Appliance

2011 January 5
tags: , ,
by Brian Mitchell

5183295876_e749ee47de_mScouring Microsoft’s and Hewlett Packard’s sites for their latest SQL Server Parallel Data Warehouse information, I was pleasantly surprised to see some updates.  While the details on the sites are still sparse, there is much more information than prior to the 2010 PASS announcement.  Hopefully, more public information will be coming soon.

You can find an updated general SQL PDW page for SQL Server here.  For more specific HP information, Microsoft provides the technical highlights of the HP Enterprise Data Warehouse (EDW) here.  The first thing you notice is that HP names their appliance the HP EDW not HP PDW.  The marketing spiel is the HP Enterprise Data Warehouse Appliance optimized for SQL Server 2008 R2 Parallel Data Warehouse.   Whew!   I’ve picked some of the highlights of the highlights.

1. Massive scale and performance

· Each compute node has a balanced architecture approach comprised of HP ProLiant DL360 G7 server with 2 powerful Intel® Westmere processors and 12 active cores and HP StorageWorks P2000 G3 Modular Smart Array to offer massive performance and scale.

2. Simplicity

Available as a true appliance with integrated software, services and support, the HP Enterprise Data Warehouse Appliance dramatically simplifies deployment of an enterprise class data warehouse with a solution capable of creating a single view of enterprise data in less than a week versus multiple weeks or months with a custom solution.

3. Complete data warehouse solution

HP Enterprise Warehouse Appliance offers a complete solution for Data Warehousing and Business Intelligence thanks to deep integration with Microsoft BI tools such as PowerPivot for Excel, SQL Server Analysis Services, Reporting Services and Integration Services.

 

Additionally, you can get information from the hardware vendor’s EDW home.  In particular, you might want to check out HP’s EDW fact sheet.  If you are interested, they suggest that you “Contact HP Sales or HP and Microsoft Frontline Partners for additional details.”

While I was on HP’s site, I did find some useful information on SQL Server 2008 Fast Track Data Warehouse Reference Architectures.  While its not PDW, there are many cases where Fast Track is a better solution for a particular data warehouse environment.  In particular, you may be interested in this white paper, in which you can find HP’s Fast Track spec’s.

SQL Server 2008 R2 Parallel Data Warehouse is out there, hopefully now that the holidays are done the marketing engines can get in gear and continue to provide more public material for our customers. 

Now that you’ve had a look at what’s available, what questions are NOT getting answered?  What would you like to know about PDW that you aren’t finding?