SQL Server Reporting Services Integration with SharePoint
Written By: Abin Jaik Antony -- 10/20/2010 --
(4643) comments --
Categories: Configurations, Integration with other products , MOSS 2007, WSS3
< Prev -
- Next >
| Become a paid author
The scope of this tip is to explain the architecture, configuration & deployment
of SSRS in SharePoint integration Mode.
Before going directly into the configuration, we can have a look into the architecture . This will help us to understand it deeply.
SSRS architecture in Native Mode and in SharePoint integration Mode.
The SQL Servers Reporting Services architecture have mainly 3 parts /layers
- Data Layer
- Application Layer
- Client Layer
The Data layer consists of the Base Data Sources like data warehouse / transactional
DB / Analysis Services Cube , Report Server Databases etc.
The Application layer consists of Reporting Services, Report Manager , Web Services
The Client Layer can be any front end like SharePoint web parts or
other front end tools.
After the deployment of reports from BIDS (Business Intelligence Development Studio) , the .rdl (report definition language)
files and the shared data sources will be stored inside Report Server
database. On the request
for any report from a Client , the request passes to the Report Manager and
within Report Services from the fetched data of Data Sources. The generated
report is returned to the Client from the Application Server as HTML/XML/PDF.
Basically there are two modes for configuring SSRS.
- Native Mode
- SharePoint Integration Mode.
The outline architecture for Native Mode is explained
above. This article will review SharePoint integrated mode's configuration , architecture
Before configuring the Report Server in SharePoint Integration Mode ,let's make sure that server is installed with
the Report Services Add – in (on the SharePoint
Server) and SQL Server SP2 (on database the server).
In SharePoint Integrated mode, the architecture is a little different from
Native mode. The reports definition
files and Data Sources are stored in the SharePoint Content database Also, there is no
concept of “Report Manager” in SharePoint Integrated mode since it is deployed to
the SharePoint Reports Library. Security trimming for reports is handled
using standard SharePoint permisions.
In SharePoint Integrated mode, when a user makes a request for a particular
report, the Report Server Proxy Endpoint will take care of the report processing
from SharePoint along with Report Services to return the rendered result.
< Prev -
- Next >