update stock quantity and prices from navsion database into another web database, which is used to get the quanity and prices from Navision Sql Server
Database and update the quantity into another database for website (which takes the stock of web site database).
which table is use to get the values of quanity and prices from Navsion sql server database.
What is the best to do it.
Thanks
I would think the best solution is to write a CodeUnit in NAV that calculates the Prices/Costs as required then uses ADO to push those numbers back to the SQL database where you need them. Then you can either run that from Navision, (if its a batch process) or you could use NAS to launch the update routine.
The way I normally do this type of interface, is I develop using a View of the remote Database created on the Navision database. Use linked tables to then get that view as a table in Navision. Then get all the business logic, calculations working. Once it all works, I then break the link, but leave all the business logic in place, and replace the Linked table with an some ADO code. Of course if the tables are small, and the process is not mission critical, you can continue using the linked table.
Another option is to craete an XML file from Navision to export the data needed.
All in all it really depends on exactly what your needs are.
By the way, in your particular case, I would not recommend ODBC or C/FRONT, since that would require you to duplicate a lot of Navision’s pricing and costing logic in your external code, which would be more work than the ADO/NAS route.
can i update the directly from the sql server 2005 database of Navsion using integration services and DTS packages into website sql server 2005 database.
Make service which update the records in timely manner.
The Navision Database is actually a SQL Server. can i go for that way.
Your post is a little unclear, but are you saying that you want to update the NAV database from the website, or the other way around?
If your question is “Can I directly update a standard Navision table, or create a new record in an existing Navision table?” then the answer is no. You need to create a staging table, and use a C/SIDE process to update the Navision standard tables.
I m try to update the website database of stock quantity and prices from Navision Database. i have also access to Navision SQL Server 2005 database. Can i directly get the vlaues of quantity from the item Ledger Entry Table to SQL Server 2005 and update the Website Stock quantity.
I can read data directly of SQL tables from external application. Don’t forget that if you are reading all item ledger entries to calc inventory availability you will have a performance bottleneck. If have millions of item ledger entries then for each item you have to sum all entries. If know how to use sum index SQL Tables directly then you might try to calc inventory like Navision does.
A simpler way might be to periodically export all information that you need from Navision to a work table, and read that table from you external application
As Nuno says, its a performance killer to sum up the entries, so the only option would be to create a SQL script to mimic the way Navision calculates SIFT Tables. This is not complex, but its is complex to support, since the SIFT could be stored differently depending on how keys are created. But definitely a “doable” solution.
The better way though is something like a NAS connection into Navision that either uses ADO to send the data FROM Navision, or exports the data as XML.