Qlik - Self Service Business Intelligence
and Data Discovery

Explore more Qlik

A connector for QlikView, Qlik Sense and Microsoft Dynamics NAV

Starting with the NAVdisocvery Toolbox directly

prisma informatik has developed the NAVdiscovery Toolbox specifically for users of Microsoft Dynamics NAV and Qlik products. NAVdiscovery minimizes the preliminary technical work required to integrate the systems, automates script creation and offers numerous other features. The toolbox can also connect Microsoft Dynamics CRM as a data source to the Qlik solutions.

NAVdiscovery Factsheet


Comfortable Script Generator

NAVdiscovery does not provide a ready-made script as other connector solutions do. Rather, data models for QlikView and Qlik Sense can be automatically generated from the respective NAV environment very comfortably.
NAVdiscovery enables all customer-specific extensions and adjustments to be transferred this way − irrespective of the databases degree of customization.

Script creation takes place directly in the respective NAV environment in a user-friendly and convenient manner. The NAVdiscovery Script Generator can be used to create the Qlik data model for the different NAV-modules directly, for example:

  • Finance Management
  • Purchasing
  • Sale
  • Warehouse
  • Project
  • Manufacturing

Integrated Grouping Function

The NAVdiscovery Grouping Function allows ERP data to be restructured for analysis purposes without the need for additional extensions within Microsoft Dynamics NAV. The Grouping Function offers a wide range of applications for various purposes:

  • Charts of accounts   
  • Financial statements according to applicable laws and regulations (e.g. IFRS)
  • Profit and loss accounts, management analysis   
  • Groupings of accounts for key performance indicators (KPI)   
  • Cost center, cost unit, and cost element planning   
  • Creation of cluster analyses for customers, articles, etc.

The individual dimensions can be adjusted according to the respective requirements at any time. New dimensions can be added whenever needed.


Interface Design

With the various analysis layouts already integrated in the Toolbox, users can work immediately with the interfaces tailored to their department, or they can adjust and extend them according to their needs.
The layout templates are based on the scripts generated beforehand and are adapted according to the individual departments. These basic layouts can be flexibly combined with one another, customized and extended.

Your illustration facilities:

  • Pie charts
  • Line charts
  • Bar charts
  • Combination charts
  • TablesPivot tables
  • and more

Dynamics NAV Integration

The NAVdiscovery Toolbox allows QlikView and Qlik Sense analyses to be integrated directly into the interface of Microsoft Dynamics NAV. This way, the analysis possibilities within the ERP system can be considerably expanded.  

Using Dynamics NAV Integration, any Qlik objects can be embedded into the ERP system on different user-defined levels. Integration is possible on one of the main start pages, in list views, or on more detailed levels, depending on needs. Basically speaking, any desired Qlik components can be integrated on any page into Microsoft Dynamics NAV.

The Qlik objects remain completely interactive within Dynamics NAV – just as if one were directly in the application.

Certified Solution

The NAVdiscovery Toolbox is a solution that is certified for Microsoft Dynamics NAV (CfMD). A separate number range with no need to change standard objects allows for conflict-free integration into the respective ERP environment. Our customers are thus able to implement Qlik products into their software environment within a very short time.