SharePoint 2010 Service Applications

Mother and boy - 50s advertisingI can never remember which of those pesky Service Applications support cross-farm publishing (federation), which ones can be partitioned, and so on. So here's a handy table to cut out and keep, showing each one and what it can do.

In order to create a neat, compact table I have had to make up some abbreviated headings. So 'Cache' means the data is cached somewhere, 'DB' means it has its own database and 'SKU' indicates the minimum version of SharePoint required for the service application. 'Fed' means that it can be federated to other farms, 'Part' means that it can be used in partitioned mode (multi-tenant) and 'TD' indicates whether the service application stores tenant data.


Service ApplicationFedPartTDDBCacheSKU
Access ServicesEnterprise
Business Data ConnectivityFoundation
Excel ServicesEnterprise
FAST for SharePointEnterprise + FAST
InfoPath FormsEnterprise
Managed MetadataStandard
ProjectEnterprise + Project
Secure StoreStandard
Security Token ServiceFoundation
State ServiceStandard
Subscription SettingsFoundation
Usage and Health Data CollectionFoundation
User ProfileStandard
Visio GraphicsEnterprise
Web AnalyticsStandard
Word AutomationStandard
Word ViewingFoundation