SharePoint Business Connectivity Services Limits

SharePoint Business Connectivity Services Limits

In this post, we will explore the Business Connectivity Services Limits in SharePoint 2019 and SharePoint 2016.

You might also like to read SharePoint 2019 Limitations.


What’s Business Connectivity Services (BCS)?

Business Connectivity Services (BCS) is an application service that enables SharePoint to work with external data like databases, web services, WCF, OData sources, and other data that can be accessed through .NET assemblies.

External Data Types selection in SharePoint

Business Connectivity Service Vs Business Data Catalog

Business Connectivity Services was introduced in SharePoint 2010 as an evolution of the Business Data Catalog that released in MOSS 2007.

Business Connectivity Services Limits
  • Business Data Catalog is a SharePoint 2010 Application Service that used to only read data from external data sources.
  • In SharePoint 2013 and 2016, “Business Data Catalog” becomes a “Business Connectivity Service” that can read and write data from external data sources.

You might also like to read how to Create External Content Type in SharePoint Designer 2013?


Business Connectivity Services Limits

The below table shows the Business Connectivity Services Limits in SharePoint 2019, SharePoint 2016 and SharePoint 2013.

LimitMaximum valueLimit typeNotes
ECT (in-memory)5,000 per web server (per tenant)BoundaryTotal number of external content type (ECT) definitions loaded in memory at a given point in time on a web server.
External system connections500 per web serverBoundaryNumber of active/open external system connections at a given point in time. The default maximum value is 200; the boundary is 500. This limit is enforced at the web server scope, regardless of the kind of external system (for example, database, .NET assembly, and so on) The default maximum is used to restrict the number of connections. An application can specify a larger limit via execution context; the boundary enforces the maximum even for applications that do not respect the default.
Database items returned per request2,000 per database connectorThresholdNumber of items per request the database connector can return.
The default maximum of 2,000 is used by the database connector to restrict the number of result that can be returned per page. The application can specify a larger limit via execution context; the Absolute Max enforces the maximum even for applications that do not respect the default. The boundary for this limit is 1,000,000.
Response latency600 secondsThresholdTimeout used by the external data connector per request. The default value is 180 seconds, but applications can be configured to specify a larger value up to the maximum of 600 seconds.
Service response size150,000,000 bytesThresholdThe upper volume of data per request the external data connector can return. The default value is 3,000,000 bytes, but applications can be configured to specify a larger value up to the maximum of 150,000,000 bytes.
Filter Descriptor (in-store)200 per ECT methodBoundaryThe maximum number of Filter Descriptors per ECT method is 200.
ECT Identifier (in-store)20 per ECTBoundaryThe maximum number of identifiers per ECT is 20.
Database Item1,000,000 per requestThresholdThe default maximum number of items per request the database connector can return is 2,000, and the absolute maximum is 1,000,000.
The default max is used by the database connector to restrict the number of results that can be returned per page. The application can specify a larger limit via execution context; the absolute max enforces the allowed maximum even for applications that do not respect the default such as indexing.
SharePoint Business Connectivity Services Limits

It’s strongly recommended to also read The External list Limitations in SharePoint 2013.


Conclusion

In conclusion, we have learned What’s Business Connectivity Services in SharePoint 2016 and SharePoint 2019. Also, we have explored the Business Connectivity Services limits.

Applies To
  • SharePoint 2019.
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
References
You might also like to read

2 thoughts on “SharePoint Business Connectivity Services Limits”

Leave a Reply