Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-06-30 08:47 AM

How to connect to MS Navision 5.0 in Qlik Sense?

Hi all,

I'm able to connect to most of the databases I want to through OLEDB because they are SQL servers. However, I'm having some trouble connecting with MS Navision 5.0. Can anyone offer a simple walkthrough for me? Thanks.

3,167 Views
0 Likes
11 Replies
richard_chilvers
Specialist
Specialist
‎2015-06-30 09:53 AM

Hi

If you search on this forum for Navision 4, you will see there is some advice on connections. I have no experience of QlikSense, but I use QlikView with NAV and assume its similar. I use the ODBC connector.

Hope it helps.

1,854 Views
0 Likes
Not applicable
‎2015-06-30 09:57 AM
Author

In response to richard_chilvers

Does this require the use of a specific driver? If so, is this a free product to download?

1,855 Views
0 Likes
Anonymous
Not applicable
‎2015-06-30 09:59 AM
Author

Hi Jordan,

perhaps NAVdiscovery (Qlik Toolbox for Dynamics NAV) can help you with your problems.

It was developed specifically for users of Microsoft Dynamics NAV, Qlik Sense and QlikView.

NAVdiscovery minimizes the preliminary technical Work required to integrate and connect the systems, automates script creation and offers many other features.

Find more information on http://www.navdiscovery.com/ and

http://www.prisma-informatik.de/newsroom/tag/navdiscovery/

Regards, Andrea from prisma informatik

1,855 Views
0 Likes
richard_chilvers
Specialist
Specialist
‎2015-06-30 10:02 AM

In response to

Hi

I thought the appropriate ODBC driver was installed along with NAV. Perhaps you could ask your software advisor ?

Regards

1,855 Views
0 Likes
Not applicable
‎2015-06-30 10:04 AM
Author

In response to richard_chilvers

That's what I had originally assumed. However, when I click ODBC to make a new connection, there are no drivers listed.

1,855 Views
0 Likes
richard_chilvers
Specialist
Specialist
‎2015-06-30 10:34 AM

In response to richard_chilvers

I think you might need to speak to your local IT guys who setup permissions etc. They could install the driver, or failing that, your NAV software provider.

1,855 Views
0 Likes
Not applicable
‎2015-06-30 10:44 AM
Author

In response to

‌Hi,

this is Claudius from prisma informatik in Germany. We are Qlik Solution Provider and Dynamics NAV Partner.

The problem is, that Dynamics NAV ODBC Driver is 32bit. You have to call the ODBC32bit program to configure ir on your device. The standard ODBC Setting is for the 64bit drivers.

I hope this will help you.

For further special items with Dynamics NAV and Qlik visit www.navdicovery.com

Claudius

1,855 Views
0 Likes
Not applicable
‎2015-06-30 10:46 AM
Author

In response to

‌www.navdiscovery.com

1,855 Views
0 Likes
richard_chilvers
Specialist
Specialist
‎2015-06-30 10:56 AM

In response to

This looks like being just the tick box on the connection screen ?

1,855 Views
0 Likes