SharePoint Business Data List Connector 7
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.
Download
0.09 MB
696downloads
4this week
$1065Shareware
0reviews
Screenshots
About SharePoint Business Data List Connector
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.
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.
| Requirements | SharePoint Server / Foundation 2010, SharePoint 2007 WSS 3.0 |
|---|---|
| Release info | Major Update on Oct 01, 2015 |
| Release notes | Support for Microsoft SharePoint Server 2016 |
| Related tags | SharePoint Database Integration BCS BDLC |
Reviews
No reviews yet. Be the first to review SharePoint Business Data List Connector.
Used SharePoint Business Data List Connector? Tell other visitors what you thought.
Log in to write a reviewOther products by this publisher
-
Cloud Connector for Office 365 6
The Layer2 Cloud Connector syncs your local or cloud-based external data sets with Office 365 & SharePoint lists and libraries, e.g. database queries, web services, files, ERP/CRM: codeless, easy to connect, secure and always up-to-date.
-
Enhanced SharePoint User Tasks Web Part 1.0
The Enhanced SharePoint User Tasks Web Part rollup user tasks on site collection
-
SharePoint 2010 Tag Directory Web Part 1.7.1
Automatic taxonomy-based A-Z index navigation directory for SharePoint portals
-
SharePoint 2010 Tag Navigation Web Part 1.7.1
Automatic tree-style metadata taxonomy navigation web part for SharePoint 2010
- SharePoint Auto Tagger 2.6 Auto-categorization of SharePoint content via managed metadata columns with content-based categories or keywords depending on term store taxonomies, classification rules, item and document properties, store context and textual document contents.
Most viewed Windows Content Management
-
1
Auto Classifieds Script 3.0
Auto Classifieds Script provides a very easy way for web admins to manage content on a car dealer website: add/edit/delete car listings, car description, extras & more. Once installed the car dealer script can be used without any programming skills.
-
2
Simple Content Management System 4.0
Simple PHP content management system (CMS) is a web based solution primarily focused the easiness of managing website content (text, images and other files). Role-based access, an unlimited number of sections & users and a developer-friendly licence.
-
3
ApPHP Business Directory script 3.0.1
ApPHP Business Directory is a simple, but powerful Business Directory solution. This script allows to add categories, then associate added businesses to these categories. You may also add business profiles including basic business contact info.
-
4
A1 Website Download 10.1.4
Download and archive entire websites such as forums, galleries and online books. Website downloader can perform website login and handle cookies. Copy and store websites on portable media such USB and CD. Convert dynamic websites into static.
- 5 ApPHP MicroCMS Content Management System 3.9.4 MicroCMS is a simple, but very powerful Content Management System that everyone can use. The PHP MCMS can be installed easily by web developers, webmasters, graphic designers, etc.PHP MCMS was developed in OOP.
-
6
ProjectForum 7.5.0
ProjectForum is a professional-grade, full-featured and secure workgroup Wiki server that makes it easy for a team of people to collaborate. It is entirely self-contained and hassle-free to install and use.
-
7
Job Listing Script 3.0
Job Listing Script is a PHP job board software for managing online job portals and job classifieds. Use the job board script to create your job search website or as a small addition for any website and to add a job search feature.
-
8
ApPHP MicroBlog - web blog PHP script 1.0.1
ApPHP MicroBlog (ApPHP MicroB) is very simple and powerful PHP blog software. This product enables you to start your own blog within minutes. You can easy add and manage your posts and posting categories.
-
9
ApPHP Online Medical Appointment script 2.0.1
ApPHP Medical Appointment is online doctor, therapist appointment and medical clinic site PHP script. This Appointment System is an application for handling doctors appointments. It enables patients to book an appointment using web-based interface
- 10 Social Submitter 2.7.3 Automatic submission of tagged articles with backlinks to up to 450 social sites
Most downloaded Windows Content Management
-
1
ProjectForum 7.5.0
ProjectForum is a professional-grade, full-featured and secure workgroup Wiki server that makes it easy for a team of people to collaborate. It is entirely self-contained and hassle-free to install and use.
-
2
ApPHP DataGrid Wizard utility script 2.0.1
ApPHP DataGrid Wizard - utility script for generating PHP DataGrid pages
-
3
ApPHP MicroBlog - web blog PHP script 1.0.1
ApPHP MicroBlog (ApPHP MicroB) is very simple and powerful PHP blog software. This product enables you to start your own blog within minutes. You can easy add and manage your posts and posting categories.
- 4 Social Submitter 2.7.3 Automatic submission of tagged articles with backlinks to up to 450 social sites
- 5 Yellow Pages Script 3.0 Easy to use PHP business directory script for anyone who wants to create and maintain yellow pages business directory website. No limitation on the number of business listings and categories. Free installation support! 2 licensing options!
-
6
QSyncFTP 1.8
QSyncFTP - publish or update your web site by mouse-click automatically or by timers fully automatic to any FTP server. Pubish or modify new files, changed files, new directories and uploads all changed files automatically to one or more FTP servers.
-
7
ApPHP Business Directory script 3.0.1
ApPHP Business Directory is a simple, but powerful Business Directory solution. This script allows to add categories, then associate added businesses to these categories. You may also add business profiles including basic business contact info.
-
8
Synonymizer 3.2
Improve and enrich your writing, by using synonyms.
-
9
Auto Classifieds Script 3.0
Auto Classifieds Script provides a very easy way for web admins to manage content on a car dealer website: add/edit/delete car listings, car description, extras & more. Once installed the car dealer script can be used without any programming skills.
- 10 Yacht Listing Script by StivaSoft 1.0 Simple & easy-to-use boat script which makes it very easy for anyone to manage yacht & boat classifieds. Through an intuitive admin page you can manage boat classifieds, users, listings per page, etc. PHP Source, regular updates & FREE installation!