Data Warehousing

Deploy Parallel Data Warehouse for your most demanding data warehouse implementations.

Take advantage of enterprise-class scale

• Scale your data warehouse from 10s to 100s of terabytes.

• Build a data warehouse faster with a range of integrated products.

• Safely invest in balanced hardware, with pretested appliances optimized for data warehousing.

• Add capacity to the appliance as data volumes grow—no need for a “forklift upgrade.”

• Gain predictable performance and reduce both load times and system downtime with high-performance data loading.

• Process more data faster by taking advantage of MPP.

Be confident with enterprise-level support and maintenance

• Benefit from your choice of maintenance and support offerings to help keep your most demanding data warehouses running.

• Enjoy the peace of mind given by unlimited problem resolution support, a feature of the new Parallel Data Warehouse maintenance offering.

• Rely on a mission-critical maintenance offering for deeper end-to-end support, based on the Microsoft Services Premier Support offerings.

Take advantage of integration with leading BI and ETL tools

• Benefit from close integration with Microsoft business intelligence (BI) tools, such as SQL Server Integration Services, Analysis Services, and Reporting Services.

• Leverage interoperability between Parallel Data Warehouse and other BI and ETL tools such as Informatica, SAP Business Objects, and Microstrategy.

Choose from a set of hardware appliances from HP and Dell.

Select your preferred hardware vendor

• Avoid vendor lock-in; choose an appliance from HP or Dell.

• Reduce hardware purchase and maintenance costs with industry-standard hardware.

Choose deployment options

• Expand your deployment options with a unique, integrated distributed architecture available with Parallel Data Warehouse.

• Reuse existing data warehouse appliances, including Fast Track Data Warehouse data marts, as part of a distributed Data Warehouse architecture.

• Simplify ETL processing via high-speed, parallel data transfer from EDW to data marts.

• Support users with different needs and service-level agreements on their own data maps.

• Integrate data across the enterprise with integrated MPP and SMP Data Warehouses.

Pick the right configuration for your workload

• Choose the right appliance size from a one rack to a five-rack system.

• Select your preferred disk drive type from several SAS and SATA options.

• Reduce risk with pretested reference architectures.

Benefit from the most complete data warehouse solution that includes Microsoft BI tools and related tools, such as Master Data Services and StreamInsight.

Employ a complete data warehouse solution

• Take advantage of the same technology for desktop nodes, data marts, and enterprise data warehouses.

• Gain a complementary toolset that includes SQL Server Integration Services for ETL, Analysis Services, Reporting Services, Master Data Services, and StreamInsight.

• Integrate MPP with symmetric multiprocessing data warehouses through the hub-and-spoke architecture.

• Use Parallel Data Warehouse as a high-performance, subject-oriented data mart.

• Leverage interoperability between Parallel Data Warehouse and other BI and ETL tools such as Informatica, SAP Business Objects and Microstrategy.

Promote a compelling user experience

• Let people perform BI tasks—by using PowerPivot for Excel—that are fully integrated with Parallel Data Warehouse.

• Expedite BI applications through integration with Microsoft BI tools, such as PowerPivot, SQL Server Analysis Services, Reporting Services, and Integration Services.

• Create powerful, professional reports with Report Builder 3.0, which is fully integrated with Parallel Data Warehouse.