Requirements

You have certain questions about our products and solutions? In our FAQs you'll find the answer.   

Subnavigation

Logos

Microsoft Certified Partner

 

Powered By Microsoft Office SharePoint Server 2007

 

SelectLine Händler 2009

 

Microsoft Small Business Specialist

Citation

       "Please support us to improve our products and solutions. Give us your feedback."

Related Content

News

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
New Sharepoint 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 BDLC connects SharePoint lists directly with external data.

more
New SharePoint Meeting Manager with template-based Meeting Minutes announced by Layer2

Layer2, the SharePoint experts from Hamburg (Germany), announced a new Microsoft SharePoint extension to improve the meeting management in SharePoint based portals.

more
SharePoint User Tasks: Improved Rollup and more effective Task Management using Web Parts by Layer2

Layer2, the SharePoint experts from Hamburg (Germany), announces two new Microsoft SharePoint extensions to improve the SharePoint user tasks management.

more

Related Contacts

Frank Daske, Business Development Manager

Frank Daske, Business Development Manager +49 (0) 40 28 41 12 - 30 sales@layer2.de

Related Products

Enterprise Enabler for SharePoint Business Data List Connector

While the BDLC for SharePoint 2007 and 2010 connects any type of SharePoint list to external data sources via ODBC, OLEDB and .NET out-of-the-box, Stonebond's Enterprise Enabler for SharePoint Business Data List Connector provides advanced features.

more
SharePoint Administration, Analysis and Reporting with Axceler ControlPoint

With Axceler ControlPoint for SharePoint, you can analyze and enforce permissions, clean up user accounts, isolate sites that are no longer needed, identify sites with the most or least activity, anticipate site growth, and more.

more
SharePoint Business Data List Connector

The fast, easy and complete integration of external data, eg from databases, is a common requirement in the use of Microsoft SharePoint technology. The SharePoint Business Data List Connector offers this with full list features.

more

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.

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.

Related Links

Rate and discuss Layer2 SharePoint Web Parts and solutions on Microsoft Pinpoint

Pinpoint is a dynamic technology marketplace and the largest directory of qualified IT providers and their software built on Microsoft technologies. Microsoft Pinpoint helps business customers like you find experts, software applications, and professional services to meet your specific business needs and build on your technology investments.

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.

FREE Affiliate Registration for Layer 2 GmbH

Register as an affiliate with Layer 2 GmbH. As an affiliate, you can market the publisher's products by placing links on your Web site to the relevant product pages on the publisher's Web site. You will receive 20% commission for each sale of these products via your Web site.

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 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

Main Content

Claim

These FAQs are about the SharePoint Business Data List Connector (BDLC) product only. For any questions please use the FAQ Web Form or contact sales@layer2.de directly.

FAQs - SharePoint Business Data List Connector (BDLC)

Why we made it?

The fast, easy and complete integration of external data, eg from databases is a common requirement in the use of Microsoft SharePoint technology. Existing solutions, such as the Business Data Catalogue (BDC), are often too complex at the facility.

more

How to create a valid OLEDB connection string in SharePoint to connect my custom list to my external data source?

To connect a SharePoint List directly with an external data source, please use the SharePoint Business Data List Connector (BDLC). This FAQ is about how to create a valid OLEDB connection string to the external data source in SharePoint.

more

How to create a valid select statement in SharePoint for SQL Server as external list data source?

To connect a SharePoint list with a SQL Server table or view using the SharePoint Business Data List Connector (BDLC) you have to add a valid select statement. Here some samples are given.

more

How my external data source fields are mapped to my SharePoint list columns?

If a SharePoint List is connected directly with an external data source using the SharePoint Business Data List Connector (BDLC) the BDLC automatically creates the required list columns. But what about field types?

more

How to create a valid OLEDB select statement in SharePoint to connect Excel as external data source?

You can use the SharePoint Business Data List Connector (BDLC) to connect Excel as your external data source to a SharePoint list. This FAQ is about how to create a valid selection statement for this.

more

How to manage background update settings?

In the BDLC list settings dialog you can enable or disable background updates only. There are no further settings about timer interval, next run etc. But how to manage these settings?

more

Feature comparision: SharePoint 2010 External List vs. SharePoint BDLC List

The SharePoint 2010 external list via BCS is a great step forward with data integration. But it's not a REAL SharePoint list. And that's why it hasn't ALL list features - as the BDLC list has.

more

How to update SharePoint BDLC lists on demand per URL or on page load?

With SharePoint BDLC V1.6 you can update BDLC lists on demand per URL or on page load.

more

How to remove unused columns in the SharePoint BDLC list

You can simply remove unused columns in your SharePoint BDLC list by deleting it. Missed columns are skipped during updates and cause no problems. Warning: You should not remove columns that host primary keys.

more

How to connect to a SharePoint list using an OLE DB connection string?

The BDLC can be used to pull data from other SharePoint lists for any reason.

more

Can I add additional columns / fields to my BDLC list to edit it?

Yes, you can add additional fields after list creation without any restrictions.

more

How to connect a custom SharePoint list with external Microsoft Exchange data using the BDLC

SharePoint out-of-the-box can sync some data in Microsoft Exchange to same lists in SharePoint. Connecting a custom SharePoint list to Exchange or Outlook with the BDLC to pull data into this list is a more general approach.

more

How to connect a custom SharePoint list directly with an Oracle database table as external LOB data source?

You can connect a custom SharePoint list directly with external data from Oracle database tables or views using the Business Data List Connector (BDLC).

more

How to pull external data in a SharePoint Person / Group list column with BDLC?

You have to pull the user's / group's ID from the User Information List in the current SharePoint Site Collection into the user / group picker field to reference to a certain user or group.

more

How SharePoint BDLC can be used with Integrated Security / Trusted Connection?

About using SharePoint BDLC with NTLM Authentication, Basic Authentication, Kerberos and Trust computer for delegation privilege in Active Directory (AD) or explicit credentials.

more

How to set some or all SharePoint BDLC list columns / fields read-only?

Using a BDLC list you can add collboration content to LOB data for example. To prevent users from editing content, that come from the external data source, some or all SharePoint list columns / fields can be set read-only.

more

How to connect Sharepoint lists directly to Active Directory data to access users or devices?

You can connect a custom SharePoint list (no Web part) directly with external data from Active Directory, e.g. users or devices, using the SharePoint Business Data List Connector (BDLC).

more

How to connect SharPoint 2007 / WSS 3.0 lists to Office 2010 data with the Office System Driver: Data Connectivity Components?

To connect Microsoft Office 2010 data directly to SharePoint 2007 / WSS 3.0 lists, without Office installed on the server, you have to install the Office 2010 System Driver - Data Connectivity Components.

more

How to fill SharePoint link columns with external data using the SharePoint BDLC?

You can fill SharePoint link columns from external data using the BDLC without any problems, if you follow these steps.

more

How to connect Microsoft Dynamics NAV (Navision 4) tables or queries directly to SharePoint lists?

How to configure BDLC to link a SharePoint MOSS/WSS list to a Microsoft Dynamics NAV 4.0 (Navision) non SQL Server table or query via C/ODBC directly in the list settings dialog without any programming or tools.

more

What's new with SharePoint BDLC Version 3.0 (released 17 May 2010)

BDLC V3.0 finally comes with optional write-back to external data source features. CRUD (Create, Update, Delete) is fully supported for the external data source, if SharePoint list items are created, updated or deleted.

more

How to connect SharePoint lists directly to SAP data?

You can use Stone Bonds .NET-based Enterprise Enabler as a driver, to connect any SharePoint 2007 / 2010 list directly to SAP data via Business Data List Connector for SharePoint 2007 / 2010.

more

How to connect a SharePoint list directly to IBM Informix Database data without any Programming

First you have to install the appropiate .NET based provider (driver) on application server and web frontend server. Please take care about 32/64-bit: The driver should be the same as your SharePoint currently runs.

more

What's new with SharePoint BDLC Version 2.0 (released on 2010-04-16)

With BDLC 2.0 now you can connect any existing SharePoint list to external data, e.g. contacts, tasks etc.

more

What's new with SharePoint BDLC Version 1.6

BDLC V1.6 comes with greatly improved field / column mapping features.

more

What's new with SharePoint BDLC version 1.5

SharePoint BDLC 1.5 comes with highly improved support for much more external data sources.

more

BDLC - Known issues & workarounds with V1.02 (outdated)

There are some known issues and workarounds with the BDLC version 1.02.

more