A connector for QlikView, Qlik Sense and Microsoft Dynamics 365

Starting with the NAVdisocvery Toolbox directly

prisma informatik has developed the NAVdiscovery Toolbox specifically for users of Microsoft Dynamics NAV (now Dynamics 365 Business Central) 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 365, e.g. 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 Dynamics 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 Microsoft Dynamics 365 environment in a user-friendly and convenient manner. The NAVdiscovery Script Generator can be used to create the Qlik data model for the different ERP-modules directly, for example:

  • Finance Management
  • Purchasing and 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 (now Business Central). 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 templates 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
  • Tables, Pivot tables
  • and more

Dynamics 365 Integration

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

Using Dynamics 365 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 365.

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

Certified Solution

The NAVdiscovery Toolbox is a solution that is certified for Microsoft Dynamics  (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.