Tag Archives: MULTIPLE DATA SOURCES

prisma informatik publishes NAVdiscovery 2.01

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.

Automated Task Management with NAVdiscovery 2.01
Automated Task Management with NAVdiscovery 2.01

Double Grouping
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.

Automatically generated NAV Links in NAVdiscovery 2.01
Automatically generated NAV Links in NAVdiscovery 2.01

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.

Test Mode
By activating the test mode (test of “where”-condition and “select”-command) it is possible to test loading conditions without changing the original query.

New Test Mode in NAVdiscovery 2.01
New Test Mode in NAVdiscovery 2.01

Neutral Grouping
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!

NAVdiscovery 2.0 – Toolbox Now Available For Qlik Sense

Among the numerous solution approaches in the area of Business Intelligence for Microsoft Dynamics NAV, external analysis systems like QlikView and Qlik Sense in particular represent a genuine, high-quality alternative. Because these independent solutions are connected from outside to the ERP system, additional sources can also be integrated without any problems. In this way, the Qlik platform offers the option to combine and consolidate the most diverse systems.

With the newly released version of NAVdiscovery 2.0, the QlikView and Qlik Sense business intelligence solutions may now be easily and conveniently connected to and managed with Dynamics NAV, Dynamics CRM, and numerous other data sources.

Qlik Sense Integration Dynamics NAV Dynamics CRMScript Builder for Qlik Sense
Using the expanded NAVdiscovery Script Builder, the data models for QlikView and Qlik Sense may be produced directly from the individual NAV environment. The desired information can be directly selected, renamed and connected full-automatically. This way, the respective LOAD scripts may easily be created at the press of a button for QlikView, Qlik Sense, or both analysis solutions.

Connector Dynamics NAV Dynamics CRM QlikView Qlik SenseDirect integration for Qlik Sense
In addition, any evaluation and analysis views of both Qlik products may be integrated directly into the interfaces of Dynamics NAV or Dynamics CRM using NAVdiscovery Integration. The systems’ evaluation options may therefore be easily expanded with much more, and relevant key indicators are available at every possible position. The QlikView and Qlik Sense elements to be displayed may easily be configured and changed via the NAVdiscovery menu.

Multiple Data Sources Integration Qlik Sense Dynamics NAV Dynamics CRM Cloud ExcelManagement of multiple data sources
With NAVdiscovery 2.0, integration and management of multiple data sources has also been added. An agile QVD concept enables any other data sources to be integrated and consolidated in addition to Dynamics NAV. This makes the implementation of diverse usage scenarios like easy operation of multiple NAV clients or the integration of Dynamics CRM and other data sources flexible.

NAVdiscovery 2.0 live at Convergence Europe 2015
From the 30th of November to the 2nd December, prisma informatik will present the new release of the NAVdiscovery Toolbox within the context of Microsoft Convergence Europe. This event qualifies as a meeting point for the Microsoft Business Community and warmly welcomes all of its partners, customers, and interested parties again this year.

To arrange a meeting, simply send an e-mail to vertrieb@prisma-informatik.de or contact us by calling 0049 911 239 805 – 77. If you will not be visiting Convergence personally, then we would be delighted to keep you up to date via our Twitter account.