Reporting Service Architecture




The Reporting Service Architecture Components 

  • Report Manager :- It is a web application which stores and manages report,report models,report parts, folders, subscriptions, security and schedules.
  • Report Server :- This is a web service which exposes all the methods for report management to Report Manager/Custom applications which can consume it and can create UI for report management.
  • Report Server DB/Temp DB :- The report server database keeps all the report paths, schedule info and other utility information like schedule,subscription details in DB tables. The report Server temp db keeps the session related information like SessionData, Snapshot, temp catalog and temp datasource etc.
  • Report Designer :- This is the tool used to design the report. For SSRS we have Report Builder and Business Intelligence Development Studio tools used to design reports.
  • Data Source :- Data Source is used to connect to the source from where data needs to be presented using report.
  • Report Processor :- The report processor is the engine which processes the report/subscription request.

No comments:

Post a Comment

T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...