topic QlikView template for Dynamics NAV in QlikView

QlikView template for Dynamics NAV

Wed, 02 Mar 2011 10:36:34 GMT

Hi,

I need to know if it exists a QV template to connect to NAV and use the related tables in an efficient manner. Other BI vendors provide a specific accelerator for NAV applications.

Many thanks

QlikView template for Dynamics NAV

Wed, 02 Mar 2011 11:09:12 GMT

This is a simple SQL connection.

If you know well NAV tables, you should have no problem

Re:QlikView template for Dynamics NAV

Wed, 02 Mar 2011 11:22:31 GMT

Hi,

I'm not only referring to connect to the SQL Server db for a NAV application but to connect and load data from a set of table organized by area or scope or other way. I repeat that other vendors have a specific accelerator to create a BI solution for NAV.

I don't want to reinvent the wheel.

Thanks

Re:QlikView template for Dynamics NAV

Sat, 02 Feb 2013 20:25:28 GMT

Hi all,

there is another NAV Connector "NAV2QLIK" for QlikView from QlikView Solution Provider prisma informatik GmbH located in Germany.

"The preparation and connection of ERP data from Microsoft
Dynamics NAV into QlikView usually means a tedious and time consuming task to
end users.

To simplify this process and to reduce the preparatory work
to a minimum, prisma informatik has developed the NAV2Qlik Toolbox. On the part
of users, neither profound QlikView knowledge nor elaborate support by the
internal IT department is necessary during the ETL process. The NAV2Qlik Toolbox comes with the N2Q Script Generator, which generates the
required QlikView Scripts for data modeling automatically. Further components
are the N2Q Grouping Function and the N2Q Templates, which provide various options
for interface design in QlikView.

Especially the customizations within their ERP data are
particularly valuable for users of BI software. For this reason and unlike
other connector solutions, NAV2Qlik delivers no pre-built script, but can
generate the QlikView data model automatically direct from the specific NAV environment.
That way, NAV2Qlik enables the transfer of any
custom-built extensions and modifications within Microsoft Dynamics NAV - no matter how
individualized the database is. A separate number range without modifying
standard objects allows a conflict-free integration into the ERP environment."

http://www.prisma-informatik.de/qlikview/nav2qlik/