|
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, MS SharePoint, IBM Lotus Notes, Navision, ODBC/OLEDB.
The feature is available for WSS 3.0, SharePoint Foundation and SharePoint Server 2007 / 2010.

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

Click to enlarge
|
Related programs in Development - Components & Libraries |
|
Clix-FX XML Flash Menus
Clix-FX Flash XML Menu Templates the easiest way imaginable to create web menus
|
|
Global Clock Screensaver
Global Clock Screensaver displaying various time zones
|
|
SnugServer
Email Server plus FTP, Web, News & List Server with Anti-Spam/Virus & Encryption
|
|
Bridge It
Design and build bridges. Can you bridge the chasm and avert disaster?
|
|
3D Petanque Unlimited
3D Petanque Unlimited. Now on PC. Play it the way they do in Provence.
|
|
WebCab Optimization for .NET
Add optimization & L.P. solver to .NET, COM and Web service Applications.
|
|
WebCab Optimization (J2SE Edition)
Java class library for solving local or global optimization problems.
|
|
Global Tetris
Global Tetris consists of five various tetris games. Five games in one!
|
|
ActiveEarth
ActiveEarth World Time and Weather Clock, day/night map, analog clocks and more!
|
|
Document Import Kit for SharePoint 2007
DocKIT is a simple tool to import and migrate documents from multiple systems.
|
|
User Management Resource Administrator
Active Directory user resource management without requiring script knowledge
|
|
FmPro Migrator
Migrates FileMaker to MySQL, Oracle, Access, SQL Server, OpenBase,PostgreSQL
|
|
BioSeqAnalyzer
Align and analyze DNA and protein sequences with user-friendly Windows interface
|
|
Enhanced SharePoint User Tasks Menu
The Enhanced SharePoint User Tasks Menu enables task settings with one click
|
|
Luxena dbExpress driver for Informix Pro
Reliable access to Informix Servers with support for all Informix data types
|