Use Cases Faq of the Layer2 Business Data List Connector

The Layer2 Business Data List Connector can close many gaps that still exist with SharePoint on-premises standard external data integration. Find answers to frequently asked questions and step-by-step intros about specific use cases and connections below. To learn more about detailed connectivity options for 100+ systems and apps take a look at the Use Case Finder.

The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with the SharePoint out-of-the-box external data integration. It makes it as easy as possible to connect native SharePoint lists to almost any external data sources, codeless and bi-directional. All native SharePoint list features are available for the connected lists, including search, managed metadata, offline and mobile access, change notifications and workflows. This use case shows how to connect a native SharePoint list with an Active Directory query result set.

The SharePoint Business Data List Connector is used to simply connect a SharePoint list with external LOB data, e.g. from databases, CRM or ERP systems.

The SharePoint Business Data List Connector BDLC can be used to pull data into a SharePoint list from another SharePoint list for any reason (e.g. from other site collection or installation).

You can integrate data from a Microsoft Dynamics NAV 4.0 (Navision internal database, non SQL Server) with native SharePoint lists via C/ODBC and keep it current using the Layer2 Business Data List Connector for SharePoint (BDLC). All SharePoint list features are available for the Navision data, e.g. search, managed metadata, lookups, notifications, workflows, if external data changes.

While integrating external data sources into SharePoint via OLEDB the valid syntax of the select statements depends on the types of data sources used. Below are given some samples for Microsoft Excel data sources that are often used with the Layer2 Business Data List Connector for SharePoint (BDLC).

The SharePoint Business Data List Connector is used to directly connect a native SharePoint list to almost any external LOB data, e.g. from databases, CRM or ERP systems.

Data from 100+ external sources can be visualized in SharePoint sites with the help of the Plumsail Dashboard Designer and the Layer2 Business Data List Connector for SharePoint.

The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with the SharePoint out-of-the-box external data integration with Oracle. It makes it as easy as possible to connect native SharePoint lists to Oracle tables and queries, codeless and bi-directional. All native SharePoint list features are available for the connected lists, including search, change notifications and workflows. Microsoft SharePoint 2013 (Server / Foundation) is supported as well as SharePoint 2010 and SharePoint 2007 (WSS / MOSS).​​​​

​You can connect and synchronize native SharePoint lists with SAP data via NetWeaver, OData and the Layer2 Business Data List Connector codeless in just minutes. No SAP licenses required for users. All SharePoint list features available without any restrictions, e.g. search, metadata, attachments, mobile and offline access, change notifications, workflows.

The Layer2 Business Data List Connector for SharePoint solves many issues that still exist with SharePoint out-of-the-box external data integration. It makes it as easy as possible to connect native SharePoint lists to almost any external data source, codeless and bi-directional. All native SharePoint list features are available for the connected list.

You can connect native SharePoint lists directly with external data from AS/400 database tables or views using the Layer2 Business Data List Connector. You can set the connection string, the select statement and the primary keys (if any) in the SharePoint list settings dialog for bi-directional synchronization in background.

The Business Layer2 Data List Connector for SharePoint (BDLC) can be used to connect SharePoint to 100+ external data sources, even to text / csv files via ODBC. This could be especially helpful in case your external system does not allow direct connections or you want to connect more complex query results. Please also note the option to connect via XML.​​​​​

​The Business Data List Connector for SharePoint can connect almost any data sources directly with native SharePoint lists via ODBC, OLEDB or .NET based providers. Because auf driver issues with the Microsoft OLEDB driver for SharePoint there were difficulties to connect SharePoint lists to SharePoint lists, e.g. on another installation. Now BDLC 3.4 comes with it's own web services based driver, the Layer2 SharePoint List Provider, that supports SharePoint-to-SharePoint connections out-of-the-box.

​The Layer2 Business Data List Connector for SharePoint (BDLC) can be used to connect almost any external data source to a native SharePoint list, even with full CRUD (Create / Update / Delete) support in real-time using default SharePoint list forms or any 3rd party forms app codeless.

​You can easily integrate almost any external data source with native SharePoint lists using the Layer2 Business Data List Connector, especially SQL tables or queries. But how to map existing SQL foreign key table relationships to SharePoint lookups? See below for a simple workflow-based approach.

​The Business Data List Connector for SharePoint connects almost any on-premise or cloud-based data source, e.g. ODBC, OLEDB, OData, Microsoft .NET based providers, Files (Excel, XML, CSV), SQL databases like SQL Server, Oracle, MySQL, IBM DB2, IBM AS/400, IBM Informix, Notes, SharePoint, Exchange, Active Directory, Navision, SAP and many more directly to native SharePoint lists - in just minutes without any programming. This FAQ gives a step-by-step intro about connecting XML data.​​​​​​

READY FOR THE NEXT STEPS?

Ifoc for free trial product regsitration - Layer2 leading solutions

Register for free download

No credit card required. Register, download and try as long as you want. It's all free.