Connect existing SharePoint 2007 / 2010 lists directly to ANY external data in just minutes

SharePoint data integration made easy: 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.

SharePoint-Integration-Layer2-BDLC.png 

 SharePoint-External-Data-Integration-YouTube.png 

SharePoint Integration Layer2 Customers 

Fig.: Selected Layer2 BDLC customers.  All trademarks cited here are the property of their respective owners.

SharePoint Integration: Layer2 Business Data List Connector (BDLC)

The fast, easy and complete integration of external data sources is a common requirement in the use of Microsoft SharePoint technology. Solutions, such as the Business Data Catalog (BDC) for SharePoint 2007 or the Business Connectivity Services (BCS) for SharePoint 2010/2013, are complex at the facility, require additional tools or programming, have serious limitations and are available for certain SharePoint editions only. The Layer2 Business Data List Connector for SharePoint completely solves those issues.

The connector offers SharePoint "External Lists" by connecting 100% NATIVE SharePoint lists (no SharePoint Web Parts, no BCS - native contacts, news, tasks, events or custom lists) to almost any external data source in just minutes directly in the list settings. The desired data can be populated to the list and presented without any restrictions, with the full functionality of common native SharePoint lists. Please find more SharePoint integration features and benefits or select common SharePoint integration use cases.
 
SharePoint Integration - Step by Step Intro @ Slideshare
 
Fig: To see the product presentation full-screen please click the image. In case of technical issues using Slideshare just download the presentation file here.
 
Whether you are an end customer, systems integrator or service provider, with the Layer2 Business Data List Connector you can dramatically reduce project costs, simplify your SharePoint architecture, improve SharePoint reliability, productivity and increase end user acceptance.

SharePoint Business Data List Connector - Availability

​The SharePoint Business Data List Connector is available for Microsoft SharePoint Server 2007, 2010 and 2013 as well for the free Windows SharePoint Services 3.0 / Microsoft SharePoint Foundation 2010 / 2013. To connect your data to the SharePoint Cloud (e.g. SharePoint Online, Office 365 or any other externally hosted sandbox) please evaluate the Layer2 Cloud Connector for SharePoint and Office 365 product with similar features - but different architecture.
 

SharePoint Business Data List Connector - How does it work?

​The SharePoint Business Data List Connector (BDLC) provides the complete read-only or optionally write-back (CRUD - Create / Update / Delete) features of any native SharePoint 2007/2010/2013 list for almost any external LOB data sources in just a few simple steps:
 
SharePoint External Data Integration 
Fig.: Simply click "Connect to external data source" in the General List Settings to synchronize any native SharePoint list with almost any external data source automatically.
  • Create a native list of any type to host the data and simply click "Connect to external data source" in the list settings dialog.
  • In the BDLC settings dialog choose from the installed connection providers and enter the appropriate connection string (e.g. OLEDB, ODBC, .NET, OData or custom) and validate it. Please note that you can hide security relevant settings in the SharePoint secure store later on.
  • To select the desired data, please enter a query statement as supported by your external data source and validate it. Check the result in preview mode and enter the primary key(s) - some unique columns - to safely update changed SharePoint list items only.
  • Create the SharePoint list structure by adding required columns automatically, check the field / column mapping and update the list first time using the command buttons with one click. If a primary key is available, only modified data is updated in the list later on with high performance (background batch update via timer job).
  • You can optionally activate write-back to external data source (CRUD: Create, Update, Delete features), if supported by the driver, access rights and query.
  • You can use update on-demand via list action menu / ribbon button, URL, or API - or you can simply activate the background update to run a scheduled timer job for this.
 
SharePoint external data integration setup 
 
Fig.: Sample configuration of the SharePoint Business Data List Connector to expose the SQL Server categories table of the Northwind demo database as a native SharePoint list. No other settings required to connect and keep current.

Free Registration & Download

With the free Shareware Edition of the Layer2 Business Data List Connector for SharePoint (BDLC) you can manage up to 25 items per list. To manage more items the full licensed version is required. Please register to download the evaluation / shareware version for free now. Use the registration form on this page or contact sales@layer2.de

How to buy this product

​To buy a license for this product, please click the shopping cart symbol on this page. The product is licensed on a per SharePoint server base (perpetual license, one-time fee). No additional clients licenses (CALs) are required. If you have several WFE servers (e.g. in a farm scenario) all WFE servers have to be licensed. Application servers have to be licensed in case of automatic background updates are used. Infrastructure server, e.g. for database, indexing or search etc. don't need any license. You can license the evaluation / shareware version at any time without new installation. For more information about licensing please check our FAQs or contact sales@layer2.de directly.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

Of all the tools I've bought to make our SharePoint environment more user friendly, the Layer2 Business Data List Connector is my favorite. It is really well done, and the service from the publisher is a top drawer.

 

 Download & Evaluation

 
Please register now to receive your free personal download link via email to your valid company email address.
Name: 
Company: 
Country: 
Phone: 
E-mail: 
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited amount of list items. To order a license for the full version please click the shopping cart.

Layer2 Business Data List Connector for SharePoint 2007/2010/2013

License or service List Price
Free Shareware Edition $0.00
1 Single Server
License
#300332176
$1,065.00 Add to Shopping Card
1 Annual Software Assurance
#300421884
$225.00 Add to Shopping Card
Prepaid Remote Support
1 Hour
#300363235
$176.00 Zum Warenkorb hinzufügen

 

You can also order by phone or fax:

Order Service USA
(Language: English)

Share-it c/o Digital River, Inc.
10380 Bren Road West
Minnetonka, MN 55343, USA

Phone from outside the U.S.:
+1 952 646-5747
Phone from within the U.S.:
+1 800 903-4152
Fax: +1 952 646-4552
support@us.shareit.com

Order Service Europe
(Languages: German, English,
French, Italian, Spanish,
Portuguese)

Share-it - Digital River GmbH
c/o Digital River Ireland Ltd.
Unit 153
Shannon Free Zone West
Shannon Co. Clare
Ireland

Phone: +49 221 31088-20
Fax: +49 221 31088-29


More about how to buy see here. For more information about licensing please check FAQs or contact sales@layer2.de directly.

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
sales@layer2.de

Please note that the 011 exit code must be dialed first for all international calls made from the USA , Canada and Australia.

News

Layer2 Business Data List Connector for SharePoint V5 Released To Close Gaps With External Data Integration

Layer2 has announced V5 of the SharePoint Business Data List Connector that connects almost any external corporate data source with native SharePoint lists and closes many gaps that still exist with SharePoint data integration.

Microsoft SharePoint Apps: Layer2 and Ividix Partnership Announced

Layer2 announces partnership with Ividix Software Solutions to establish Ividix as a regional systems integration provider and reseller for Layer2′s SharePoint Apps.
Related Downloads
NoDoc Image

Business Data List Connector PAD File

This XML-based PAD file offers a product description for resellers to download and publish.
PDF Image

Customer Solution Case Study: WealthVest Marketing Benefits From SharePoint Data Integration Using Layer2 Business Data List Connector

"By using the Layer2 Business Data List Connector for SharePoint app we can provide native SharePoint lists as a simple, easy-to-use, and familiar interface to manage mission critical business data."
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

How to connect ANY external data source directly to native SharePoint lists?

Download this step-by-step introduction to the Layer2 Business Data List Connector (BDLC) for SharePoint.
PDF Image

How to integrate SAP data with SharePoint via NetWeaver & OData

You simply have to enter an URL to the data collection to integrate and sync SAP data with native SharePoint lists.
PDF Image

Produktflyer: Business Data List Connector for SharePoint

Productflyer (PDF) in English for download.
PDF Image

Testimonial: How the US Defense Contract Management Agency (DCMA) integrates SharePoint with Oracle using BDLC

"Layer2 Business Data List Connector (BDLC) software provides a powerful mechanism for surfacing external data through lists, and drastically improves platform stability and development cycles."
Related Links

Are you looking for partners in your region?

Please find a local partner here.

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Layer2 BDLC for SharePoint Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join our group to share your experience.

Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.