Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview with Navision for a small Scale Business Organization

Dear Qlikview Experts

For one of our Clients, having Small Scale Business, we need to buy Qlikview Product / Licenses and Implement Qlikview Solution, for Client’s BI Reporting Requirements. To Offer the best combination of Products and Implementation Services to the Client, we need to understanding on following points. Requesting you provide the Information on the same.

1. Client has Microsoft Navision (SQL Database). Is there a Connector Available for the same ? What is its Price ?
2. What are features Available in Small Business Server Edition ?
3. Since Client has a small Scale Business, what are the alternatives to PDF Report Distribution Service and Qlikview Publisher ? Are Publisher or Report Distribution Feature also included in the Small Business Server Edition ?
4. Can you share some more Information or Documentation on Qlikview Integration with Microsoft Navision ?

Regards
Pankaj

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Welcome to the club.

Find Below answers

1) No separate connector needed. You just need a odbc or OLEDB connection to Fetch data.

2) SBE is restricted to use with 25 Named cal and 100 Document Cal, as its meant for smaller implementation.

3) In order to have PDF distribution feature, You need to purchase a separate Licences for the same, You can have a look at third party tool like NPRINTING too regarding the same.

4)what type of integration you are looking at?

Regards

ASHFAQ

View solution in original post

11 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Welcome to the club.

Find Below answers

1) No separate connector needed. You just need a odbc or OLEDB connection to Fetch data.

2) SBE is restricted to use with 25 Named cal and 100 Document Cal, as its meant for smaller implementation.

3) In order to have PDF distribution feature, You need to purchase a separate Licences for the same, You can have a look at third party tool like NPRINTING too regarding the same.

4)what type of integration you are looking at?

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Thanks for your response on 1 and 2.

For Point 3, have a further question. How feature of Qlikview Publisher can be achieved with SBE ?

For Point 4, Integration on, how we can connect Navision and Qlikview. Sample scripts for Loading Navision Tables into Qlikview etc. Any kind of Documentation on Navision - Qlikview ?

Regards

Pankaj

ashfaq_haseeb
Champion III
Champion III

Hi,

For point 3. You need to buy 2 addons from Qlik

1) QlikView Publisher a separate License ( I would say a must tool)

2) QlikView PDF Distributer (Used for PDF Report distribution) Instead of this I suggest you to go with NPRINTING.

Regarding Point 4 I'm not really sure, But below links will help you.

Navision 4.0 ODBC

Guides on Navision/Dynamics C5

Navision native database connection ?

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Thanks for you response once again.

For you Response on Point, on buying Qlikview Publisher. The Cost of SBE is $ 8400, while Publisher is $ 21000. The Cost of Publisher is high for a small scale business enterprise. Is there not any alternative to this ?

Regards
Pankaj

ashfaq_haseeb
Champion III
Champion III

Hi,

There is no alternative to publisher, Like there is for PDF distributed ( Which is NPRINTING).

But you can move on without publisher. Later you can think about buying publisher.

If you don't have publisher you have to handle security by NTFS file system, which publisher does by default.

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq,

Thanks for responding. But can data extraction scheduled batch jobs be created for Data Loads, Incremental Loads into Qlikview, without publisher ?

Regards

Pankaj


ashfaq_haseeb
Champion III
Champion III

Yes, you can do that without publisher.

Regards

ASHFAQ

Not applicable
Author

Hi Ashfaq

Using Qlikview Server, can data loads be scheduled ?

Or Are you talking about any other mechanism ?

Regards

Pankaj

ashfaq_haseeb
Champion III
Champion III

Yes, I'm talking about QlikView Server.

Regards

ASHFAQ