Pull external data to Microsoft SharePoint MOSS/WSS portal lists in just minutes with new version BDLC V1.5

Layer2, the SharePoint Experts from Hamburg (Germany), announced a new version 1.5 of Business Data List Connector, the Microsoft SharePoint extension that unlocks the value of enterprise data for SharePoint based portals.

BDLC V1.5 directly connects SharePoint lists with external LOB data sources and supports more types of data sources than ever. Almost any data from databases, Office or even text data can be displayed in SharePoint lists without any tools or programming. Workflows can be used to start business actions in SharePoint, if external data records are changed.

Hamburg, 2010-01-28 – 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. 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.

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

The Business Data List Connector (BDLC) for SharePoint 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, such as connection provider, connection string and a SQL query statement. The new version 1.5 supports more connection provider than ever, for example SQL Server, Oracle, OLEDB (e.g. Microsoft Office), ODBC or other custom provider installed. 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 sear  ch 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 on external 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 ERP or CRM data in a reusable way, e.g. with aggregations and transformations  and quickly being notified in case of changes.

Sender Name:                    Frank Daske

Sender E-mail:                  fdaske@layer2.de

Be Sociable, Share!