Microsoft Office Tutorials and References
In Depth Information
Microsoft Office SharePoint Server
Office SharePoint Server provides the core storage, security, and administration framework. Beyond
these, it includes a core set of six integrated capabilities:
Collaboration — Document, task, and calendar sharing, and support for blogs and wikis
Portal — Enterprise portal templates, personalization, news and content aggregation, and social
Content Management — Core document management (for example, check-in, check-out, and
versioning), records management, and web content management
Search — Enterprise-level search, including contextual relevance and rich people and data searching
Business process and forms — Web-based forms and line-of-business application integration
Business Intelligence — Dashboards, key performance indicator lists, report libraries, and
web-based spreadsheets through Excel Services
As you can see, Office SharePoint Server is an extremely rich product. Each one of the six areas could
be the subject of an entire topic unto itself. This topic does not attempt to cover all the functionality
provided by Office SharePoint Server, neither in breadth nor in depth. The focus is Excel Services.
With that said, Excel Services is an integral part of Office SharePoint Server, and, as such, the solutions
to the needs described earlier rely on many of the other capabilities of the product. This topic will freely
cross the line between features that are specific to Excel Services and features that are part of the Office
SharePoint Server as a whole. The distinction is of no significance, because one set of features does not
exist without the other.
As the name suggests, the heart of Office SharePoint Server is what used to be known as Microsoft
SharePoint Portal Server. This is Microsoft’s portal offering. Like SharePoint Portal, Office SharePoint
Server is based on and requires Windows SharePoint Services. Windows SharePoint Services provide
the base storage repository, document (and workbook) management functionality, as well as the
enduser and administrator web user interface. Windows SharePoint Services also provides the base
programmability and extensibility model for developing custom web-based applications, which in turn
is based on ASP.NET 2.0.
In Office 2007, both Windows SharePoint Services and the technology for SharePoint Portal Services are
new versions with new functionality. In addition to these core technologies, Office SharePoint Server
integrates what used to be the Content Management Server for web content management, the new Forms
Server functionality for web-based forms and forms management, and Excel Services. Together, these
provide the platform and capabilities described. The following sections cover a few of the core capabilities
and key Office SharePoint Server concepts in more detail.
Office SharePoint Server provides two fundamental building blocks for security: authentication and
authorization. A user or application looking to calculate and view a workbook with Excel Services is first
authenticated through Office SharePoint Server. The authentication is based on ASP.NET 2.0
authentication, and a number of methods are supported. These include Windows-based authentication,
formsbased authentication, and anonymous access. The authentication model is pluggable, and third-party
authentication solutions such as Lightweight Directory Access Protocol (LDAP) directories can be used.