Configure Excel Services data access by using external data connection
Configure data access account - Log on to AD server, and create an account to access data source. Example: ExcelODCAccess Grant Read access to data source Set the Db_datareader to data source Configure Secure Store Services In the Secure Store target application, we will map a specific AD Group to the ExcelODCAccess account, Excel Services will use this account on their behalf to refresh data-connected workbooks. - Create an AD Group on AD Server, example: ExcelODCAccessGroup - Add accounts to this AD Group: User1, User2 Create a target Application on Secure Store Services - Open SharePoint 2010 Central Administration –> Application Management –> Manage Service Applications - Open Secure Store Service - New - Configure New Secure Store Service Target Application - Next Associate the account (ExcelODCAccess) use to access data source to Target Application - Set Credentials Create and publish an ODC file - Open Excel 2010 from a client PC and create a connection to ...