audio & multimedia
games & entertainment
graphic apps
home & hobby
network & internet
security & privacy
system utilities
web development

development \ components & libraries

SharePoint Business Data List Connector 3.4

Layer 2 GmbH
26 Jun 2011

The fast, easy and complete integration of external LOB data, e.g. from databases, is a common requirement in the use of Microsoft SharePoint technology. Existing solutions, such as the Business Data Catalog (BDC) in SharePoint 2007 or the Business Connectivity Services (BCS) in SharePoint 2010, are often too complex at the facility, bring with them limitations or they are available for certain editions only.

The SharePoint Business Data List Connector on the other hand, connects ANY SharePoint list (no Web Part) to almost any external business data, using a very simple list settings dialogue. It can be configured very easy:

1. Enter connection provider and string
2. Enter select statement
3. Enter primary keys (if any)

The required SharePoint list structure is created automatically and modified data is updated very fast in background or manually. Optionally bidirectional operation with full write-back (CRUD) to data source.

The desired data can be presented with the full features of common SharePoint lists made available: views, sorting and grouping, filters, calculated fields, search, offline etc.

Workflows and notifications can be used, to take business actions directly in SharePoint, if external business data records are changed.

The SharePoint Business Data List Connector (BDLC) can be used to connect SharePoint lists to databases, 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 and more.
With the BDLC you can pull data to SharePoint lists directly from data files, e.g. MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, Text-/HTMLfiles.
You can also link SharePoint lists directly to services like OLAP, AD, MS Project, SharePoint 2007/2010, IBM Lotus Notes, Navision, ODBC/OLEDB.

The feature is available for WSS 3.0, SharePoint Foundation and SharePoint Server 2007 / 2010.

Site  Download

Related software

Data Monkey G.D.H.
ETL / Database Administration application that works with ALL databases.
SQL Drill Freeware
SQL Drill Freeware Excel Add-In: simplify data retrieval from ODBC databases
Add database connectivity to Outlook or Exchange.
blueshell Data Guy
Universal database editor for Jet (ISAM, Access), Oracle, SQL Server.. using ADO
Genius Connect - Mail
Store Outlook or Exchange mail in any SQL Database.
MySQL Migration Toolkit
software pack to convert any data source to convert any data source
SqlSpec: a database documentation generator for all major DBMS
A power SQL Query Tool for and DBMS.
Apatar Data Mashup Integration
Apatar is an open source data mashup integration and ETL tool
Easy Chart 3D GEO
Graphical reporting tool for effortless generation of reports from database data
Directory Lister Pro
Create HTML, text, CSV, database directory listing of any drive or network share
SQL Script Builder
SQL Script Builder - Multiple Platform Database Migration Tool
RazorSQL (OSX)
SQL database query tool, browser, and editor that supports all major databasest
ASP.NET Report Maker
Generate ASP.NET 2.0 dynamic Web report from database
ASP Report Maker
Generate dynamic Web report from database
Generate ASP.NET scripts from database in seconds.
Database ViewerPlus(Access, Excel, Oracle)
View and Sync Ms Access, Excel, Oracle, any ODBC enabled database with Palm.
SQL database query tool, browser, and editor that supports all major databases
Generate ASP XML for Ajax, RSS, Flash, etc.
Generate ASP from database in seconds.