There are always some cases where you would like to have external data available to Dynamics NAV. In cases where the data is available to the SQL Server hosting the Dynamics NAV database it is easy to create a view in the NAV database and a linked table in the Dynamics NAV. The process is;
Create a normal table in Dynamics NAV and save it. Make sure that you select to use the same table for all companies.