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
FREE SharePoint for Internet (MOSS-FIS) licenses for MS Partners

As a Microsoft Certified or Gold Certified Partner get on board with Layer2 to create an Internet facing SharePoint web site for your company.

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

Enhanced SharePoint User Tasks Menu

The Enhanced SharePoint User Tasks Menu Feature enables users to set the due date and other properties of a task item directly with one click using the SharePoint item menu.

more
Enhanced SharePoint User Tasks Web Part

If working with SharePoint collaboration portals, numerous task lists exists in the various areas of work. With the Enhanced SharePoint User Tasks Web Part by Layer2 you can rollup these tasks from various lists of the site collection.

more
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 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
SharePoint Content Query List

The SharePoint Content Query List offers full list-based features for dynamic query results as a Content Query Web Part (CQWP) replacement.

more
SharePoint List Item Sort Feature by Layer2

The SharePoint List Item Sort Feature by Layer2 makes the manual sorting feature available in the user interface for all types of lists.

more
Free SharePoint Web Part Download: Localized Date Web Part

The free SharePoint Localized Date Web Part by Layer2 displays the current date information localized for the currently selected language of the web site. Please download now for free.

more
SharePoint Meeting Manager

SharePoint out-of-the-box includes basic meeting management features. Typically customer requirements go far beyond this, e.g. with access rights, protocol design and function, workflow management and follow-ups.

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. 

Layer2 components are completely FREE for registered SharePoint User Groups (SPUG)

All Layer2 components are completely FREE to use for registered SharePoint User Groups on their web sites (backlink and logo required).

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

The valid syntax of the select statements depends on the types of data sources used. Below there are given some samples for Microsoft Excel data sources, that are often used with the SharePoint Business Data List Connector (BDLC).

 Excel data pull to SharePoint list

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

Excel connection to SharePoint


Please take a look at the following examples:

1. "SELECT * FROM [Sheet1$A:E]"   

2. "SELECT * FROM [Sales$A:E] WHERE Name='Bob'"   

Name being the column heading which will get treated as a recordset field.