Something New at the Office

Microsoft officially launched a staggering number of new products,including Windows Vista and the Microsoft Office System 2007, onNovember 30, 2006. Several of theseproducts were upgrades of previousreleases; however, a significant number ofnew Office servers were included in theOffice 2007 release.

Cynics might suggest that the newOffice server products are Microsoft's wayof squeezing more revenue out of the Officeproduct line, which is already installed onnearly every information worker's computer.Revenue certainly would have been a consideration for Microsoft. However, manybusinesses need the solutions that the new Office servers offer to accommodatethe changes in the way today's information workers do business. Businesses andtheir partners, customers, and end usersare now demanding collaboration solutions,automated business processes, auditingand compliance, and access to information anytime and anywhere.

In the current Office client suite, there aremany applications—and not all of them areappropriate for every business, scenario, oruser. For example, many users never haveto use Microsoft Access or Microsoft OfficePublisher, although few can do their jobswithout using Microsoft Word or MicrosoftExcel. The same will hold true for the newOffice server applications. Each server product serves a specific need, and althoughsome tools (such as Microsoft OfficeSharePoint Server) will become ubiquitous,others (such as Microsoft Project Server) willprobably be limited to a niche in the market.

Most companies will find that one ormore of these server products can deliverreal business value to their organizations.I've found that effective collaboration cangive a company a significant competitiveadvantage.

The problem has been that, until now,collaboration application solutions have typically been expensive both in terms of capital outlay for the software and training for endusers. These applications are also often difficult to integrate into existing business processes. In most cases, the early adoptersof collaboration solutions found there wasno return on their investments becausethey had to overcome significant obstaclesto successfully implement the tools or theend users didn't use the tools because thelearning curve was so high. If implementedinto your environment correctly, the newOffice servers can deliver the crucial balance of power and flexibility (for you) andfamiliarity (for your users) that can lead to a successful collaboration solution. To helpyou with the implementation, let's examineeach of the new Office server products—Forms Server 2007, Groove Server 2007,Project Server 2007, and SharePoint Server2007—so that you can understand theirpurpose and better evaluate their potentialrole in your business collaboration strategy.

Forms Server 2007
What business doesn't have forms?Many businesses use paper formswhose appearance and processinghaven't changed much in years. FormsServer 2007 is a standalone server thatdelivers and manages digital forms thatreplace paper forms and legacy onlineforms (such as fill-in PDF files). You canaccess the forms through Microsoft OfficeInfoPath 2007 or a Web browser for datacollection, distribution, and integrationwith processes using business rules.

Authorized users create forms usingInfoPath 2007. You can use controls(such as text boxes and drop-down lists)that Forms Server 2007 makes available. You can preconfigure the behaviorof each control. For example, you canpreconfigure mouse-over tips, prepopulated default values, and data validation.Additional behaviors connect the formand its controls with back-end systems,such as SharePoint Server 2007. You canthen place the forms into a SharePointServer 2007 or Microsoft BizTalk Server2006 workflow.

All of the heavy-lifting application codeand primary business logic rules are configured and executed on the server, whichmeans a form's creator or user can buildwhat he or she needs while developerscontrol the precise and complete integration of the form, its data business processes, and its workflows. As forms areupdated, new versions can be deployedside-by-side with reusable controls andbusiness logic.

You can use InfoPath 2007 (or otherthird-party applications) as a standaloneapplication to create electronic forms, butif multiple forms need to work togetherwithin a process or if external clients needaccess to those forms through a browser,you'll need IT to build a solution to support it. However, Forms Server 2007 caneasily move forms online, create workflows, and centralize data management.Keep in mind that you can host forms onSharePoint Server 2007, so take advantage of this ability if you're already using it. Forms Server 2007 is a standaloneproduct and cheaper than SharePointServer 2007, but it's for environments thatneed only the forms capability. I've foundthat the most difficult part of implementingForms Server 2007 is combining all thescattered paper and online forms into adefined business process. You'll need toinvest time to analyze your business andimplement a structure of forms, businesslogic, and workflows.

Groove Server 2007
If you've yet to select a set of tools to useto provide a collaborative workspace (oreven if you already have), you should takea look at Groove Server 2007. Groove2007 workspaces provide tools for filesharing, discussions, meetings, specialized calendars, and presence awareness (i.e., knowing who is online). Businessforms are available through InfoPath2007, with phone calls and IM availablewhen Groove Server 2007 is integratedwith Microsoft Office Communicator.Groove Server 2007 also lets you makeSharePoint Server 2007 sites availableoffline.

From a user's perspective, a Groove2007 workspace is simple to create andmaintain: With only a couple of clicks, youcan create a Groove 2007 workspace ona local computer. Users can then sharethat workspace with other users (thinkworkgroup), which is sufficient for small to medium-sized workspaces.

When the connection to external data sources and complexity of the workspace environment (e.g., size of the workspace, dispersion of clients) overload the decentralized workgroup environment, workspaces can be managed on the Groove server. This architecture lets you maintain data versions and update postings centrally, but lets users store their working copies locally. That means when users travel or work offsite, they don't have to be connected to Groove Server 2007 to work on documents, post discussion questions and comments, or add items to the workspace. The next time that users connect to Groove Server 2007, the updates on their computers are automatically synchronized to Groove Server 2007, and all other users' workspaces are updated on their local computers.

On the back end, there are several components that need to be configured properly to keep server-managed workspaces up-to-date while not bringing down the network (just kidding, but there is overhead to plan for). The Manager (for defining workspaces), Relay (for controlling site-type traffic), and Data Bridge (for connecting to Microsoft SQL Server or other databases) server components are all part of the infrastructure that supports workspaces. Collaboration tools have huge front-end productivity gains, so the resources that businesses invest usually have a significant ROI. The resources needed for Groove Server 2007 will also be compensated, to some degree, by users not having to email large attachments back and forth multiple times. For example, a Microsoft Office PowerPoint presentation can be edited locally and synchronized by Groove Server 2007, so that there aren't multiple versions of the presentation in multiple users' mailboxes on the mail server.

Groove was a successful application, even before Microsoft acquired Groove Networks in April 2005. There are clearly scenarios in which decentralized collaboration plays an important role. Certainly, some collaboration scenarios outside your network might be better supported by Groove Server 2007 than by a SharePoint Server 2007 extranet. Groove Server 2007's ability to make certain that SharePoint Server 2007 data is available offline might also be attractive to some users. At the lower levels of implementation, you can deploy Groove Server 2007 for users similarly to how you deploy Office and other user-productivity applications today.

When the workgroup model becomes overwhelmed or insufficient, you should develop a Groove Server 2007 topology. This article isn't the place for a detailed discussion, but a Groove 2007 implementation is similar to any other messaging implementation with load, relay, and storage considerations that need to be planned for. Microsoft Exchange Server 2007 provides even more integration possibilities. Developers will be glad to learn that the Groove 2007 workspace integrates with InfoPath forms and SharePoint Server 2007 document libraries to keep data consistent across high-level business processes. Although InfoPath forms and SharePoint Server 2007 document libraries are for users, administrators can use them for planning and defining those business processes.

Most businesses likely won't consider using Groove Server 2007 until after SharePoint Server 2007 has been rolled out. Even then, businesses will be wise to seek guidance from Microsoft or Groovesavvy IT consultants to properly implement Groove Server 2007 so that it meets their business needs.

Project Server 2007
Project Server 2007 extends the power of previous versions of Project Server and embraces more of the toolset that's used across the enterprise on the ground level, particularly Excel and Microsoft Office Outlook. For example, you can use Outlook to maintain tasks (such as progress, completion, and change schedule) and handle reports in Excel or Microsoft Office Visio that are dynamically tied back to the data on the Project Server. If a browser is more to users' liking, Microsoft Office Project Web Access and Project Workspace let users collaborate over the Web. It's always positive when users can facilitate high-level processes without a learning curve.

At higher levels of project management, the Cube Building Service enables you to use portfolio analyzer cubes for sophisticated analysis and reporting. Resource plans can show high-level resource allocation for categories of proposed projects without digging into unnecessary details. Timesheets now support fiscal periods and cost codes, and other financial fields that let you report hours separately from the progress made on tasks. You can also define deliverables, and those deliverables can cross projects. These additional functions are likely to increase Project Server 2007's attractiveness as a solution within part of the original collaboration solutions.

Project Server 2007 offers welcome improvements for developers. Now fully implemented on the Microsoft .NET Framework, it's not as difficult to reach Project Server 2007 from the outside, as the API now exposes all the functionality and data that client applications might need. Project Server 2007 also supports the Windows Workflow Foundation (WF), which allows for the integration of business processes defined and implemented within the context of other Office servers. From the performance side, the scheduling engine has been moved to the server, meaning that custom front ends no longer require the full executable (winproj.exe) on each machine.

With Project Server 2007, users will be able to manage their projects more easily within the context of familiar tools, project managers will get more features and better reporting capabilities, and developers will get easier access to data that used to be much harder to reach. If your organization already uses Microsoft Project, you can certainly expect Project Server 2007 to be part of your collaboration solutions, especially as demand for good reporting increases. (Note: Not every user needs to be a project manager to use Project Server 2007.)

SharePoint Server 2007
SharePoint Server 2007 is the "Mother Hen" that brings people and data together within defined contexts. What started several years ago as a document library and fledging communication tool has developed into a robust information portal. Although chances are that you've worked with SharePoint at some point, there are many new and improved features. SharePoint Server 2007 serves the following six business scenarios:

Portal. SharePoint Server 2007 supports designing, deploying, and managing enterprise intranet portals, corporate Internet presence Web sites, and divisional portal sites. The portal components also make it easy to connect to people who have the right skills, knowledge, and project experience.

Users get a personalized experience because of user profiles, audience targeting, presence awareness, and audience-appropriate views (such as My Manager and My Assistant). An LDAP-pluggable provider (in addition to the Active Directory—AD—provider) lets you securely access categorical information based on the various directory services that might be involved.

Enterprise Search. SharePoint Server 2007 lets you access data repositories across your enterprise and provide search results that are relevant to your enterprise and that respect security (i.e., only show results that you have permission to read). Think of Enterprise Search as an inhouse Google. (I can hear the shudders of folks at Microsoft as I compare Enterprise Search to Google, but they'll get over it.)

Content management, including documents, records, and Web content. What used to be a simple platform for document collaboration is now a full-featured solution for managing business documents and content. Going far beyond a simple repository for documents, SharePoint Server 2007's libraries are configurable for submission, review, approval, and signature processes surrounding any document, regardless of whether the document was created in an Office application or through a Web editor interface. These managed document libraries are controlled by templates that provide the business logic for controlling workflows, translating documents into any of the 28 supported languages, and rolling up documents into comprehensive reports.

Business processes. The client/server platform (InfoPath Form Services) enables you to create, deploy, and maintain centrally managed forms. Related data is XML-based, is Web accessible, and can be integrated into back-end business processes.

SharePoint Server 2007 provides access to defined data within a business process through single sign-on (SSO), which permits a user to enter only one username and password to use a variety of back-end applications in addition to those controlled directly by SharePoint Server 2007. Once authenticated, the business user has access to all configured forms within the workflow.

Forms are based on XML schemas that you define to control the structure of the data captured by the form, whether the form is created directly in InfoPath 2007 or imported from an existing Word or Excel document. A completed form is an XML file that complies with that structure, making it highly actionable. For example, a loan application form might include a main view for an applicant to fill in data using a browser and another view visible to only the loan officer, who reviews and approves the application.

Business intelligence. SharePoint Server 2007 enables you to develop Webbased business intelligence (BI) dashboards that can incorporate rich, databound Key Performance Indicators (KPIs), Web Parts, and published spreadsheets. Analysis is key for BI, and the familiar tool for business users is Excel, so it's not surprising that SharePoint Server 2007 heavily leverages it. SharePoint Server 2007 can refresh external data, recalculate workbooks, and render them with a high-fidelity, Web-based UI in an Excel Web Services Web Part. Based on publishing parameters, SharePoint Server 2007 can render a complete Excel 2007 workbook, select worksheets, or select a region within a worksheet.

Developers can use Excel Web Services to calculate a complex model built in Excel 2007 and display the results to a user working on a Web-based UI or custom desktop application. SharePoint Server 2007 includes out-of-the-box Web sites, that are hosted by the new Report Center, which has been optimized for report access and management. Integration and aggregation with SQL Server Reporting Services (SSRS) into a SharePoint Server 2007 Business Data Catalog extends reporting capabilities even further, making appropriate data readily available to the business user.

SharePoint Server 2007 gives you the ability to efficiently manage data for business processes, provide collaboration at numerous levels within team workflows, and secure access for all business users. Solid planning, a logical implementation strategy, and timely user training should result in a healthy ROI. But with six business scenarios covered by SharePoint Server 2007 alone, it's easy to get overwhelmed. Pick one or two scenarios that are most important to your business to focus on, but don't lose sight of SharePoint Server 2007's other capabilities because chances are good that as users experience SharePoint Server 2007, they'll start requesting solutions covered in the other scenarios.

SharePoint Server 2007 has the potential to unlock enormous productivity potential when aligned with business processes and strategies. Although the financial markets have been focused on how many copies of Windows Vista and Office 2007 Microsoft will sell, it's really SharePoint Server 2007 that's the stealth force.

What the New office Servers Mean for You
The Office 2007 servers focus on collaboration, and I think IT can (and should) expect this upgrade cycle of Office to go beyond a simple discussion of user-level features. Many businesses are at the tipping point for collaboration—it isn't just a good idea to have managed collaboration, it's necessary, and collaboration solutions require a great deal of planning beyond a normal upgrade of the desktop product. Your Office servers planning and implementation efforts will be similar to when you planned for directory services (i.e., going from the workgroup to the domain mentality).

The days of simply providing users with applications are over. The unique workflows in today's businesses involve data and people, and office tools need to be configured to meet the needs of those workflows. With an Office 2007 environment, you can make data available to the correct people, properly secure that data, and provide users with the tools they need to achieve their business goals. Early adopters of the Office 2007 collaboration tools are proving that the tools work well and that productivity gains are huge when you invest the time and resources needed for up-front planning and a good user-training program. SharePoint Server 2007 is necessary, and the supporting tools fill specific roles—you can expect high demand from both users and business owners for increased collaboration.