I asked this question on a beginners forum, but I realize now I probably should have posted it here. My apologies! I’m new to this site.
The company I work for is using NAV 5.0, and currently I was given the task of finding out if there is a way to provide some sort of link between the pricing on an item card, and a website. What I essentially want to happen is for the pricing entered on the item card in NAV to be directly linked to the website, so that if I go into the item card and change the price, the price on the website will automatically be updated.
@Marco: I understand that having internet access to Navision system isn’t the most secure way to read the information:
NAS solution - problems with real-time data. As I understand Courtney’s problem, she wants the changes in NAV to be reflected in website immediately.
NAV webservice? This is OK, if you’re using NAV2009. But they’re using 5.0, so I guess you should write some webservice which runs on servers IIS and selects data from SQL database. So basically it’s the same solution as to read the view from website.
third party solution: OK, if you have the money to buy the solution.
Maybe I’m missing something, but what is the risk of exposing one view, which selects Item No. and some decimal field from NAV database, if the view has read-only permissions?
@Koshe, just the fact that your database has an open connection to the internet isn’t the best idea imho. You only need one mess up with the security permissions on the account that’s used for the website and you’ve got a security issue. But of course,I’m not really a SQL guru…