Qlik - Self Service Business Intelligence
and Data Discovery

A analysis platform for all your requirements

Explore more Qlik Sense

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 / 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 NAV / Business Central 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 / Business Central 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
  • 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 365 Business Central (formerly 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 365 Integration

The NAVdiscovery Toolbox allows QlikView and Qlik Sense analyses to be integrated directly into the interface of Microsoft Dynamics NAV / Dynamics 365 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 NAV / Business Central.

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.