Best performance between Webshop and NAV 2013?

BoBrinkmann

What is the fastest way to communicate data between the shop and Nav 2013

Is it via:

web services?
ODBC?
Files?
Direct entries in the database?

There should be no safety issues, about the solution and perfomance should be as high as possible.

Online users on average approx. 100

ara3n

Direct to SQL is the fasted but you still need to run the business logic.
You could insert it into staging table and process them from NAV.
But I suggest implement it with web services. The two system are separate db.
Have a separate task send the data asynchronously.

Alex_Chow

I'm curious, why write directly to SQL table? You can directly write to the SQL table, but you're still subject to the delay of actually processing the data when the data gets to the staging table.

Web service is a direct link and it validates business logic.

Miklos_Hollender

First of all because web services are a three-tier, RTC thing.

I see the delay as a feature, not a bug. I don't believe in "silently" importing data automatically. Rather, the Order Processor should go to a button twice a day that says "Import Web Orders", and if there is an error message he can call me immediately. That is a proper solution, that means any problem will be promptly dealt with because the process is overseen by a human.

"Silent" imports such as scheduled with NAS are very dangerous. There is some error, nobody notices that it stopped, people wonder how comes we have no orders for the last week, then angry customers call in the hundreds...

This should be a principle really. If ever data is loaded into Navison, it should be initiated by a person pressing a button. So if it does not works they know it.

If a webshop "pushes" data into Navision through web services, and something fails, how does the Order Processor know about it?

rmv_RU

BoBrinkmann wrote:

What is the fastest way to communicate data between the shop and Nav 2013
web services?
ODBC?
Files?
Direct entries in the database?
There should be no safety issues, about the solution and perfomance should be as high as possible.
Online users on average approx. 100

Probably using SQL to reading data and web-services with Nav to provide business logic better choice.

aniish

using web-service is best practice to integrate NAV system with an e-com system. To retrieve data from NAV on behalf of any calculation you can use Sql services.