SharePoint Business Data List Connector

SharePoint Business Data List Connector

Average User Rating:
5.0
out of 2 votes

Quick Specs

  • Version:
    5.0
  • Total Downloads:
    932
  • Date Added:
    Oct. 23, 2013
  • Price:
    Free to try (25-item per list trial); $1,065.00 to buy (Buy it now)
  • File Size:
    15.4MB
  • Downloads Last Week:
    2
  • Platform:
    Windows

Publisher's Description

+
 
read more +
User Reviews
+

Results 1–2 of 2

5 stars

"Easyly connect external data to your sharepoint site"

October 14, 2009  |  By Brazzuk

 |  Version: SharePoint Business Data List Connector 1.0

Pros

Easy to install the solution; connecting the database was simple, just use Oledb connectionstring to access a sql server db; connectionstrings and selects stored encrypted

Cons

no duplex sync; update-Interval in seconds or minutes? (no explanations there, so i guess its minutes);

Summary

Nice tool, i´m looking forward to the next version with full duplex updating possibilities.
At the moment I'm connecting some other Lists / Webparts to this bdlc list, to pull out all the stops of sp functionality...

Reply to this review

Was this review helpful? (0) (0)

5 stars

"Easy to manage compared to Business Data Catalog (BDC)"

October 09, 2009  |  By SharePointFrank

 |  Version: SharePoint Business Data List Connector 1.0

Pros

Avoids the complexity of the Business Data Catalog (BDC), every admin can configure this BDLC, No additional tools required, uses lists (not web parts) with all this great features we like in SharePoint. Very fast background update.

Cons

No way to edit external data sources directly in lists (in current release)
No oob support for folders in lists

Summary

While the Business Data Connector (the default way to integrate external data into SharePoint) is available for SharePoint Enterprise edition only and generally not for the free Windows SharePoint Services, the BDLC is an interesting solution for all portals based on SharePoint technology.

No problems with installation and feature activation for experienced SharePoint admins. You start with creating a custom list of type BDLC. Good idea to enter the (few) configuration data directly in the list's settings.

You don't have to deal with lots of configuration XML-files or SharePoint Designer. It reminds me at the early days ODBC: Really simple to connect with connection string, select statement. Because it uses a very generic, provider-based layer it can handle almost any external data sources (with providers available, such as
MS SQL Server, Oracle, IBM DB2, MySQL, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, Informix, Postgre SQL, IBM UniData, IBM UniVerse, AS/400 (IMB iSeries), Progress, data files, e.g. MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, Text-/HTMLfiles, services like OLAP, AD, MS Project, MS SharePoint, MS Exchange, MS Index Server, IBM Lotus Notes, ODBC/DSN/UDL etc.)

The list data structure is automatically created, you can change it afterwards as usual in SharePoint. But please keep in mind your data definition in the data source! I've mofified most of the automatically created multi-line text fields to simple string fields with fixed length (so that they can used as filter).

From my point of view, the most interesting feature is to have a REAL list. With primary keys given, only changed data is modified in the list. Thats why you can use alerts and workflows. Imagine, you can automatically run an approval workflow directly in SharePoint, if the order table in your external data source has a new entry.
Well done, so far.

Whats leftover to do? It would be great to have the list working in both directions with the possibility to edit the data source if required. And some add-ons for large lists, like folder support.

In summary it's a very efefctive SharePoint Add-On for everyone, that has to integrate external data in SharePoint (and thats nearly everyone ;-).

Updated on Jan 22, 2010

Version 1.5 is out now with support of much more data sources and some issues fixed. Just take a look what's new:

http://www.layer2.de/en/community/FAQs/BDLC/Pages/FAQs-SharePoint-BDLC-Whats-new-with-1.5.aspx

Updated on Jan 31, 2010

Version 1.5 is out with more data source types supported and connection provider select. Just try it out.

Reply to this review

Was this review helpful? (0) (0)

Results 1–2 of 2

Add Your Review

Login or create an account to post a review.

You are logged in as . Please submit your review for SharePoint Business Data List Connector
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Update your review

Since you've already submitted a review for this product, this submission will be added as an update to your original review.
Submit

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

 
see all reviews +

Full Specifications

+
What's new in version 5.0
Version 5.0 comes with support for OData, XML/RSS, CSOM, and SharePoint 2013.
General
Publisher Layer2
Publisher web site http://www.layer2.de/en/
Release Date October 01, 2013
Date Added October 23, 2013
Version 5.0
Category
Category Business Software
Subcategory Collaboration Software
Operating Systems
Operating Systems Windows Vista, Windows 2003, Windows 7, Windows, Windows XP, Windows Server 2008, Windows 8
Additional Requirements SharePoint Server / Foundation 2010 and 2013, SharePoint 2007 WSS 3.0
Download Information
File Size 15.4MB
File Name Layer2.SharePointBusinessDataListConnector.zip
Popularity
Total Downloads 932
Downloads Last Week 2
Pricing
License Model Free to try
Limitations 25-item per list trial
Price $1065

Previous Versions:

Add to my list Report a problem
 
read more +

More Products to Consider

Close[x]

Submit a problem report for SharePoint Business Data List Connector

Please describe the problem you have with this software. This information will be sent to our editors for review.

Problem:

The Download.com Installer isn't working as expected

The download link does not work

The software has a newer version

The product contains malicious software

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Close[x]

Problem Report submitted

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.

OK