Configure Visio Graphics Service trusted data providers (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010

Summary: The Visio Graphics Service trusted data providers can be provisioned through Central Administration or with Windows PowerShell.

Trusted data providers

By default, the following trusted data providers are trusted by the Visio Graphics Service:

Description ID Type

Microsoft SQL Server OLE DB Driver (MDAC)

SQLOLEDB

1

Microsoft SQL Server OLE DB Driver (MDAC SQL Server 2000)

SQLOLEDB.1

1

Microsoft SQL Server ODBC Driver (MDAC)

SQL Server

3

Microsoft SQL Server ODBC DSN Driver (MDAC)

SQL Server

4

Microsoft SQL Server OLE DB DSN Driver for ODBC

SQLOLEDB.1

4

Microsoft SQL Server OLE DB Driver (SNAC)

SQLNCLI

1

Microsoft SQL Server OLE DB Driver (SNAC SQL Server 2005)

SQLNCLI.1

1

Microsoft SQL Server ODBC Driver (SNAC)

SQL Native Client

3

Microsoft SQL Server ODBC DSN Driver (SNAC)

SQL Native Client

4

Oracle Provider for OLE DB

OraOLEDB.Oracle.1

1

Oracle ODBC Driver for Oracle 9.2

Oracle in OraHome92

3

Oracle ODBC DSN Driver for Oracle 9.2

Oracle in OraHome92

4

IBM OLE DB Provider for DB2

IBMDADB2

1

IBM DB2 ODBC Driver

IBM DB2 ODBC DRIVER

3

IBM DB2 ODBC DSN Driver

IBM DB2 ODBC DRIVER

4

Microsoft SQL ODBC Driver

MSDASQL.1

3

Microsoft SQL ODBC DSN Driver

MSDASQL.1

4

Microsoft SharePoint List

WSSList

5

Excel Web Services

Microsoft.Office.Visio.Server.EcsDataHandler, Microsoft.Office.Visio.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c

6

Data Provider ID

The Data Provider ID is the name of the driver that acts as the data provider. This ID must be the same ID that is used to reference the data provider in a connection string. The driver for the data provider must be installed on every application server that is running the Visio Graphics Service. Once you have installed the driver on your application servers, you can add it as a trusted data provider in Visio Services in Microsoft SharePoint Server 2010.

Data Provider type

When adding a new trusted data provider, the data provider type must be one of the following values:

Number Type

1

OLE DB

2

SQL

3

ODBC

4

ODBC with DSN

5

SharePoint Lists

6

Custom Data Provider

Data Provider description

The data provider description is a friendly name that appears in the Trusted Data Providers section of the Manage the Visio Graphics Service page in SharePoint Central Administration.

Creating, editing, and deleting trusted data providers

The following steps show how to create a Visio Graphics Service service application.

To create a Visio Graphics Service trusted data provider by using Central Administration

  1. Verify that you have the following administrative credentials:

    • To create a trusted data provider, you must be a member of the farm administrators group.
  2. On the Central Administration Home page, in the Application Management section, click Manage service applications.

  3. Click the Visio Graphics Service service application where you want to create the trusted data provider.

  4. Click Trusted Data Providers.

  5. Click Add a new Trusted Data Provider.

  6. Enter values for the following parameters:

    Parameter Description

    Trusted Data Provider ID

    The Trusted Data Provider ID

    Trusted Data Provider Type

    The Data Provider type

    Trusted Data Provider Type Description

    Description of the Trusted Data Provider type

  7. Click OK.

To edit a Visio Graphics Service trusted data provider by using Central Administration

  1. Verify that you have the following administrative credentials:

    • To edit a trusted data provider, you must be a member of the farm administrators group.
  2. In Central Administration, under Application Management, click Manage service applications.

  3. Click the Visio Graphics Service service application where you want to edit the trusted data provider.

  4. Click Trusted Data Providers.

  5. Select the data provider that you want to edit, and from the drop-down menu select Edit Trusted Data Provider.

  6. Edit the settings that you want, and then click OK.

To delete a Visio Graphics Service trusted data provider by using Central Administration

  1. Verify that you have the following administrative credentials:

    • To delete a trusted data provider, you must be a member of the farm administrators group.
  2. In Central Administration, under Application Management, click Manage service applications.

  3. Click the Visio Graphics Service service application where you want to delete the trusted data provider.

  4. Click Trusted Data Providers.

  5. Select the data provider that you want to delete, and from the drop-down menu select Delete Trusted Data Provider.

To create a Visio Graphics Service trusted data provider by using Windows PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:

    New-SPVisioSafeDataProvider -DataProviderId <ProviderID> -DataProviderType <Int32> -VisioServiceApplication <VisioServiceApp>

For more information, see New-SPVisioSafeDataProvider.

To edit a Visio Graphics Service trusted data provider by using Windows PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:

    Set-SPVisioSafeDataProvider -DataProviderId <ProviderID> -DataProviderType <Int32> -Description <String> -VisioServiceApplication <VisioServiceApp>

For more information, see Set-SPVisioSafeDataProvider.

To delete a Visio Graphics Service trusted data provider by using Windows PowerShell

  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.

  2. On the Start menu, click All Programs.

  3. Click Microsoft SharePoint 2010 Products.

  4. Click SharePoint 2010 Management Shell.

  5. From the Windows PowerShell command prompt (that is, PS C:\>), type the following command and press ENTER:

    Remove-SPVisioSafeDataProvider -DataProviderId <ProviderID> -DataProviderType <Int32> -VisioServiceApplication <VisioServiceApp>

For more information, see Remove-SPVisioSafeDataProvider.

See Also

Concepts

Visio Services in SharePoint Server 2010 knowledge articles
Configure Visio Graphics Service global settings (SharePoint Server 2010)