Remove a Trusted Data Connection Library

Scenario/Problem: You need to remove a trusted data connection library from Excel Services.

Solution: Use the Remove-SPExcelDataConnectionLibrary cmdlet with a trusted data connection library variable.

The Remove-SPExcelDataConnectionLibrary cmdlet enables you to remove a specific trusted data connection library from Excel Services. Use this in conjunction with the Get-SPExcelDataConnectionLibrary cmdlet (explained in a previous section), as shown in Listing 21.8.

Listing 21.8. Sample Script for Removing a Trusted Data Connection Library

$trustedLibrary = Get-SPExcelDataConnectionLibrary-Identity "http://sp2010/Data Connections"-ExcelServiceApplication "Excel Services Application"Remove-SPExcelDataConnectionLibrary ...

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.