Breaking

Thursday, July 23, 2020

SSRS Architecture

SSRS Architecture
SSRS has quite a complex architecture. The report services architecture includes development tools, administration tools, and report viewers.
Here, are important components of SSRS

Report Builder

It is an ad-hoc report publishing tool that is executed on a client's computer. It has a drag and drop interface that is easy to use.

Report Designer

The Report designer tool helps to develop all types of reports. It is a publishing tool, that is hosted in Visual Studio or Business Intelligence Development Studio (BIDS).

Report Manager

The report managers check the report, matching it with the given requirements. They make decisions based on those reports.

Report Server

It is a server which uses the SQL Server database engine to store metadata information

Report server database

It stores metadata, report definitions, resources, security settings, delivery data, etc.

Data sources

Reporting services retrieve data from data sources like relational and multidimensional data sources.

No comments:

Post a Comment