With the NAVdiscovery Toolbox developed by prisma informatik, the BI solutions Qlik Sense and QlikView can be quickly and easily linked with Dynamics NAV or Dynamics 365 Business Central as well as Dynamics CRM and many other data sources. The release of the new version 2.01 NAVdiscovery includes some new features.
The new functions in NAVdiscovery 2.01 concern in particular the grouping function and the task administration. In addition, the release contains new features regarding the SQL SELECT statement, the option to generate NAV links automatically and a new test mode.
Scheduler (Automated Task Management)
By setting up recurring tasks, NAVdiscovery processes (e.g. Full Back-up, Qlik Script Export, updating grouping elements) can now be executed cyclically and automatically.
Two tables can now be combined as data source in a grouping.
Automatically Generated NAV Links
In each exported NAV table, a corresponding NAV link is generated by the NAVdiscovery Export. Data records can be selected directly from Qlik.
Editing the SQL SELECT Statement
NAVdiscovery 2.01 enables the processing of the SQL SELECT statement for queries on SQL level and the direct selection of the data on database level.
By activating the test mode (test of “where”-condition and “select”-command) it is possible to test loading conditions without changing the original query.
By using group elements, you can create your own table in NAV with individual, self-defined contents and use it for grouping functions in NAVdiscovery.
NAVdiscovery 2.01 is available for Dynamics NAV 2016 and newer versions. In addition to the new version of the Management Suite, we are planning to release further connectors for Qlik Sense with the Dynamics 365 product family in the next weeks. We will keep you up to date!