Create a New Safe Data Provider
Scenario/Problem: You need to create a new safe data provider for Excel Services.
Solution: Use the New-SPExcelDataProvider
cmdlet.
The New-SPExcelDataProvider
cmdlet can be used to create a new safe data provider that Excel workbooks can access via a data connection. Provide the provider information and the Excel Services Application instance, as shown in Listing 21.9.
New-SPExcelDataProvider-ExcelServiceApplication "Excel Services Application"-ProviderID "Custom DB" -ProviderType ODBC
The -ProviderID
is an identifier for the data provider. The -ProviderType
can be any of the following values:
• OLEDB
• ODBC
• ODBCDSN
Tip
Verify third-party data provider documentation ...
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.