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:
    893
  • Date Added:
    October 23, 2013
  • File Size:
    15.4MB
  • Downloads Last Week:
    2
  • Operating Systems:
    Windows XP/2003/Vista/Server 2008/7/8

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 Server 2008, Windows XP, Windows Vista, Windows 2003, Windows 7, Windows 8, Windows
    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 893
    Downloads Last Week 2
    Pricing
    License Model Free to try
    Limitations 25-item per list trial
    Price $1065

    Previous Versions:

     
    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