You are here:

Dynamics NAV Adapter

TIBCO Scribe® Insight adapters allow the Workbench and services to interface with other applications. The Adapter for Microsoft Dynamics NAV is a component that works with the Microsoft Dynamics NAV API to expose its objects and properties in the Workbench for mapping and transformation purposes. The adapter exposes virtually all of the objects supported by the Microsoft Dynamics NAV API.

The Dynamics NAV Adapter Version 3.2.1 communicates with Microsoft Dynamics NAV using NAV Application Server (NAS)-based custom logic to insert, update, and delete data according to the business rules defined in Dynamics NAV.

The adapter presents the Microsoft Dynamics NAV to the Workbench user interface, allowing Workbench users to do data mapping and transformation.

TIBCO Scribe® Insight installs a ScribeAdapterHooks.dll on the Dynamics NAV application server. Insight's Dynamics NAV Code units reference this dll which is used to communicate with the Adapter to perform query, create, update, and delete operations. See Connecting To Dynamics NAV for additional information.

The adapter simplifies data exchange between Microsoft Dynamics NAV and external applications by:

Encapsulating the business rules of Dynamics NAV, replicating the logic that is applied when you add or change records using the Microsoft Dynamics NAV user interface.
Supporting more than 900 Dynamics NAV data objects, including Customers and Ship-to Addresses, Items and Item Variants, and Sales Orders.
Supporting retrieving, inserting, updating, and deleting data in Dynamics NAV.
Dynamically adjusting to Dynamics NAV customizations without requiring recoding or recompiling.
Supporting multiple companies.

In addition, some versions introduce new environments:

Microsoft Dynamics NAV 2009 R2 — Includes Dynamics NAV 2009 R2 Classic with Microsoft SQL Server, a feature that enables you to add, modify and insert records as well as configure Dynamics NAV through the Object Designer.
Dynamics NAV 2013 — Includes the Dynamics NAV 2013 Development Environment, which enables you to configure Dynamics NAV through the Object Designer, but cannot be used to modify records. To add, modify, or insert records directly, use the Dynamics NAV Client. With the Dynamics NAV 2013 release, when you run any table from the Dynamics NAV Object Designer, that table opens in a Dynamics NAV Client window.

For more information about these features, see the Microsoft Dynamics NAV online help.

Use Cases

Use the Dynamics NAV Adapter to migrate or integrate data as follows:

Integrate Sales Orders generated in a Sales system into Dynamics NAV.
Integrate Customer data from Dynamics NAV into a Marketing Campaign application.
Move inventory information from a SQL database into Dynamics NAV.
Update product lists in your Sales application based on the product lists in Dynamics NAV.

Note: Custom Dynamics NAV code for this Adapter is developed and tested on W1 region installations. Use with other regions will require modifications.