How to Update a Table in Navision Database from SQL Server.

bbalaji

Hi

We are using Proprietary database and we want to extract data from sql server to update navision table(s) without using text files to import.


What means can we use to achieve this ?

kriki

If you Navison is on a SQL-DB, and you want to see the SQL-table in Navision, you can create a Navision-table with the same name and layout and set table-property "LinkedObject"=Yes. It is also possible to create a SQL-view and connect the Navision-table to that view.
In this way, you can import the data from that table into Navision with a codeunit or a report.

kine

Of course, you can try to use N/ODBC (C/ODBC) to connect from MS SQL to Native DB for example in some DTS package...

DenSter

You can also use the ADO object model directly in the C/AL editor.