Skip Navigation Links

You can connect any WSS 3.0 or SharePoint 2007/2010 list (no Web part) directly with external data from Microsoft Exchange Server folders, e.g. contacts, tasks, events / appointments, inbox etc.using the

SharePoint Business Data List Connector (BDLC).

Oracle SharePoint Connection

You simply can use a connection string and SQL like queries to select your data and provide it in tasks, contacts, events or custom lists with all list features available, e.g. calendar views, calculated fields, RSS newsfeeds, email notifications and workflow, if external Exchange data changes.

How to connect Exchange Server to SharePoint lists, e.g. contacts, tasks,  events, messages?

With the SharePoint Business Data List Connector you can use a 3rd party middleware driver to link SharePoint lists to Exchange data.

Step 1: 3rd Party Exchange Gateway Driver Setup

Exchange SharePoint Connection Setup

Fig.: Enter your user configuration to access Exchange Server.

Step 2: Check connection string and query for Exchange Server data access

How-to-connect-SharePoint-List-to-Exchange.Query

Fig.: Before using the connection string and the query in BDLC, you can test with the Query Analyzer.

3. Configure BDLC to sync Exchange with a SharePoint list

How-to-connect-SharePoint-List-to-Exchange.Configuration

Fig.: Copy the pre-tested connection string and query to the BDLC settings to connect  a list.

4. Manage your Microsoft Exchange data in a SharePoint list

 How-to-connect-SharePoint-List-to-Exchange.Results

Fig.: You can use the Exchange data in a SharePoint list without any restrictions.

The inbox messages above are for example only. The conenction works in the same way for any Exchange-based contacts and SharePoint contact lists, Exchange-based tasks and SharePoint tasks list, Exchange-based appointments and SharePoint event lists (e.g. with calendar view) and any other types of lists. Simply try "select * from task", "select * from contact" etc.

You can use all list features like views, calculated fields, additional columns, attachements, offline, tagging, rating, RSS newsfeeds, change notifications per email or even workflows.

Please contact sales@layer2.de with your full business contact data to request the required middleware today. You can download the Business Data List Connector here:
http://layer2/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx
 

Connect SharePoint lists to Exchange data - Known Issues

  • If you feel performance issues with a bigger amount of messages, please use folder names in query, e.g. "SELECT * from Message where ParentName = '/Inbox/'".
  • If you have "Connection has been disabled", just try to reconnect. Open but unused connections are closed after 2 minutes by default in the current version.

       "There are lots of possibilities to connect Exchange with SharePoint. But BDLC only delivers full SharePoint list features for Exchange-based content.

Frank Daske, Business Development Manager

News

European SharePoint Component Vendor Layer2 announces Technology Partnership with Nintex

Strategic technology alliance formed by Layer2 and Nintex enables seamless integration of any external Line-Of-Business Data into SharePoint workflow and lists without code.

SharePoint Codeless Bi-Directional List Connectivity Powered by Enterprise Enabler and Business Data List Connector

Stone Bond Technologies, provider of the world’s only codeless connectivity software and eco-system, today announced a strategic alliance with Layer2 a leading publisher of SharePoint Web Parts and solutions.
More...
Related Products

SharePoint Business Data List Connector

Related Downloads

pdf Image2009-11-01: Layer2 Press Release

SharePoint – New Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0
Layer2, the SharePoint Experts from Hamburg (Germany) announced a new Microsoft SharePoint extension to unlock the value of enterprise data for SharePoint 2007 based portals. The Business Data List Connector (BDLC) for SharePoint directly connects SharePoint lists with external LOB data sources. Almost any data from databases, Office or even text data can be displayed in SharePoint lists without any programming. Workflows can be used to start business actions in SharePoint, if external data records are changed.

xml ImageBusiness Data List Connector PAD File

This XML-based PAD file offers a product description for resellers to download and publish.

pdf ImageFlyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

pdf ImageHow to connect ANY external data source directly to SharePoint lists?

From SQL Server or Oracle tables and Excel files to web services, .NET objects, COM+ objects and ANY other data sources - connect it simply to any existing SharePoint 2007 / 2010 lists now.

pdf ImageLayer2 Flyer: Microsoft SharePoint 2010 Web Parts and Solutions

pdf ImageProduktflyer: Business Data List Connector for SharePoint

Productflyer (PDF) in English for download.

pdf ImageTestimonial: How the US Defense Contract Management Agency (DCMA) integrates SharePoint with Oracle using BDLC

"Layer2 Business Data List Connector (BDLC) software provides a powerful mechanism for surfacing external data through lists, and drastically improves platform stability and development cycles."

Related Links

Are you looking for Layer2 product resellers and implementation partners?

United States:

Great Britain, Scotland and Ireland:

France:

Netherlands:

New Zealand:

Switzerland:​

Poland:

Turkey:

South Africa:

Malaysia:

Aptrio Download Store

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Did you know? You can connect SharePoint lists directly to almost any external data source with BDLC to have a "SharePoint External List" today.

You can connect SharePoint lists directly to databases, such as:

  • SQL Server 2008
  • SQL Server 2005
  • SQL Server 2000 / 7.0
  • Oracle
  • IBM DB2
  • MySQL
  • Sybase Advantage Database Server
  • Sybase Adaptive Server Enterprise
  • Informix
  • Postgre SQL
  • IBM UniData
  • IBM UniVerse
  • AS/400 (IMB iSeries)
  • Progress
  • FireBird
  • Interbase
  • Paradox
  • Ingres
  • Mimer SQL
  • Lightbase
  • Pervasive
  • SQLBase  (Gupta/Unify)
  • Cache
  • Teradata
  • VistaDB
  • DBMaker
  • Netezza DBMS
  • Valentina

and more. You can pull data to SharePoint lists directly from data files, e.g.

  • Microsoft Office Excel 2007
  • Microsoft Office Excel (other versions)
  • Microsoft Office Access 2007
  • Microsoft Office Access (other versions)
  • Visual Foxpro
  • DBF / Foxpro
  • SQLite
  • Filemaker
  • Textfiles (csv)  with delimited columns or fixed length columns
  • HTML-tables

and more. You can also link SharePoint lists directly to server and services, e.g.

  • OLAP, Analysis Services -  to provide Business Intelligence data in a real SharePoint list for further processing
  • Microsoft SharePoint - to pull list data from another SharePoint site collection or installation
  • Microsoft Project - to access project management data via a SharePoint list
  • Active Directory - to provide user or device data in a custom SharePoint list
  • Microsoft Exchange - to access contacts, events, tasks or other Exchange data
  • Microsoft Index Server - to access Index Server queries via a custom SharePoint list
  • IBM Lotus Notes - to connect a custom SharePoint list to Notes data
  • Intuit Quickbase - to access online application data
    Composit Information Server - a Java-based application server
  • ODBC DSN - to connect further data sources via ODBC Data Source Names
  • UDL - to connect SharePoint lists via the Universal Data Link protocol with external data sources

You can use Enterprise Enabler for SharePoint BDLC to additionally connect SharePoint lists directly to

  • Web Services
  • XML
  • EDI
  • HL7
  • Virtual Store
  • Microsoft .Net Objects
  • COM+ Objects
  • MS Dynamics CRM
  • MS Dynamics AX
  • SAP
  • Salesforce
  • Journyx
  • Quickbooks
  • PeachTree
  • and other

Enterprise Enabler for SharePoint BDLC additionally automates complex bi-directional aggregation, transformation and manipulation of entities among multiple Line Of Business applications.

How to integrate Microsoft CRM into SharePoint 2007/2010 lists in just 15 minutes?

The video shows step-by-step, how MS-CRM / SharePoint data integration can be done in just minutes with BDLC and Enterprise Enabler. 

SharePoint BDLC has been awarded "5 stars" at x64bitdownload.com

X 64-bit Download

SharePoint BDLC has been awarded with 5 stars at bestvistadownloads.com

Best Vista Download

SharePoint BDLC has been awarded with 5 stars at Kingdownloads.com

SharePoint Business Data List Connector: 5 Star Award at kingdownloads.com !

SharePoint BDLC has been awarded with 5 stars at SoftTester.com.

SharePoint BDLC has been awarded with 5 stars at www.download3k.com

SharePoint BDLC has been awarded with 5 stars at www.soft321.com

Rated 5 stars on Soft321

SharePoint BDLC has been awarded with 5 stars at www.softwarelode.com

SharePoint BDLC is listed at ZDNet

SharePoint BDLC listed at ZDNet

SharePoint BDLC reviewed and rated 5 stars on SharePointReviews.com

"Uncountable possibilities to work with these lists further on ... just like an ordinary SPList (so, it IS an ordinary SPList)"
Reviewed by Brazzuk

SharePoint Business Data List Connector is listed on www.brothersoft.com

Software choice at www.softforall.com:

Software Downloads at FileGuru

This solution is listed on Place77

This solution is listed on softpicks.net

This solution is rated 5 stars at www.4pcsoft.com

You want to integrate Microsoft SharePoint and Exchange Server? Just take a look how we do it: Exchange content completely synced with usual WSS 3.0, SharePoint 2007 / 2010 lists (no Web Parts), e.g. Tasks, Contacts, Events...   

Microsoft Partner

 

Powered By Microsoft Office SharePoint Server 2010

 

Cloud Accelerate Partner