"Please support us to improve our products and solutions. Give us your feedback."
Frank Daske, Business Development Manager, Layer 2 GmbH
Frank Daske, Business Development Manager +49 (0) 40 28 41 12 - 30 sales@layer2.de
SharePoint – New Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0Layer2, 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.
This XML-based PAD file offers a BDLC product description for resellers to download and publish.
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.
United States:
Great Britain, Scotland and Ireland:
France:
Netherlands:
Switzerland:
Poland:
Turkey:
South Africa:
Malaysia:
Start NINTEX Workflows while external data changes.
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).
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.