FEATURE AND BENEFITS

Integration easy to setup in minutes

You don't need to be a programmer for this: Just go to SharePoint "List Settings", click "Connect to External Data Source". Select the data provider, enter a connection string, data query, and primary key - that's it. Your list is connected and always up-to-date.

100+ widely used IT systems can be connected

Connect to almost any SQL database via ODBC, OLEDB, or ADO.NET. Integrate via Excel, Access, XML, CSV/TXT. Synchronize via Web Services like OData or SOAP. Connectivity to Active Directory, Exchange, or SharePoint / Office 365 included. Find your specific system here.

Secure, fast and reliant architecture

Users do not directly access the connected external systems. They are working with native SharePoint lists, such as contacts, calendar events, tasks, or custom lists as a fast and feature-rich external data cache that can be updated automatically via timer jobs, or on-demand by users or API.

Market-leading since almost 10 years

Since the early days of SharePoint 2007 until now, thousands of customers trust Layer2 to manage their business-critical data integration to increase benefits and end-user acceptance of their SharePoint portals.

HOW IT WORKS

WHAT DO YOU WANT TO CONNECT TODAY TO SHAREPOINT?

SQL databases

SQL Server, SQL Azure  Oracle, MySQL, IBM DB2, AS/400, Informix, FileMaker ... almost any database can be connected. Find your database here.

Microsoft apps and services

Keep your SharePoint in sync with Microsoft Active Directory, Exchange, Dynamics CRM/NAV/AX/365, SQL, data on other SharePoint installations, tenants, site collections or sites, Office 365, Azure, Office Access, Excel, and more. Find specific Microsoft Apps here.

ERP, CRM or CMS systems

Add SharePoint-based reporting, search, dashboards, and workflows to your business-critical ERP or CRM without any changes: Salesforce, SugarCRM, SAP, Sage, Dynamics, Highrise, and more ERP and CRM systems are supported.

FAQs

How Layer2 compares to SharePoint out-of-the-box?

While UI integration of external data is available by default using SharePoint Business Connectivity Services (BCS), Layer2 fixes many well-known issues and limitations of BCS by integrating with native SharePoint lists. You can compare both approaches here.

How to manage large external data sets?

While standard BCS is limited to 2.000 items, Layer2 can manage large datasets (> list view threshold, up-to 100.000 items) depending on configuration and amount of data changes. Find a more detailed discussion here.

How to hide the connection string?

It's easy to enter the connection string directly in the list settings to quickly connect your list. But it increases security and improves access data management to hide the connection string in the SharePoint Secure Store. Learn more here.

How does it compare to competitors?

The Layer2 Business Data List Connector is the market-leading tool for SharePoint on-premises external data integration since almost 10 years now, thousands of implementation partners and customers love it because of its simplicity, power, and security.

Do I have to modify my data sources?

No changes are required in the connected systems. APIs like ADO.NET, ODBC, OLEDB, OData, XML, SOAP, and others are used to keep the data in sync. Your SharePoint users will never access your source systems directly. They work with SharePoint lists as some kind of up-to-date data cache for external data. Clients especially like this architecture because it highly increases availability, performance, and security of integration.

 

How the tool is licensed?

Just a one-time license fee per SharePoint WFE and Application Server with optional annual Software Assurance for updates and upgrades. No additional costs per connected system, number of connections, or amount of transferred data. Available for SharePoint Server 2007 (with limitations), 2010, 2013, and 2016. Learn more about licensing here.

 

Who is using the Layer2 Business Data List Connector?

1000+ clients and implementation partners trust the Layer2 Business Data List Connector every day.

 

WealthVest Marketing benefits from Layer2 SharePoint on-premises data integration

Data from connected backend systems now can be managed directly by the business users in Sales, Operations, Marketing, and IT in the existing SharePoint on-premises portal. No new tools or user training were required. The existing SharePoint infrastructure is leveraged without custom development - ready in just minutes.

READY FOR NEXT STEPS?

Download product flyer

Learn more about the Layer2 Business Data List Connector for Sharepoint and download the product flyer (PDF).

Register now for free download

Release the potential benefits of your SharePoint portal and improve end-user acceptance by adding seamless external data integration for better collaboration, reporting, dashboards, search, forms, workflows, and more.