PowerShell™ for SharePoint® 2013 How-To

Create a New Safe Data Provider

Scenario/Problem: You need to create a new safe data provider for Visio Graphics Services.

Solution: Use the New-SPVisioSafeDataProvider cmdlet.

The New-SPVisioSafeDataProvider 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 Visio Graphics Service instance, as shown in Listing 24.2.

Listing 24.2. Create a New Safe Data Provider

New-SPVisioSafeDataProvider -VisioServiceApplication "Visio GraphicsService" -DataProviderID "Custom DB" -DataProviderType 6

-DataProviderID is an identifier for the data provider. -DataProviderType can be any of the following integer values:

1 - OLE DB

2 - SQL Server

3 - ODBC

4 -