PowerShell™ for SharePoint® 2013 How-To

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.

Listing 21.9. Creating a New Safe Data Provider

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