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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access