0

Jet installation for NAV on Azure SQL

David Caruana

October 31, 2017 11:07

None

Follow

Hi

We have some clients which have NAV on an Azure VM and their data on Azure SQL.

How should we connect Jet Professional for the best performance?

I have set the connection method to Direct SQL, but found the below article which suggests for a Universal Database Type rather than NAV 2013 or later.

https://jetsupport.jetreports.com/hc/en-us/articles/219403307-Setting-up-an-Azure-SQL-data-source-in-Jet-Professional

Also, would you recommend to run the reports from the Jet web portal rather than from the local Excel (with the Jet add-on) for better performance?

 

thanks

Dave

 

 

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis October 31, 2017 14:27

  Hello David -

  Microsoft SQL Server and Azure SQL Server are such different creatures that connections to them must also be very different.  Thus, the article you found is the correct method for configuring the Jet Excel add-in for accessing an Azure SQL database.

  If you are going to be using the Jet Web Portal (and, yes, there are some strong advantages for doing so) and the associated database will resided in Azure SQL, you'll also want to following the directions for configuring that.  

  Those instructions are included with the installation set itself:

  

  

  

• 0
  
  David Caruana October 31, 2017 16:51

  Thanks Harry

  Currently with the client's licence I can create only a Dynamics NAV Database type, so would they need to pay extra to also have the universal connector?

  

  regards

  Dave

   

   

   

   

• 0
  
  Harry Lewis October 31, 2017 22:11

  Hi David -

  That would be a question for the Jet Licensing Team (orders.us@jetreports.com). They would be able to ensure that the client has what is needed.