Layer2 Data Provider for OData: Specifications for the Layer2 Business Data List Connector
The Layer2 Business Data List Connector for SharePoint can be used to connect almost any external data sources to native SharePoint lists and libraries, even via the OData protocol as used by many applications, e.g. Microsoft CRM/ERP systems. This FAQ gives the full specifications of the Layer2 Data Provider for OData that is fully included in the product.
The Layer2 Data Provider
for OData can connect data sources via the OData protocol. The Open
Data Protocol (OData) is a Web protocol for querying and updating data. OData is
being used to expose and access information from a variety of sources including,
but not limited to, relational databases, file systems, content management
systems and traditional Web sites. Normally an OData request is presented in
single Url. The Layer2 Data Provider for OData splits the select portion and the data
collection Url portion and present them as a connection string and a separate
A Select statement for the Layer2 Data Provider for OData refers to the
Query Options section of an OData URL which is specified to control the amount
and order of the data requested. All OData services MUST follow the query string
parsing and construction rules defined in OData documentation section and its
This is the Service Root URL for the OData
source. The service root URL identifies the root of an OData service. The
resource identified by this URL MUST be an AtomPub Service Document (as
specified in [RFC5023]) and follow the OData conventions for AtomPub Service
Documents (or an alternate representation of an Atom Service Document if a
different format is requested).
OData: JSON Format specifies such an
alternate JSON-based representation of a service document. The service document
is required to be returned from the root of an OData service to provide clients
with a simple mechanism to enumerate all of the collections of resources
available for the data service This information is mandatory.
The resource path section of an URL
identifies the resource to be interacted with (such as Customers, a single
Customer, Orders related to Customers in London, etc.). The resource path
enables any aspect of the data model (collections of entities, a single entity,
properties, Links, service operations, etc.) exposed by an OData service to be
This setting specifies how the Layer2 Business Data List Connector authenticates against the OData source. It can be one of the
This is the default value and
used to connect anonymous resources.
authentication cookie has been created using the cookie manager, this
authentication method can be configured to authenticate by using the
authentication cookies. (See The Cookie Manager for more
You can use Windows AD
authentication to login. Please provide user name and password as well, e.g.
Windows integrated authentication. Current users account is used. Please take
care about the Windows Timer Service account in case of background updates. All
accounts used must have appropiate access rights to the external data