11:28 AM

Microsoft SharePoint 2010 Workflow User's Guide

Office 2010 can act as the front-end to a full-featured enterprise content management solution using the metadata and workflow capabilities of SharePoint 2010.

Microsoft Office 2010 In Pictures
(click image to view gallery)
Microsoft Office 2010 In Pictures
Let's revisit the aforementioned example with a deployment of SharePoint Foundation 2010, a free version of SharePoint that works with a licensed copy of Windows Server 2008 and Microsoft SQL Server. You'll start by installing a server farm containing a database server and a web server. Within the web server, which will have its own URL for use only within the company intranet, you'll set up what's called a "Site Collection," with its first site containing one item, your original list of retail outlets. That's five levels of hierarchy if you're keeping track (server farm -> web server -> site collection -> site -> list), just to replicate information that used to reside within a single Excel file.

But now, you'd have a scalable infrastructure that could easily incorporate other sources of data -- both structured and unstructured -- into a comprehensive enterprise repository. In SharePoint 2010, a list can contain not just text and numbers, but also multimedia elements including audio and video, Office 2010 documents, and other binary objects.

Out of the box, a SharePoint installation includes blogs, wikis, team workspaces and document libraries. You can set item-level permissions, enable employees to check documents in or out, and have the ability to retrieve previous versions of documents for auditing and revision control. From within Office 2010, your users would be able to create their own lists and store their own documents online, your department managers could create their own sites, and your IT department can deploy new site collections as needed. Although moving that first list to SharePoint may take significant effort, building successive lists and sites gets easier and easier.

Furthermore, because the underlying data is being stored on the enterprise server farm instead of on an isolated PC, you can easily point external and mobile users to versions of shared data. You'd be able to create a parallel list containing just the data elements that you want to make public. That list would be contained within a site collection on an externally-facing web server, tapping into the shared database server on the enterprise server farm.

However, this transition from the private intranet to the public internet does require an upgrade to SharePoint Server 2010. There's only so far you can go with the free version of SharePoint, and if you're truly taking an ECM (enterprise content management) approach you'll hit the limits soon enough (see the comparison chart for details).

2 of 5
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
InformationWeek Elite 100
InformationWeek Elite 100
Our data shows these innovators using digital technology in two key areas: providing better products and cutting costs. Almost half of them expect to introduce a new IT-led product this year, and 46% are using technology to make business processes more efficient.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of July 17, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.