Description from the Publisher
The fast, easy and complete integration of external corporate 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 connects ANY native SharePoint list (no Web Part) to almost any external business data source, using a very simple list settings dialogue. It can be configured very easy:
1. Select connection provider
2. Enter Connection String and SQL query
3. Enter primary keys (if any)
The SharePoint list structure is created automatically and modified data is updated very fast in background or manually. Optionally bi-directional operation with full write-back (CRUD) to data source. The desired data can be presented with the full features of native SharePoint lists: 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 native 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. XML, MS Excel, MS Access, Visual Foxpro, DBF, Filemaker, Text-/HTMLfiles.
You can also link SharePoint lists directly to services like OData, OLAP, Active Directory, MS Project, SharePoint 2007/2010, Lotus Notes, Navision, ODBC/OLEDB.
The feature is available for WSS 3.0, SharePoint Foundation and SharePoint Server 2007 / 2010 / 2013.
Other downloads from this publisher
The SharePoint 2010 Tag Directory Web Part displays taxonomies of managed metadata or enterprise keywords as A-Z index navigation or glossary of categories linked to tag profiles or to the tagged content as well-known from technical books.
Auto-tagging of SharePoint managed metadata and enterprise keyword columns with content-based categories or keywords depending on term store taxonomies, tag rules, item and document properties, information store context and textual document contents.
The SharePoint 2010 Tag Navigation Web Part displays taxonomies of managed metadata or enterprise keywords as additional tree-style navigation linked to the tag profiles or to the tagged content - independent of the content's storage location.
The Layer2 Cloud Connector for SharePoint and Office 365 takes your corporate data to your cloud-based or any other hosted SharePoint - easy to connect, secure and always up-to-date.
The Knowledge Management Suite for SharePoint encourage knowledge workers to take advantage of the new SharePoint KM and social features by making it as easy as possible to manage metadata, classify content and use classification for navigation.