SharePoint Business Data List Connector

Connects SharePoint lists to 100+ external data sources using SharePoint list settings codeless: 1. Select data provider 2. Enter connection string 3. Enter SQL query. That's it. All SharePoint list features supported: Search, workflows, write-back.

The fast, easy and complete integration of external corporate data is a common requirement in the use of Microsoft SharePoint technology. Existing solutions, such as the Business Connectivity Services (BCS) are complex at the facility, have serious issues and limitations.

The Layer2 Business Data List Connector (BDLC) connects ANY native SharePoint list to 100+ external data sources using a very simple list settings dialogue:

1. Select connection provider

2. Enter Connection String

3. Enter a data query like SQL

The SharePoint list structure can be created automatically and modified data is updated very fast automatically in background or manually on-demand. 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 BDLC can be used to connect native SharePoint lists to databases, such as MS SQL Server, Oracle, IBM DB2, MySQL, Sybase, Informix, PostgreSQL, IBM UniData, IBM UniVerse, AS/400 (IBM iSeries), Progress and more. With the BDLC you can pull data to SharePoint lists directly from data files, e.g. Text/CSV, XML, MS Excel, MS Access, Visual Foxpro, DBF, Filemaker. You can also link SharePoint lists to web services like OData, OLAP, Active Directory, MS Project, Exchange, SharePoint, Office 365, Dynamics, Lotus Notes / Domino, SAP and more.

The feature is available for SharePoint Server 2007 / 2010 / 2013 / 2016 including Foundation. A similar tool is available for SharePoint Online & Office 365.

Download

System Requirements:

Win7 x32, Win7 x64, Win98, WinMobile, WinOther, WinServer, WinVista, WinVista x64, WinXP

Version:

7

Last updated:

2015-10-08 12:37:38

Publisher:

Layer 2 GmbH

Homepage:

http://www.layer2solutions.com

File name:

Layer2.SharePointBusinessDataListConnector.zip

File size:

97KB

License:

Shareware

Price:

1065

You may also like...