Reading Data from PostGRE in Nav 4.0

Dean_Axon

Has anyone done this ?

Any pointers, suggestions, ideas, even a start point as I have never had to do this before.

I vaguely recall something called "Linked Tables"... does this require the NAV db to be on SQL too ? Is this the way to go ?

Many thanks in advance.

Dean.

kapamarou

You need to be on SQL server. Create a linked server on SQL, a view reading data from PostGRE and a Nav table as a Linked table with the name of the view.

Search the forum for ADO, Linked Server, Linked Object etc...