Requirements

You can't wait for BCS and External Lists in SharePoint 2010? Just try the BDLC!   

Subnavigation

Logos

Microsoft Certified Partner

 

Powered By Microsoft Office SharePoint Server 2007

 

SelectLine Händler 2009

 

Microsoft Small Business Specialist

Citation

       The Business Data List Connector extends the SharePoint collaboration and search capabilities as well as the Office user experience to include external business data and the processes that are associated with that data.

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
Jump-start Microsoft SharePoint 2010 Knowledge Management using pre-defined Taxonomy Metadata

Pre-defined taxonomies can greatly accelerate Knowledge Management projects. You can now download and evaluate Microsoft SharePoint Server 2010 Taxonomy samples for FREE after registration.

more
Layer2 Announces Partnership with Axceler for SharePoint Administration and Management

Layer2, the SharePoint Experts from Hamburg (Germany) announced a strategic partnership with Axceler, the global leader in administration software for Microsoft SharePoint.

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
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
Even four new Microsoft Certifications for Layer2 employees in 2008

Even four Layer2 employees have passed successfully their Microsoft Certification Exams in 2008. Layer2 also in the future will continue the training to ensure high quality in customer projects.

more
Layer2 Consultant Robert Dräger presents SharePoint WCMS at BASTA

The Layer2 SharePoint consultant Robert Dräger, this year will share his experience he has gathered with Internet and intranet solutions based on SharePoint 2007 Web Content Management System in a workshop on the 2007 BASTA Conference.

more

Related Contacts

Frank Daske, Business Development Manager

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

Matthias Hupe, SharePoint Consultant, Business Management

Matthias Hupe SharePoint Consultant, Business Management +49 (0) 40 28 41 12 - 10 Info@layer2.de

Robert Dräger, SharePoint Consultant, Business Management

Robert Dräger, SharePoint Consultant, Business Management +49 (0) 40 28 41 12 - 10 info@layer2.de

Related Products

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

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, The SharePoint Experts from Hamburg / Germany: RSS News

Corporate News of Layer 2 GmbH as RSS News Feed.

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 Magazine

SharePoint Magazine is an online magazine dedicated to the world of SharePoint and related Information Worker Technologies.

Main Content

Claim

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 (no web parts) 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.

Sharepoint Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0 

Microsoft SharePoint technology is increasingly used in SMBs and larger companies as a business collaboration platform for the enterprise and the web, to connect and empower people, to cut costs with a unified infrastructure and rapidly response to business needs. The free Microsoft Windows SharePoint Services 3.0 or – depending on requirements – the Microsoft Office SharePoint Server 2007 are used to implement business solutions for collaboration, document management, enterprise content and records management, business intelligence, forms service and company-wide search.

The fast, easy and complete integration of external LOB data, e.g. from databases or Office files, is a common requirement in the use of Microsoft SharePoint technology. While traditional legacy applications often lack in user experience, existing data integration solutions for SharePoint - such as the Business Data Catalog (BDC) - are often complex at the facility, require additional tools, bring with them limitations or they are available for certain SharePoint editions only.  

Connect business data to MOSS and WSS lists without any programming or tools  

The SharePoint Business Data List Connector (BDLC) offers a "SharePoint External List" by connecting a real SharePoint list (no Web Part) to external business back-end data, using a very simple web-based list settings dialogue. No programming or additional tools are required. The BDLC can be configured easily with a few simple list settings only directly in the browser. The desired data can be populated to the list and presented with the familiar UI and navigation features of common SharePoint lists made available: Views, sorting and grouping, filters, calculated fields. Lookup features can be created as usual for presentation of and interaction with external data in SharePoint lists.

The Business Data List Connector extends the SharePoint collaboration and search capabilities as well as the Office user experience to include external business data and the processes that are associated with that data.   

Start workflows in SharePoint to take business actions if external LOB data changes  

The list data can be updated manually or automatically in background, using a timer service. List workflows and notifications per RSS or email can be used out-of-the-box, to take business actions in SharePoint, if external LOB data records are changed. For example the Business Data List Connector can be used to implement a sales dashboard application, which empowers end users to gain insight into the underlying data in a reusable way, e.g. with aggregations and transformations  and quickly being notified in case of changes.Externe Daten können einfach mit SharePoint Listen verbunden werden

Fig.: The BDLC connects almost any LOB data source directly to SharePoint (MOSS/WSS) lists.

Download and evaluate the SharePoint Business Data List Connector today  

The new SharePoint add-on comes with a robust installer to allow it to be easily deployed within any SharePoint environment, including farms. It currently is available for SharePoint starting with WSS 3.0 and MOSS 2007. You can download it directly on the vendor’s product pages at www.layer2.de/en/products. A completely free to use shareware version is also available.  

FREE to use for SharePoint User Groups (SPUG)  

All components offered by Layer2 are completely FREE to use within a registered SharePoint User Group web site (back-link and logo required).  

Cost-free partner program for implementers and affiliates  

A cost-free partner program was launched to support companies that are interested to sell and implement Layer2 products around the world. Registered affiliates can market Layer2 products by placing links on their web sites to the relevant product pages of the Layer2 web shop on www.share-it.com. They will receive a 20% commission for each sale of these products via their web site. Additionally implementers receive qualified leads to make use of Layer2 solutions in their own projects. Please register and join today!