This is a second post on the topic of changes in Excel Services for SharePoint 2013.
Let’s look at the secure store service for SharePoint. This service was built for SharePoint 2010 as a replacement for the ” . . . Microsoft Office SharePoint Server 2007 Single Sign On feature. Secure Store Service is a shared service that provides storage and mapping of credentials such as account names and passwords.” (quoted from Secure Store Service on MSDN). As explained in this article on MSDN, the Secure Store Service can be used as a repository for credentials required by connected external systems. The examples in the article note how a SharePoint 2010 user can access an external CRM system, as well as SharePoint, itself by using the Secure Store Service, very much like a single sign on system.
As we noted in yesterday’s post on this topic, connections to external systems built with Secure Store Service should still be editable from a browser for SharePoint 2013. Therefore, organizations with a substantial commitment to SharePoint 2010 should plan on using the Secure Store Service for any connections to external systems. Should it make sense to migrate to SharePoint 2013, any business intelligence (BI) built with Excel Services for SharePoint should port successfully to SharePoint 2013.
The Secure Store Service is used with Business Connectivity Services (BCS). As noted in another article on MSDN, “It is very common for Microsoft Business Connectivity Services (BCS) solutions to try to authenticate to an external system in which the current user is known differently or has a different account for authentication. In such cases, the Secure Store Service can be used to store and map user credentials that are required by the external system. You can also configure the Secure Store Service so that multiple users can access an external system by using a single set of credentials on that external system.” (quoted from How to: Use Secure Store Service to Connect to an External System).
This service is accessible to no-code developers through SharePoint Designer 2010 and 2013. We will look further at the Secure Store Service in the next post to this blog.
© Rehmani Consulting, Inc. & Ira Michael Blonder, 2013 All Rights Reserved