How MOSS 2007 integrates with other Microsoft products

July 9, 2009


MOSS and Office 2007

The Microsoft Office 2007 applications are based on open XML standards, enabling SharePoint to integrate with them more easily.

Outlook 2007: SharePoint contact management, task management, email management, and event/meeting management is fully integrated into Outlook, including full two-way synchronization.  Outlook can also be used to take SharePoint lists and document libraries offline.

Excel 2007: With Excel Services (included with MOSS Enterprise), Excel workbooks can be stored in a central location, and data from these workbooks can be access from MOSS webpages.  Custom applications can be built to access Excel 2007 calculation services.  This functionality is the basis for MOSS business intelligence solutions.\

Word 2007: Tighter integration of document metadata, via Word’s Quick Parts.  Integrates with documentation management features, such as check-in/check-out, versioning.  Integrated blogging.

Access 2007: Access databases can be moved to SharePoint sites.  Access creates a front-end application for the database including forms and reports.  Access forms and reports can be accessed then from SharePoint.  Databases can be created from SharePoint lists.  Access also provides offline access to SharePoint lists.

OneNote 2007: OneNote notes can be published directly to SharePoint sites, as OneNote files or as PDF, web pages, or Word documents.

InfoPath 2007: Use InfoPath to create forms to publish to SharePoint sites. MOSS acts as a Forms Server.  (Enterprise MOSS only).  Note:  You can also create forms that are accessible via Blackberry.

MOSS and Office Communicator 2007

With Office Communicator 2007, MOSS allows you to see inside of SharePoint what users are online and allows you to chat with them.

MOSS and Exchange 2007

You can directly email document libraries.  Email can be archived in a records repository.  Email retention.  Instead of attaching a document to an email message, users can link to the document in the message.   Outlook Web Access web parts.

MOSS and Active Directory

Users can be authenticated through Active Directory.  Information from AD can be pulled into SharePoint (job titles, departments, email addresses, contact details, organization structures).

MOSS and SharePoint Designer 2007

Use SharePoint Designer to edit SharePoint sites, page layouts, and appearances.  Add and configure custom controls and web parts.  Incorporate custom workflows and data-driven forms.

MOSS and Project Server 2007

MOSS itself contains Project Server as part of the Enterprise version.  If you already have Project Server 2007, though, MOSS can integrate Project Server with the Windows Workflow Foundation, document libraries, search capability and team work site orientation.  MOSS’s list feature “Project Tasks” is unrelated to Project Server.

MOSS and Groove Server 2007

Integration with MOSS allows Groove users to manage Groove spaces by team and make SharePoint’s document libraries accessible as Groove data with the same security.

Do you have any other integrated features to add to the list?