PowerShell™ for SharePoint® 2013 How-To

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.

Listing 21.5. Creating a New Trusted Data Connection Library

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, ...