We are integrating Navision (3.70) with a Time entry system using a SQL database. I’d like to know how we could do a real live integration. The idea now is that the other system would use C/ODBC or C/FRONT to bring the data into Navision temporary tables, and then, a codeunit would be launched in Navision to take the data a create some journal entries with it, using all the validation triggers before. We know how to have a periodic process launched by the NAS (ex: every 5 minutes), but we would like it to be done instantly. So my question is: Since we know that C/ODBC or C/FRONT cannot launch triggers (OnInsert, OnValidate), is there any other way for an external application to launch directly (live link) a function in Navision, through the NAS or any other service?
No. There isn’t. But why not let NAS run the import more frequently? Lets say every 5 seconds. That’s almost instantly anyway…
I think this is not possible. But you can find on internet a tools to launch a navision client, and execute automatically some actions, like if you click and type on keyboard, … But it’s not the best solution for me, navision client is displayed at screen…
Are you running Navision on SQL Server as well? If so you can create Views in the Navision SQL Database, and then create tables matching this/these view(s) and link the Navision Tables to the views. Then you will have access to the SQL Data directly from Navision. Steen Fisker
Ok, thank you. I think we’re just gonna have NAS running frequently, and maybe launch the update function every time a new user opens the form displaying the data or statistics he needs.
Hi David, Steen’s suggestion is the better way to do it if you run your Navision on SQL also since you are creating a direct connection and you do not have to worry about updating the table … Regards, Cristi Nicola
quote:
Originally posted by cnicola
Steen’s suggestion is the better way to do it if you run your Navision on SQL also since you are creating a direct connection and you do not have to worry about updating the table …
We are looking to make this integration general, so it would fit for 3.60+ installs, without changing the solution in the NavServer is native or SQL. Am I right to think that if I use C/ODBC or C/FRONT, the only thing I will have to take care is to have the correct ODBC driver for the database type?