Sunday, November 8, 2009

Why? SharePoint (WSS/ SPS) is the place for end users to access corporate information.

Why? SharePoint (WSS/ SPS) is the place for end users to access corporate information.


--> Customers need to expose this corporate information from many data sources into a single coherent view. SPS and Office Server provide the single coherent view via the BI Portal. Reporting Services is the means to exposing this critical corporate information in the BI Portal.

Report Center – Central Storage for business reports.

SQL Server 2005 Reporting Services SP2 is integrated with Windows SharePoint Services to enable seamless publishing, viewing, and management of reports

-Report server namespace and security is hosted in WSS content database
-Report Server database used for additional metadata (schedules, caching, subscriptions)
-WSS DB used for storing Report Server items – reports, data sources, models, resources etc.

No comments: