Microsoft Office SharePoint Server 2007 helps organizations provide business intelligence (BI) capabilities to every employee so they can share, control, and reuse business information to make better business decisions. The BI features in Microsoft Office SharePoint Server 2007 provide Web and programmatic access to published Office Excel spreadsheets, programmatic reuse of critical LOB data, and easy development of Web-based BI dashboards that can incorporate rich, data-bound KPIs, Web Parts, and published spreadsheets.

Top Features at A Glance:

  • Web Access to Published Spreadsheets
  • Integrated, Flexible Publishing
  • Programmatic Access to Published Spreadsheets
  • Data Connection Libraries
  • Business Data Catalog
  • Business Data SharePoint Lists and Web Parts
  • Business Data Actions
  • Data Connection Libraries
  • KPIs/Dashboards
  • Report Center Web Sites
  • Excel Services Management
  • BI Web-Parts
  • Server-based Excel spreadsheets and data visualization

For the first time ever, Microsoft Office SharePoint Server 2007 enables users to create forms, populate them with data from business applications, publish them on the Web, and initiate document-oriented workflows – all that directly from their familiar Microsoft Office user interface or from within their Internet Browser.

Top Features at A Glance:

  • Deploy and manage forms centrally
  • Integrate forms with Outlook 2007
  • Import forms· Digitally sign forms
  • Create forms without coding
  • Integration with business applications

The new and enhanced content management capabilities in MS Office SharePoint Server 2007 comprise three areas:

  • Document Management
  • Records Management
  • Web Content Management

Windows SharePoint Services provides core document management functionality: major and minor versioning, check-in/check-out document locking, rich descriptive metadata, workflow, content type–based policies, auditing, and role-based-access controls at the document library, folder, and individual document levels.

Office SharePoint Server 2007 builds on these capabilities to deliver enhanced authoring, business document processing, Web content management and publishing, records management, policy management, and support for multilingual publishing.

Top Features at A Glance:

  • Web content editor and in-context authoring
  • Authoring processes (traditional)
  • Enterprise-wide layout templates
  • Scalability
  • Integration with business applications
  • Enterprise-wide metadata management
  • Enterprise-wide templates for all types of content
  • Integration with Office 2007 through a task bar and information panel
  • Version control, check-in/check-out
  • Document workflows (to be customized with MS Office SharePoint Designer)
  • Integration with business applications
  • Tamperproof repository storage
  • Integration of  “e-mails as records”
  • Policy definition and monitoring/auditing

The 2007 Microsoft Office System, also known as Microsoft Office 2007, is the most recent version of our productivity suite. Formerly known as Office 12 in the initial stages of the beta cycle, we are scheduled to be make the suite available to volume license customers on November 30, 2006, with general availability following in early 2007. Office 2007 contains a number of new features, the most notable of which on the surface of it is the entirely new graphical user interface called the Ribbon, replacing the menus and toolbars that have been the cornerstone of Office since its inception.

Office 2007 also includes new applications and server-side tools which is where the real changes have been made. Chief amongst these is Groove, a collaboration and communication suite which was originally developed by Groove Networks before being acquired by Microsoft in 2005. Also included is Office Sharepoint Server 2007, a major revision to the server platform for Office applications, which supports “Excel Services”, a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.

My earlier posts on the the Versions and SKU’s covers the capabilities in more detail and details the main solution areas we address such as Content Management, Enterprise Project Management, Business Inteligence and Electroinc forms and Automated workflow.

The 2007 release includes sophisticated IRM capabilities and policy controls designed to help organizations safeguard digital information from unauthorized use. Through integration with Windows Rights Management Services (RMS) for Microsoft Windows Server 2003, these IRM features enable information workers to define exactly how recipients can use the information contained in Microsoft Office documents.

Specific features include:

·     Information Rights Management. In conjunction with Windows RMS, the IRM features of the 2007 release enable users to define exactly who can open, modify, print, forward, and/or take other actions with the information in Microsoft Office documents.

·     Policy Statements. Organizations can create policy statements for specific e-mail message types and embed these statements in the e‑mail message. Policy statements can instruct the reader how to handle the email message content or serve as a flag to trigger Microsoft Exchange Server 2007 to process custom-defined rules. Table 2:  Information Rights and Policy Management Capabilities 

Capability

Microsoft Office Standard 2007

Microsoft Office Professional Plus 2007

Microsoft Office Enterprise 2007

Create IRM protected documents and e-mail messages. Grant access and editing permissions and apply policy templates to protected content.*

  P P

Read and use IRM-protected documents and e-mail messages, given appropriate rights.*

P P P

Apply policy statements to e-mail messages before sending.*

  P P

Read policy statements associated with received e-mail messages.

P P P
*Requires Windows Rights Management Services for Windows Server 2003.

The 2007 release streamlines data collection through integration between InfoPath 2007 and the core applications. Electronic forms can be presented as standalone forms in the InfoPath 2007 client or in the browser, imported into Groove 2007 workspaces, embedded in Document Information Panels and Task Panes, or embedded in Outlook 2007 e-mail messages so colleagues can complete forms without leaving the familiar Outlook environment. With InfoPath 2007 and Microsoft Office InfoPath Forms Services, organizations can also extend electronic forms solutions outside the corporate firewall, enabling customers, business partners, and mobile or remote users to complete electronic forms using many different Web browsers and mobile devices.

Features that take advantage of InfoPath 2007 forms include:

·     E-Mail Forms. The ability to embed an InfoPath form within an Outlook 2007 e-mail message provides a fast, efficient way to collect information.

·     Developer enhancements. Enhanced development capabilities enable developers to display richer content, including InfoPath forms, within custom Task Panes.

·     Document Information Panel. Support for InfoPath forms within the new document Information Panel enables organizations to define custom document properties and to initiate business processes from within a document based on those document properties.

Table 4:  Advanced Support for Electronic Forms Capabilities

Capability

Microsoft Office Standard 2007

Microsoft Office Professional Plus 2007

Microsoft Office Enterprise 2007

Complete, collect, and organize InfoPath 2007 e-mail forms in Outlook 2007.*

  P P

Host embedded, fully customizable InfoPath forms in Word 2007, Excel 2007, and PowerPoint 2007.*

  P P

Complete forms in Programmable Task Panes.*

  P P

Complete custom fields and execute custom business logic in Document Information Panel forms.*

  P P
*These capabilities require that InfoPath 2007 be installed on the client computer. Office Professional Plus 2007 and Office Enterprise 2007 include InfoPath 2007. Organizations that license other suites can purchase and install InfoPath 2007 separately.