Review: Redmond Outgrows Portal

With MOSS, applications with thousands of connections can quickly scale out by using many database instances on multiple Microsoft SQL Servers. Similarly, a multitier enterprise application running thousands of processes can benefit greatly because it can run many databases and funnel its data through a single master site collection.

Site collections are also convenient when integrating workflows from multiple Web applications. Each Web application can point to the same server or multiple servers and databases. Essentially, site collections are systemwide groups of applications. Therefore, MOSS can be used as a platform for building entire systems.

It's also possible to have two site collections point to the same database, so different Web sites can point to the same data. One common use for sharing a database is when a secured intranet site needs to pass information to an Internet site. Instead of passing data between two databases, developers can simply update separate tables from a single database.

To speed up Web site design and creation, Microsoft Office SharePoint Server 2007 arrives with a feature called Shared Services Provider, which can replicate common features from site collections every time they are generated. For instance, personalization features that use Microsoft Active Directory properties, search services and even Web Parts can be defined as shared services within SharePoint. Developers can use the shared services provider mechanism to reuse features across multiple applications.

One of SharePoint's best shared services is the Business Data Catalog (BDC), which simplifies the way data is passed between different resources and applications. The BDC provides access to structured data through an XML application definition file, which describes the structure of a data source and displays it in rows and columns.

Essentially, developers can connect the BDC to any data source that uses ADO.Net source or call a Web service. SharePoint arrives with Web Parts that will display BDC data, allowing Web sites and applications to share any data securely and quickly. However, not all relationships between data sources are mapped automatically by Web Parts.

BDC data is rendered through Web Parts and lists. A list column can also be created to collect data from a BDC. The automation allows end users to use this feature. Developers can open up data collections to end users that need to work with long lists. This is an easy way for developers to set up a work site without delving into Web site formatting.

Microsoft has one of the best IT training and certification programs on the market. The company's Web-based training is free for all partner levels and advanced classroom training typically costs $500 to $700 per week.

Microsoft states that partners can earn about seven times more than the cost of the licensing. Certified partners can also receive Visual Studio 2005 Professional, early betas, demo toolkits and other professional packages. In addition, qualifying partners receive business toolkits, presales, technical and critical phone support.

All in all, with its simplified deployment and development processes, SharePoint 2007 offers channel partners a quick way to build complex applications while leaving plenty of room for services opportunities.