Dynamics NAV SQL Lookup Function into another SQL based Data

A._B._Computer_Systems

We are working on 'lookup' into an external SQL DB from Navision 4.03 SQL. We have some ideas but wanted to get feedback from others who worked on something similar as well.

Basically what we are trying to do is to be able to read a table in an external SQL database. This customer is going to use Navision A/R, A/P and G/L, and they have the other applications in another home grown SQL based system (applications such as Sales Order, Inventory, etc.).

For example, we have a field in Navision SQL which needs to be ‘lookup’ into an external table in another non-Navision SQL database such as: the ‘Payment Terms Code’ field in the Navision Vendor Card should ‘lookup’ into an external SQL table instead of the Navision ‘Payment Term’ table. We did the initial design and are now looking for additional feedback.

We need to know what will be the best option to accomplish that. What tools should we use, etc. We also want to make sure that performance and system response time will be OK. Accessing an external database from a Navision lookup field, retrieving the data, writing into a Navision table and calling the corresponding lookup form can of course affect the speed of the system.

wwestendorp

Create several views on those tables.

The other way External DB to Navision works as follows.

Create a view for that Table.
Create a Navision Table with exact the same Name and fields.

Set the Property from that Table:

DatePerCompany : No
LinkedObject : Yes


Then you can Programm a Lookback to this Data and (under certain limitations) also write into this View (External Table)

8)

We did the same for some other interfaces which works fine

William