SQL Server Parallel Data Warehouse Connection Type (SSRS)
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 step-by-step instructions, see How to: Add and Verify a Data Connection or Data Source (Report Builder 3.0 and SSRS). For additional information about creating and using the SQL Server PDW data source, see the topic Connecting to SQL Server PDW with SQL Server Reporting Services in the SQL Server PDW help file.
How-To Topics
This section contains step-by-step instructions for working with data connections, data sources, and datasets.
How to: Add and Verify a Data Connection or Data Source (Report Builder 3.0 and SSRS)
How to: Create a Shared Dataset or Embedded Dataset (Report Builder 3.0 and SSRS)
How to: Add a Filter to a Dataset (Report Builder 3.0 and SSRS)
.gif "Arrow icon used with Back to Top link")
Back to Top
Related Sections
These sections of the documentation provide in-depth conceptual information about report data, and procedural information about how to define, customize, and use parts of a report that are related to data.
Adding Data to a Report (Report Builder 3.0 and SSRS)
Provides an overview of accessing data for your report.Data Connections, Data Sources, and Connection Strings in Report Builder 3.0
Provides information about data connections and data sources.Creating and Adding Datasets (Report Builder 3.0 and SSRS)
Provides information about embedded and shared datasets.Working with Fields in a Report Dataset (Report Builder 3.0 and SSRS)
Provides information about the dataset field collection generated by the query.Data Sources Supported by Reporting Services (SSRS) in the Reporting Services documentation in SQL Server Books Online.
Provides in-depth information about platform and version support for each data extension.
Back to Top