How Do I: Easily Connect to External Databases from CAL in Microsoft Dynamics NAV 2016

It seems that I have missed the publication of my “How Do I” video in April.
Normally when Plataan and Microsoft publishes a video on youtube it appears on the Dynamics NAV blog (https://community.dynamics.com/nav/b/navvideos). But for some reason this one not. But no worries it was already on youtube.

In this video I have covered the new way of connecting to External Database from CAL.

Since NAV2016 we can easily connect to other SQL databases without making “Linked Views”.
You can make a connection right from CAL and NAV will get all the data into a NAV table.
Super easy.

There is a new property available on tables where you can define the “TableType”.

And the following CAL functions will be used to change and establish an external connection.

  • HASTABLECONNECTION : Verifies if a connection to an external database exists based on the specified name.
  • UNREGISTERTABLECONNECTION : Unregisters a table connection between Microsoft Dynamics NAV and an external database.
  • REGISTERTABLECONNECTION : Registers a table connection between Microsoft Dynamics NAV and an external database.
  • SETDEFAULTTABLECONNECTION : Establishes a connection to an external database based on a previously registered connection of the specified type.

Caution: all steps must be done in every new session! After closing you session NAV also closes the external database connection!

Enjoy and until the next “How Do I” session where we will focus on Dynamics365 & NAV2017.

Leave a Reply

Your email address will not be published. Required fields are marked *