Layer2 Business Data List Connector V6 for SharePoint

You can connect and sync almost any external data source codeless with SharePoint using the Layer2 Business Data List Connector or Layer2 Cloud Connector. But how to add specific business logic on both sides, SharePoint and / or the external system?

SharePoint data integration: How to add specific business logic using Layer2 connectors

​While external data integration and synchronization of SharePoint lists can be done codeless in just minutes via Layer2 BDLC, it takes a little bit more time to add your specific business logic. Generally you can go two directions, in some cases both:

  • Add SharePoint list workflows (declarative or coded with VSTS)
  • Add events in the external system for insert, update or delete items, e.g. using SQL triggers

Add business logic using SharePoint list workflows

You can do almost everything by adding SharePoint workflows to a connected list. You can copy column content (or a part of column content) to other unmapped columns, or to other lists, if required. That could especially be helpful to manage lookups, user or group picker, modified or created columns and other more or less complex SharePoint fields. You can also keep existing foreign key table relationships in SQL for SharePoint. You will find a typical scenario here

Add business logic to SharePoint integration using SQL triggers

​Often SQL databases have the option to define triggers on insert, update or delete of records, e.g. for SQL Server, Oracle or MySQL. The following example shows how to post-process an already synchronized SharePoint lookup field to save the label only - and not the synced SharePoint content directly.

As you know, you can use lookups without any restrictions with Layer2 connectors. Let's demo this with a color lookup of a product list.

 

Colors-Lookup.JPG

 

Fig.: A color lookup list with a label (title) and an ID (item ID) in SharePoint.
 
The lookup is used in a product list as follows.
 
Products-with-Color-Lookup.JPG
 

Fig.: Product list that uses the lookup in a lookup column SPColor.

You can connect and sync the list with external SQL using the Layer2 Business Data List Connector for SharePoint or the Layer2 Cloud Connector for Office 365 including the lookup field without any issues. Let's assume the following table structure in SQL (taken from the Northwind database).

 

Products-Table-Fields.JPG

 

Fig.: Product table in SQL connected with SharePoint
 
Please note the fields SPColor and Color. While SPColor is mapped with SharePoint (using the Layer2 connectors), the Color field is not. To fill the Color field automatically, on insert and on update triggers are defined as follows.
 
SQLTrigger-600.JPG
 
Fig.: SQL On Update trigger to set the Color field with the SharePoint lookup label instead of the whole lookup string.
 
Finally we have got the results as expected shown below in the data query.
 
 Synced-Values.JPG
 
Fig.: Please note the typical SharePoint lookup token in the field SPColor while the label is stored automatically in the field Color.

How to add my specific business logic? Where to go next?

​No idea how to add your specific business logic to SharePoint sync? Just let us know! Also note our support offer on a per-hour base linked on the product pages.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

We are using the Business Data List Connector. We have over 60 different standing reports that are generated and appear on our SharePoint site daily. It is stable, flexible and reliable. We highly recommend it.

Related Contacts
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

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

Related News

SharePoint 2016 Data Integration

The Layer2 Business Data List Connector (BDLC) closes many gaps that still exists with Microsoft SharePoint 2016 out-of-the-box external data integration via Business Connectivity Services (BCS).

Layer2 Business Data List Connector V7 Released to Close Gaps with SharePoint External Data Integration

​Layer2 has announced version 7 of their top-rated Business Data List Connector (BDLC) that connects 100+ external data sources with SharePoint lists codeless and closes many gaps that still exist with out-of-the-box SharePoint external data integration.
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

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (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.

Layer2 BDLC for SharePoint Community Group @ LinkedIn

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

Purchase Layer2 Business Data List Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.
 
cs-award-top-100-publisher-2014-15-large.gif

Sign Up for Layer2 Product Newsletter

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