SharePoint Business Data List Connector 1.5

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 MOSS (Enterprise Edition) only.

The SharePoint Business Data List Connector on the other hand, connects custom SharePoint lists (no Web Parts) 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)

Then the required SharePoint list structure is created automatically and modified external data is updated very fast in background using a timer job.

The desired data can be presented without any restrictions, with the full read-only functionality of common SharePoint lists made available: views, sorting and grouping, filters, calculated fields, search etc.

Workflows and notifications per RSS or email 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, MS SharePoint, MS Exchange, MS Index Server, IBM Lotus Notes, Navision, ODBC/OLEDB.

The feature is available for WSS 3.0 and SharePoint 2007 (all editions).

Keywords: SharePoint, BDC, BDLC, BCS, LOB, WSS, MOSS, External Data, Integration, Business Connectivity Services, External List, EAI, ODBC, OLEDB, SQL Server, Oracle, DB2, MySQL, Informix, Access, Excel, Microsoft, Active Directory, Exchange, Notes

Click to enlarge

Author:

Layer 2 GmbH     Other programs by Layer 2 GmbH

Downloads:

44

Size:

97K

Cost:

$1065.00 US

Users Rating:

    Reviews (1)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2010-01-22)

Recent Changes:

More data sources supported in V1.5

Supported Languages:

English, German

Additional Requirements:

Microsoft Windows SharePoint Services 3.0, Microsoft Office SharePoint Server 2007

Image Upload Column fo SharePoint 1.21   (2010-02-02)   update
Quick and simple way of uploading pictures.

Discussion Column for SharePoint 1.2   (2010-02-01)   update
Component for organizing discussion without need to enable list versioning.

Parent Selector Column 1.11   (2010-01-14)   update
Components for organizing hierarchical data.

Cross-Site Lookup Column with Search Function 1.1   (2010-01-12)   update
Cross-Site Lookup Column lookups data from any site within site collection.

Follow-Up Column for SharePoint 1.1   (2010-01-12)   update
Follow-Up Column enables due date flags similar to Outlook follow-up.

Progress Column 1.01   (2010-01-03)   update
Progress Column provides visualization for numerical data

Virto Incoming E-mail Feature 1.2.0   (2009-12-09)   new
Virto Incoming E-mail Feature for SharePoint. Collecting e-mail, routing

Virto SharePoint Password Reset Web Part 1.1.0   (2009-11-13)   update
Web Part allows SharePoint user to reset by himself his AD password

Virto SharePoint Workflow Activities Kit 2.0   (2009-11-12)   update
No-code set of Activities for creating Custom SharePoint Workflow

Virto SharePoint Alert & Reminder Web Part 2.0.0   (2009-10-16)   update
Virto Alert Web Part Customizer for SharePoint. Alerts to Email, SMS,XMPP

SharePoint List Item Sort Feature 1.0   (2009-07-01)   new
Enables manual list item sort feature for all types of SharePoint lists

PerformancePoint Print WebPart 2.1   (2009-03-17)   new
Easy-to-use printing solution for PerformancePoint Server and SharePoint.

WSQ image library (for fingerprints) 3.6   (2009-11-20)   update
Reads and converts WSQ (FBI's Wavelet Scalar Quantization) and 33 other formats

FeedForDev 1.0.0.1   (2007-03-26)   new
Communicate with users from within your software application using RSS Feeds.

Client/Server Comm Lib for Visual Basic 6.0   (2009-07-24)   update
Client/Server TCP/IP sockets component Visual Basic library for network comm.

Advanced WiFi-Manager 4.3 (upd.)
Flexible TreeView 2.5 (upd.)
Karsa Full Text Search Manager 2.0.0.0 (upd.)
Mainmedia Quick Time Source Directshow Filter 3.05 (upd.)
NET Win HTML Editor Control 4.0.1.19 (upd.)
Mainmedia FLV Directshow Source Filter 1.14 (upd.)
Mainmedia FLV Directshow Pro Source Filter 1.15 (upd.)
Mainmedia Audio Pitch Directshow Filter 2.15 (upd.)
Quick PDF Library 7.18 (upd.)
Mainmedia Video Processing Directshow Filter 1.05 (upd.)

DC ReturnKey Enable 3.0 (559 dl.)
ADSS.Plot Control 1.5 (524 dl.)
Windows Explorer Context Menu (.Net Component) 6.83 (488 dl.)
DC Image Button 3.0 (469 dl.)
AlphaControls Lite Edition 6.53 (437 dl.)
DC Help Authority 3.0 (388 dl.)
Client/Server Comm Lib for C/C++ 6.0 (338 dl.)
RuleLab.Net Business Rules Engine (BRE) 1.5.14 (330 dl.)
SMTP/POP3/IMAP Email Engine for Delphi 5.1 (298 dl.)
Mainmedia Audio Pitch Directshow Filter 2.15 (268 dl.)

Advanced WiFi-Manager 4.3 (n/r)
Flexible TreeView 2.5 (n/r)
Karsa Full Text Search Manager 2.0.0.0 (n/r)
Mainmedia Audio Pitch Directshow Filter 2.15 (n/r)
Mainmedia FLV Directshow Source Filter 1.14 (n/r)
Mainmedia Text & Image Overlay Directshow Filter 1.16 (n/r)
NET Win HTML Editor Control 4.0.1.19 (n/r)
Mainmedia FLV Directshow Pro Source Filter 1.15 (n/r)
WinI2C-DDC 3.70 (n/r)
Mainmedia Quick Time Source Directshow Filter 3.05 (n/r)