Navision and Internet

How can I insert and retrieve data from Navision without the use of Commerce Portal. I have to copy the data to sql server and then from there put it on the web via asp files… and after a certain amount of time synchronize the data with the navision database. Does anyone know how to do this ? Kind Regards

Have a look at the Commerce Portal and e-Commerce documentation to find out how it’s done in Commerce Portal.

I still think the best way is to deploy Navision on SQL2000 and you can retrieve the tables directly…which in the first place, I see you already using SQL…

I guess it is ok to retrieve data directly form the SQL server, but if you want to insert or modify data, that is not a very secure option.

There are various ways of doing that but you need to make sure that you are following the business logic in tables in Navision - that’s the reason you have CP…