Creating Report Datasets from a SQL Server Parallel Data Warehouse

Microsoft SQL Server 2008 R2 Parallel Data Warehouse is a scalable data warehouse appliance that delivers performance and scalability through massively parallel processing. SQL Server PDW uses SQL Server 2008 R2 databases for distributed processing and data storage.

The appliance partitions large database tables across multiple physical nodes, with each node running its own instance of SQL Server 2008 R2. When a report connects to SQL Server PDW to retrieve report data, it connects to the control node, which manages query processing, in the SQL Server PDW appliance. After the connection is made, there are no differences between working with an instance of SQL Server that is and is not within a SQL Server PDW environment.

To include data from SQL Server PDW in your report, you must have a dataset that is based on a report data source of type Microsoft SQL Server Parallel Data Warehouse. This built-in data source type is based on the Microsoft SQL Server Parallel Data Warehouse data extension. Use this data source type to connect to and retrieve data from SQL Server PDW.

This data extension supports multivalued parameters, server aggregates, and credentials managed separately from the connection string.

For more information about SQL Server PDW, see the Web site SQL Server 2008 R2 Parallel Data Warehouse.

For more information about including data from SQL Server PDW in reports, see Getting Data from the SQL Server Parallel Data Warehouse Data Source Type (Report Builder 3.0) in the Report Builder 3.0 documentation on msdn.microsoft.com.

Community Additions

Show: