Citation

       With the BDLC you can link SharePoint lists directly to Microsoft Dynamics NAV 4.0 (Navision internal database) tables or queries via C/ODBC in just minutes.

Frank Daske, Business Development Manager

Related Content

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.

xml ImageBusiness Data List Connector PAD File

This XML-based PAD file offers a BDLC product description for resellers to download and publish.

pdf ImageFlyer: Layer2 Partner Program

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.

Related Links

Are you looking for Layer2 product resellers and implementation partners?

United States:

Great Britain, Scotland and Ireland:

France:

Netherlands:

Switzerland:​

Poland:

Turkey:

South Africa:

Malaysia:

Aptrio Download Store

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Main Content

Claim

You can pull extenal data from a Microsoft Dynamics NAV 4.0 (Navision internal database, non SQL Server) to SharePoint (MOSS/WSS) lists via C/ODBC with update using the SharePoint Business Data List Connector (BDLC). All SharePoint list features are available, e.g. workflows, if external data changes. 

SQL Server Cobbection to SharePoint List

How to connect Microsoft Dynamics NAV 4.0 (Navision) tables or queries via C/ODBC directly to SharePoint lists?

You can connect Microsoft Dynamics NAV (Navision 4) non SQL Server tables or queries directly to SharePoint lists in just minutes using the Business Data List Connector following these steps:

  • Install the Microsoft Navision driver (CODBC) on the SharePoint Server
  • Create an ODBC connection. Take care, that you use System DSN.

Microsoft-Dynamics-NAV-Navision-ODBC-Settings

Fig.: ODBC connection for Microsoft Dynamics NAV - Navision 4 (internal database) using C-ODBC driver

  • Setup the existing ODBC connection in the SharePoint BDLC list settings dialog

BDLC-Settings-to-connect- Dynamics-NAV-Navision-SharePoint-ODBC
Fig.: Configure BDLC to link a SharePoint MOSS/WSS list to a Microsoft Dynamics NAV (Navision) query directly in the list settings dialog without any programming or tools.

  • Enter a valid SQL query statement
  • Create the SharePoint list structure automatically
  • Update your data manually or in background, using a timer job