Reporting Services is one
of the core component of MS SQL Server. Reporting Services is a server based
reporting platform that provides reporting functionality to the user.Report
Server is central component of Reporting Services. In this article we will try
to understand how SSRS works in native mode deployment.
Reporting Services Report
Server runs in one of two deployment modes:
1.
Native Mode
2.
Sharepoint Mode
You can’t switch Report
Server mode from one to another so user
has to decide in which mode Reporting Services should be configured at the
time of Reporting Services installation. Native mode is the default mode for
Report server.
In Native mode Report
Server is a stand alone application server that provides all viewing, processing
and delivering of the reports and report model. Report Server is implemented
as a Microsoft Windows Service called as Report Server.
Native mode reporting
services Report Server 3 tier architecture is given below.
Report Server consists of a pair of Processing Engines
and five special purposes of extensions which handle Authentication, Report
Processing, Rendering, Data Processing and Delivery operation.
Let’s discuss each component from the above architecture.
Tier 3 (Client Application in Presentation layer)
User sends request to report server for Report Processing, Report Scheduling and Delivery etc from any of the client application present in presentation layer i.e Report Manager, Report Builder, Report Designer.
Tier 2 (Report Server Components)
1- Programmatic Interface:
Programmatic interface process all the requests sent to
Report Server from the client application present in presentation layer. This
includes requests from Report manager, Scheduling and Delivery Processor, Report
Design Tools and Third party Tools. Programmatic Interface uses Internet
Information Services (IIS) to receive the requests.
When a request arrives at the report server in the form
of SOAP (Simple Object Access Protocol) and http request; Programmatic
Interface interacts with the Report Server database in response to the request.
When a report is requested the programmatic Interface initialize the Report
Processor and when a Report Scheduling and Delivery is requested the
programmatic Interface initialize the Scheduling and Delivery Processor.
2- Report Processor:
When a report is send from the presentation layer, it will reach to the programmatic layer. Programmatic layer will initialize the Report Processor. Report processor will retrieve the report definition or model information then combines layout information with the data from data processing extension and renders it in the requested format.
Authentication, Report Processing, Rendering , Data Processing and Delivery Extensions
The report server supports five types of extensions, authentication extensions, report processing extensions, rendering extensions, data processing extensions and delivery extensions. A report server requires at least one authentication extension, rendering extension and data processing extension. Delivery and custom report processing extensions are optional.
The Scheduling and Delivery Processor processes reports
triggered from a schedule, and delivers reports to target destinations.
Tier 1 (Data Layer)
1- Report Server Database:
Reporting Server Database is a SQL Server database. This
is created at the time of Reporting Services configuration. It stores Reporting
Services data such as Report Definitions, Report Metadata, Cached Reports and snapshots.
It also stored security settings, encrypted data, scheduling -delivering and
extension information and folder hierarchy. This data is accessed through
Report Server. Report Server Database can provide internal storage information for
a single reporting services or multiple report server.
2- Data Sources:
This is the data which user
wants to represent in reports.
I hope you enjoyed the article don't forget to share on Facebook. Please leave your comments below if there are any questions.
Content reference is msdn.
No comments:
Post a Comment