Export (0) Print
Expand All

Configure Visio Graphics Service trusted data providers in SharePoint Server 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013

Topic Last Modified: 2014-07-07

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

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

Default trusted data providers for the Visio Graphics Service

Description ID Type

SQL Server OLE DB Driver (MDAC)

SQLOLEDB

1

SQL Server OLE DB Driver (MDAC SQL Server 2000)

SQLOLEDB.1

1

SQL Server ODBC Driver (MDAC)

SQL Server

3

SQL Server ODBC DSN Driver (MDAC)

SQL Server

4

SQL Server OLE DB DSN Driver for ODBC

SQLOLEDB.1

4

SQL Server OLE DB Driver (SNAC)

SQLNCLI

1

SQL Server OLE DB Driver (SNAC SQL Server 2005)

SQLNCLI.1

1

SQL Server ODBC Driver (SNAC)

SQL Native Client

3

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

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 SharePoint Server 2013.

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

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 the SharePoint Central Administration website.

NoteNote:
Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Before you begin this operation, review the following information about prerequisites:

  • You must be a member of the farm administrators group or a Visio Services service application administrator.

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 or a Visio Services service application administrator.

  2. Start SharePoint 2013 Central Administration.

    • For Windows Server 2008 R2:

      • Click Start, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Central Administration.

    • For Windows Server 2012:

      • On the Start screen, click SharePoint 2013 Central Administration.

        If SharePoint 2013 Central Administration is not on the Start screen:

      • Right-click Computer, click All apps, and then click SharePoint 2013 Central Administration.

  3. On the Central Administration Home page, in the Application Management section, click Manage service applications.

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

  5. Click Trusted Data Providers.

  6. Click Add a new Trusted Data Provider.

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

    A description of the Trusted Data Provider type

  8. 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 or a Visio Services service application administrator.

  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 or a Visio Services service application administrator.

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

  4. Click SharePoint 2013 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 2013 Products.

  4. Click SharePoint 2013 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 2013 Products.

  4. Click SharePoint 2013 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft