Scan & Fix 50 registry issues FREEPublisher's Description
From Layer2:
The SharePoint Business Data List Connector by Layer2 connects native SharePoint lists to almost any external business data source, e.g. SQL databases, Office data like Access, Excel or even text files, using a very simple list settings dialogue. It can be configured directly in the list settings dialog, using the installed connection providers, usual connection strings and SQL queries. The fast, easy and complete integration of external LOB data is a common requirement in the use of Microsoft SharePoint technology. The BDLC closes many gaps that still exist with SharePoint out-of-the-box solutions, such as the Business Data Catalog in SharePoint 2007 or the Business Connectivity Services in SharePoint 2010 / 2013. With BDLC all list features are completely available, such as views, search, lookups. Workflows and notifications per RSS or email can be used, to take business actions directly in SharePoint, when external business data records are changed. Bi-directional connections are supported with a write-back option in real-time, if required. All existing ODBC, OLEDB, OData and .NET based ADO.NET drivers are supported: You can connect to SQL Server, SQL Azure, MySQL, Exchange, Active Directory, SharePoint, MS Office Excel, Access or CSV text files, XML, EDI, Oracle, IBM DB2, Informix, AS400, Cache, ERP/CRM systems e.g. MS Dynamics CRM / NAV / AX, SAP, Salesforce.com, Twitter, Google, Facebook, QuickBooks, Peachtree, HL7, Virtual Store, general Web Services, .NET or COM+ objects.
What's new in this version: Version 4.0 comes support for OData, XML/RSS, CSOM, and SharePoint 2013.
More Products to Consider
-
Take an open-source approach to office productivity.DownloadInstalled
Smart Install -
Push and pull data to/from native SharePoint lists.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install -
Open, edit, and save files using the new file formats in 2007 v...DownloadInstalled
Smart Install -
Create and share content with the help of a comprehensive set o...Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Create, view, edit and share word, spreadsheet and presentation...DownloadInstalled
Smart Install -
Convert Adobe PDF file to MS Word file format.DownloadInstalled
Smart Install -
View, navigate, and print PDF files.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
View and print PowerPoint presentations.DownloadInstalled
Smart Install -
Convert PDF files to Microsoft Word format.DownloadInstalled
Smart Install -
Keep track of how you use your PC.DownloadInstalled
Smart Install -
Manage all your notes and web pages in the form of a tree.DownloadInstalled
Smart Install -
Manage all your notes and web pages in the form of a tree.DownloadInstalled
Smart Install -
Convert Word, RTF, and TXT files into PDF documents.DownloadInstalled
Smart Install -
Open, edit, and create CSV files or data tables on your Windows...DownloadInstalled
Smart Install -
Create, manage, and collaborate with others on presentations.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Read PDF files with this lightweight PDF viewer.DownloadInstalled
Smart Install -
Develop your own custom solutions visualizing various data.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install -
Compute and manage your customers incomes and outcomes.DownloadInstalled
Smart Install - Provide a powerful application for migrating documents.Download
Installed
Smart Install - Simplify the development of your Mysql database design.Download
Installed
Smart Install -
Convert JPG, BMP, TIFF, PNG images to PDF files.DownloadInstalled
Smart Install -
Access external data within SharePoint.DownloadInstalled
Smart Install -
Export Excel data to Access database.DownloadInstalled
Smart Install - Migrate sites, lists, and libraries between SharePoint servers.Download
Installed
Smart Install
-
All versions:
5.0 starsout of 2 votes
-
Current version:
0 stars Be the first to review this product -
My rating:
Write review
Results 1-2 of 2
-
"Easyly connect external data to your sharepoint site"
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... -
"Easy to manage compared to Business Data Catalog (BDC)"
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 listsSummary
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.
Version 1.5 is out now with support of much more data sources and some issues fixed. Just take a look what's new:
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
http://www.layer2.de/en/community/FAQs/BDLC/Pages/FAQs-SharePoint-BDLC-Whats-new-with-1.5.aspx
Updated on Jan 31, 2010Version 1.5 is out with more data source types supported and connection provider select. Just try it out.
