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
Verify that you have the following administrative credentials:
- To create a trusted data provider, you must be a member of the farm administrators group.
On the Central Administration Home page, in the Application Management section, click Manage service applications.
Click the Visio Graphics Service service application where you want to create the trusted data provider.
Click Trusted Data Providers.
Click Add a new Trusted Data Provider.
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
Click OK.
To edit a Visio Graphics Service trusted data provider by using Central Administration
Verify that you have the following administrative credentials:
- To edit a trusted data provider, you must be a member of the farm administrators group.
In Central Administration, under Application Management, click Manage service applications.
Click the Visio Graphics Service service application where you want to edit the trusted data provider.
Click Trusted Data Providers.
Select the data provider that you want to edit, and from the drop-down menu select Edit Trusted Data Provider.
Edit the settings that you want, and then click OK.
To delete a Visio Graphics Service trusted data provider by using Central Administration
Verify that you have the following administrative credentials:
- To delete a trusted data provider, you must be a member of the farm administrators group.
In Central Administration, under Application Management, click Manage service applications.
Click the Visio Graphics Service service application where you want to delete the trusted data provider.
Click Trusted Data Providers.
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
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
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
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
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
Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
On the Start menu, click All Programs.
Click Microsoft SharePoint 2010 Products.
Click SharePoint 2010 Management Shell.
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)