CHAPTER 1 INTRODUCING THE REPORTING SERVICES ARCHITECTURE
Note On-demand reports are rendered and delivered directly to the client, while snapshots are reports that are
processed at a point in time and delivered to the client through e-mail or via file shares, or (if configured) directly
to a printer.Authentication Layer
SSRS 2005 relied heavily on the authentication methodology of Internet Information Services (IIS), since
SSRS and IIS were interdependent. With the exception of SSRS in SharePoint integrated mode, no SSRS
versions since 2008 are tied to IIS. SSRS now uses Http.sys directly, as well as SQL Server’s native
network components, so SSRS’s architecture has been redesigned to include its own authentication
layer, which we will cover in Chapter 11.The Report Processor
The Report Processor component is responsible for all report requests. Like the programming interface,
it communicates directly with the ReportServer database to receive the report definition information
that it then uses to combine with the data returned from the data source, which is accessed via one of
the data processing extensions.Data Processing
Reporting Services supports twelve data processing extensions to connect to data sources. These are:- SQL Server
- Oracle
- OLE DB
- OLEDB-MD
- ODBC
- XML
- SAP BI NetWeaver
- Hyperion Essbase
- Teradata
- Microsoft SQL Azure (SQL in the Cloud)
- Microsoft SQL Server Parallel Data Warehouse
- Microsoft SharePoint List
When the data processing component receives the request from the Report Processor, it initiates a
connection to the data source and passes it the source query. Data is returned and sent back to the