Reporting Services Architecture—Data-Processing Extensions
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
Data-Processing Extensions
Data-processing extensions retrieve data from the report data source. Some of the tasks performed by data-processing extensions include open connection to a data source, analyze query and return field names, pass parameters, and retrieve and iterate data set. Table 3.1 outlines the data-processing extensions included and configured with SSRS.
Table 3.1. Data-Processing Extensions Configured with SSRS
| Extension | Description/Notes |
| SQL Server | Connects to and retrieves data from the SQL Server database engine versions 7.0 through 2005. |
| OLE DB | Connects to and retrieves data from OLE DB-compliant data sources. |
| Microsoft SQL Server Analysis | Connects to and retrieves data from the SQL Server Analysis Services Services 2000 and 2005. For Analysis Services 2005, this extension supports both Multidimensional Expressions (MDX) and Data Mining Expressions (DMX). For Analysis Services 2000, this extension supports nonparameterized MDX only. |
| Oracle | Connects to and retrieves data from an Oracle database; requires Oracle client 8i Release 3 (8.1.7) to be installed on a computer on which Reporting Server is installed. |
| ODBC | Connects to and retrieves data from ODBC-compliant data sources. |
| XML | Retrieves XML data from any XML web source (such as a web server) that can be accessed through a URL. |
All extensions, which are installed with SSRS (except XML), leverage corresponding .NET data providers. Microsoft.ReportingServices.DataExtensions library provides wrapper classes that supply SSRS data-processing extension interfaces to .NET data providers.
Developers can create additional custom data-processing extensions.
 
|
