Layer2 Business Data List Connector 关于

将 SharePoint 列表与外部数据连接。

Layer2 Business Data List Connector fixes many well-known issues that exist with SharePoint on-premises external data integration via BCS. It keeps native SharePoint lists in sync with 100+ external data sources, such as SQL/ERP/CRM and more without any programming, one-way or even two-way, automatically or on-demand. All SharePoint list features are available for your external data: views, filters, lookups, search, forms, change notifications, and workflows.

Layer2 Business Data List Connector Features

  • SharePoint on-prem data integration easy to setup - You don't need to be a programmer for this: Just go to SharePoint "List Settings", click "Connect to External Data Source". Enter a very few settings, automatically create and map your data fields - that's it. Your list will be connected and always up-to-date.
  • 100+ widely used IT systems supported out-of-the-box - Connect SharePoint to almost any SQL/ERP/CRM via ODBC, OLEDB, or ADO.NET. Integrate via Excel, Access, XML, CSV/TXT. Sync data via Web Services like OData or SOAP. Pull data from Active Directory, Exchange, Dynamics, SharePoint, or Office 365.
  • Secure connections without any changes in the backend - Use the SharePoint features you are already familiar with: Keep settings in the Secure Store. Cache external data in SharePoint lists. Use Timer Jobs, Ribbon Buttons, or the SharePoint API to keep your list data up-to-date in minutes.
  • All SharePoint list features for your external data - Provide all the great SharePoint list features for your external data without any restrictions: Views, filters, lookups, search, forms, change notifications, workflows on external data change. Large lists > 5.000 items fully supported.
  • Start workflows on external data change and write-back - Extend SharePoint forms and workflows to almost any external system for better collaboration and reporting. Process external data changes in SharePoint and write-back results to external systems in real-time, if required. Integrate external systems with Flow or PowerApps.
  • Integration should be part of any SharePoint-based portal - Providing pre-selected data sets originally hosted in complex backends in the well-known feature-rich Office environment for easy access highly increases end-user acceptance and helps to release the potential benefits of your existing SharePoint portal.