Citation

       "Please support us to improve our products and solutions. Give us your feedback."

Frank Daske, Business Development Manager, Layer 2 GmbH 

Related Content

Related Contacts

Frank Daske, Business Development Manager

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

Related Downloads

pdf Image2009-11-01: Layer2 Press Release

SharePoint – New Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0
Layer2, the SharePoint Experts from Hamburg (Germany) announced a new Microsoft SharePoint extension to unlock the value of enterprise data for SharePoint 2007 based portals. The Business Data List Connector (BDLC) for SharePoint directly connects SharePoint lists with external LOB data sources. Almost any data from databases, Office or even text data can be displayed in SharePoint lists without any programming. Workflows can be used to start business actions in SharePoint, if external data records are changed.

xml ImageBusiness Data List Connector PAD File

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

pdf ImageFlyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

Related Links

Are you looking for Layer2 product resellers and implementation partners?

United States:

Great Britain, Scotland and Ireland:

France:

Netherlands:

Switzerland:​

Poland:

Turkey:

South Africa:

Malaysia:

Aptrio Download Store

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Main Content

How to manage SharePoint BDLC background update settings?

The SharePoint Business Data List Connector is used to pull data into a SharePoint list (no Web Part) directly - possibly with background updates.

Update SharePoint list data with external data sources

In the SharePoint BDLC list settings dialog you can enable or disable background updates only. There are no further settings about timer interval, next run etc. But how to manage these settings, if required?

Background updates in SharePoint BDLC are done, using a timer job. By default the timer job runs every 15 minutes to manage updates for each list every one hour. The timer job can be set to 10 min with SharePoint 2010. The shortest interval for BDLC is 15 min.

Remember: In the current version the SharePoint BDLC provides read-only connections to external data sources. If no primary keys(s) are given, all data is updated (deleted and re-inserted) in the list. If valid primary keys are given, modified data is updated only, including deleted and newly inserted data entries. So in case of valid primary keys, you can use workflow actions or change notifications.

The time, required for updating your list depends on

  • configuration (hardware)
  • external data source
  • amount of changed / deleted / inserted data records
  • # of columns.

Normally the updates should take a few seconds only. Fast batch update mode is used internally with API. See FAQs for sample statistics.

Warning: You have to consider this execution time, if choosing a smaller update interval carefully.

During installation of BDLC an additional list is created in the root site of the current site collection named

BDLC Configuration List

at

http://...//Lists/BDLCConfigurationList/AllItems.aspx.

You can read or write to this list with appropiate access rights on root site level only. Within this list, all BDLC connection settings are managed, including next runs and run intervals (in minutes) settings.

You can edit these items as usual with SharePoint lists. Please modify the fields for Next Run and / or Interval only. The minimum interval setting is 15 minutes, because the timer interval is 15 minutes by default.

Remark: You should modify interval settings for those BDLC entries only, that already have a list structure created successfully. Otherwise the results are undefined.