Dynamics NAV Integration

Microsoft Dynamics NAV (on-premises or Online) data can be integrated and synchronized codeless with Office 365, SharePoint and 100+ other data sources using the Layer2 Cloud Connector via the Layer2 Data Provider for OData. Please take a look here for a selection of supported systems and applications.​​​​​

Microsoft Dynamics NAV Data Integration with Office 365 and 100+ others

Integration of Dynamics NAV with Office 365 and SharePoint

To connect and sync Microsoft Dynamics NAV 2013 and 2015 data entities, the data source must be configured as follows in the Layer2 Cloud Connector Connection Manager:
SharePoint or Office 365 Integration with Dynamics NAV 

Fig. Example connection configuration to connect to Microsoft Dynamics NAV data via OData.

Microsoft Dynamics NAV Specific Settings

​Please note the following specific settings.
  • Select the OData Data Provider to connect. The provider is part of the Layer2 Cloud Connector ADO.NET provider package and should be already installed. You will find an OData Provider specification here.
  • You can use a connection string like this to connect:
    url=http://myNAVServer:7048/DynamicsNAV80/OData/; Collection=Customers; Authentication=Windows; User=domain\username; Password=myPassword
  • Several different authentication methods are generally supported. See provider specification linked above for more.
  • You can make use of OData to query your data as supported by the data provider and source system. For more information about supported queries, see Microsoft Dynamics NAV OData specification.
  • You can map your data fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • Please enter an appropriate primary key (column with unique values), depending on query (use the data preview to find an appropriate field for this).
  • You can use the connection for uni- or bi-directional synchronization. In case of inserts (full CRUD) via external systems, please take care of the primary key.
  • Note that NAV 2013 supports read-only. NAV 2013 R2 and NAV 2015 supports both read and write functionality.
  • No installation or changes are required at the Dynamics CRM data source or data destination.
  • It may be required that a simple web service be published through the NAV Administration tool to expose the data you want in the OData service. See the Dynamics NAV OData specification for more information.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.

Step-by-Step Intros for Dynamics NAV Data Integration and Synchronization

Just some ideas what to connect next:

  • Sync Microsoft Dynamics NAV (on-premises or online) via OData with SharePoint or Office 365.
  • Sync with SQL Server or SQL Azure for improved reporting via SSRS.
  • Sync with Microsoft Exchange (on-premises or online) for notifications, contacts, tasks, calendar events, mobile access and offline availability on any device.
  • Sync with 3rd party tools based on SQL databases like Oracle, mySQL or Microsoft SQL Server.

Can't find what you are looking for? Take a look here for supported systems or contact [email protected] for help.

Next Steps for Evaluation

​​​​You can register to download and evaluate the Layer2 Cloud Connector here.
Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

We had the requirement to connect and sync data between Microsoft Dynamics NAV and SharePoint. No issues with the Layer2 installation, trial and go live. I would definitely recommend the product to others.

 

 Download & Evaluation

 
Please register now to receive your free personal download link via email to your valid company email address.
Name: 
Company: 
Country: 
Phone: 
E-mail: 
Yes, I accept the licensing terms and conditions
How to buy this product
​​

With the free Shareware Edition you can manage a limited number of items per connection. To order a license for the full version please click the shopping cart below.

Layer2 Cloud Connector
License List price Buy Now
FREE Shareware Edition * $0.00
FREE App Edition *
App Store only
$0.00 Go to App Store
Personal Edition
1 Single Server
License (one-time fee)
$499.00 Add to Shopping Card
1 Annual Software Assurance
for Personal Edition
$99.00 Add to Shopping Card
Professional Edition
1 Single Server
License (one-time fee)
$1,407.00 Add to Shopping Card
1 Annual Software Assurance for Professional Edition $281.00 Add to Shopping Card
Enterprise Edition **
1 Single Server
License (one-time fee)

$6,390.00

$1,290.00

File Sync Edition***
1 user annual subscription
$150.00
Prepaid Remote Support
1 Hour
$176.00 Add to Shopping Card
Please contact [email protected] in case you want to order directly via Layer2 based on quote, invoice and bank transfer to Germany.

 

* The Shareware Edition and App Edition is limited to sync 25 items per connection.

** Starting with January 2015 all features of the Enterprise Edition are already included in the Professional Edition.

*** The File Sync Edition is limited to local file synchronization with any specific Office 365, SharePoint or OneDrive4B. The license is per user annually with a minimum of 50 licenses. Not yet available for online order. Please contact [email protected] if interested.

Contact
Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.

Oracle now fully integrated with Microsoft Office 365 via Layer2 Cloud Connector

​100+ most common IT-systems and apps like SQL, ERP/CRM are supported for Oracle data integration and sync, as well as Microsoft Office 365, SharePoint, Dynamics, Exchange, Office Groups, and Azure.
Related Downloads
PDF Image

Product Flyer: Business Data List Connector for SharePoint

SharePoint on-premises external data integration with 100+ sources: Product flyer (PDF) in English for download.
PDF Image

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

Flyer with features, benefits & pricing info for download as PDF.
PDF Image

Product Flyer: Layer2 Knowledge Management Suite for SharePoint

Assign accurate managed metadata automatically to SharePoint items and documents.
PDF Image

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.
PDF Image

Solution Flyer: Microsoft Dynamics CRM Data Integration

Microsoft Dynamics CRM Codeless Data Integration and Synchronization via Layer2 Cloud Connector.
Related Links

Microsoft Dynamics CRM Homepage

​Microsoft Dynamics CRM is a customer relationship management (CRM) business solution that drives sales productivity and marketing effectiveness through social insights, business intelligence, and campaign management in the cloud, on-premises, or with a hybrid combination.