Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

Configuring Data Retrieval Services

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

A data retrieval service implements a new data-binding technology that enables data consumers and data sources to communicate with each other through SOAP and XML. Data retrieval services are XML Web services that return XML data from different data sources. A data retrieval service is installed and runs on a server extended with Microsoft .comes with a default set of data retrieval services for working with data in SharePoint lists, OLEDB, and XML data sources. Client applications and data-bound Web Parts, such as the Spreadsheet Web Part, can use a data retrieval service to query the data source supported by the particular data source.

Note: If your data retrieval service is attempting to connect to a remote Microsoft SQL Server database that is configured to use Microsoft Windows authentication, the server with the data retrieval service, the remote server running SQL Server, and the client initially making the request against the data retrieval service must be using Kerberos authentication. For more information about setting up Kerberos authentication, see the Help system for Internet Information Services (IIS) 6.0.

Configuring Data Retrieval Services from HTML Administration

You can enable or disable data retrieval services and configure settings for data retrieval services for an entire server or server farm by using the SharePoint Central Administration page.

Enable data retrieval services and configure settings for a server or server farm

  1. On the SharePoint Central Administration page, under Component Configuration , click Configure data retrieval services settings .

  2. On the Data Retrieval Services Settings page, in the Enable Data Retrieval Services section, select Enable these data retrieval services .

  3. In the Limit Response Size section, in the Response size limit box, specify the size, in kilobytes (KB), to use as the upper size limit for responses from the data retrieval services.

  4. To allow updatable queries, in the Update Support section, select the Enable update query support checkbox.

  5. In the Data Source Time-out section, in the Request time-out box, specify the length of time to allow the data retrieval service to respond before timing out, in seconds.

  6. Click OK .

You can also use HTML Administration pages to specify settings for a particular virtual server.

Enable data retrieval services and configure settings for a virtual server

  1. On the SharePoint Central Administration page, under Virtual Server Configuration , click Configure virtual server settings .

  2. On the Virtual Server List page, click the name of the virtual server that you want to configure.

  3. On the Virtual Server Settings page, under Component Configuration , click Configure data retrieval service settings .

  4. On the Data Retrieval Service Settings page, in the Customize Virtual Server section, clear the Inherit the global settings checkbox to specify different settings for the virtual server.

  5. In the Enable Data Retrieval Services section, select Enable these data retrieval services .

  6. In the Limit Response Size section, in the Response size limit box, specify the size, in kilobytes (KB), to use as the upper size limit for responses from the data retrieval services.

  7. To allow updatable queries, in the Update Support section, select the Enable update query support checkbox.

  8. In the Data Source Time-out section, in the Request time-out box, specify the length of time to allow the data retrieval service to respond before timing out, in seconds.

  9. Click OK .

Configuring Data Retrieval Services from the Command Line

If you are using a third-party data retrieval service, you can register a service by using the command line. Register these services by using Stsadm.exe with the binddrservice and removedrservice operations. The binddrservice and removedrservice operations register individual data retrieval services for specific settings. When you register a service, it appears on the HTML Administration pages under the appropriate setting. For each operation, you specify the following required parameters: servicename and setting . The setting parameter takes any of the following values: enabled , responsesize , timeout , update .

For example, to register a data retrieval service called Service1 to the list of services that an administrator may enable or disable, you would use the following syntax:

stsadm.exe -o binddrservice -servicename Service1 -setting enabled

And to remove Service1 from the list of services that may allow data updates, you would use the following syntax:

stsadm.exe -o removedrservice -servicename Service1 -setting update

For more information about command-line operations, see Command-Line Operations .

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