SharePoint 2016, Sharepoint 2013, Sharepoint 2010, Windows Server 2012, Sql Server 2012,2014,IIS, Active Directory,User Profile Service, Managed MetaData Service, Search Service, Topology, Web Application, IIS, Site collection, List, Library, PowerShell, office web app, Windows Authentication, NTLM, Kerberos, Saml, ADFS, Active Directory Import, MIM, SharePoint 2016 Data Retrieval Service – SharePoint

SharePoint 2016 Data Retrieval Service

You are on the Data Retrieval Service page (Central Admin > Application management > Under Database…Configure the data retrieval service)



What is DRS?

A data retrieval service implements a 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 Windows SharePoint Services. Windows SharePoint Services 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.


This first introduced in SharePoint Service 2.0 and still continue.Here are the options you can configure on this page.

Only caution is, please understand it before making the change because a bad setting can cause your development stop working. It is highly recommended to use the default settings but if there is any real need then you can change it as per the requirement.



Web Application

You can change it for your entire farm called Globally, by selecting the Globally


Or you can change it for a specific web app by selecting the web app.

Enable Data Retrieval Service

Turns data retrieval services on or off. By default, data retrieval services are enabled. If you plan to turn it off you should Uncheck the Box.

Note: Be Careful before disabling this, because chances are Custom Development as SharePoint designer customization may stop working.


Limit Response Size

Specifies the response size of the data source that is returned to the data retrieval service. Default value is 10000 (10KB). If you want to increase value, in that case I would highly recommend to monitor the performance of your SharePoint. In some case memory utilization spiked.2016-07-14_23h04_34


Update Support

You can enable or disabled the support for Update queries. By default, this option is disabled. Mostly developer ask for this option when you query non SharePoint Databases.2016-07-14_23h04_48

Data Source TimeOut

By default, value for this option is 30 Sec and you can change it higher or lower numbers. Don’t play with this value Unless a valid reason to change this value.2016-07-14_23h04_58

Enable Data Source Controls

Turns the data source controls on the server on or off. If this setting is set to disabled, no query results are processed. By Default, this option is enabled.2016-07-14_23h05_09

At the end you have to Click Ok to commit your changes



You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *