Create a Trusted Data Connection Library
Scenario/Problem: You need to create a new trusted data connection library for Excel Services.
Solution: Use the New-SPExcelDataConnectionLibrary
cmdlet.
The New-SPExcelDataConnectionLibrary
cmdlet can be used to create a new trusted data connection location that Excel workbooks can access. Provide the address of the data connection library and the Excel Services Application instance, as shown in Listing 21.5.
New-SPExcelDataConnectionLibrary-Address "http://sp2010/Data Connections"-ExcelServiceApplication "Excel Services Application"
Upon successful creation of the new trusted data connection library, a summary of the properties is displayed, ...
Get PowerShell™ for SharePoint® 2013 How-To now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.