46
Hello All,
We have a requirements to import/export basic sales data from branches to server between Dynamics NAV 2016 databases.
How to import specific table data from Dynamics NAV database to database frequently as a scheduled job?
Which technology should use for this purpose?
*This post is locked for comments
for a direct connection you can use nav web service tech. to exchange data in xml dataformat you can use xmlports in the parameter list of the web service functions.
otherwise create a secure file share for the xmlfiles, which you want to exchange.
I'm really appreciate your answer Vishal, happy to know we can do this within NAV using XMLport.
One more question, connection between server and branches going to be VPN (5mb/sec), in that case, how could we directly access to the XML/text files to import/export withou any third party technologies ?
Yea. You can certainly use XML port to upload the sales data at HO.
Based on certain filters (could be date) or change log entry, you can export the data from store and import it back again at HO.
You need to be careful about avoiding duplicates data at HO. I mean, one should not modify the sales data at store after you import the same at HO. Or If someone is ammending the data, that should be reflected in HO as well.
Similarly, you can import the master data at stores as well.
Do the testing thoroughly and consider all the possible scenarios.
Also, you can automate this import / export of data using NaV scheduler. This is to avoid any manual intervention and to have better accuracy.
Also, you should have periodic check for matching the data between store and HO database to avoid any mismatch between these DBs.
We have used LS Retail Modules and related data director engine in similar scenarios at many places and is working absolutely perfect.
I hope you have already considered licensing requirements accordingly when you use NaV at various stores in offline / native mode.
Regards,
Vishal Salot
// if this answer hepls you, pl. marked it as verified.
Thank you, Jonathan.
Branches are shops, that means there would be sales transactions and related basic information (customer, item, sales price, discount, sales header and sales line).
After importing sales transaction, will post on server database only.
Also won't add/update basic informations on branches, only import from server and read.
Another requirement is sales transactions must imported to the server every 2hours
Thank you for reply, Vishal.
Branches are shops, so don't want to be depend on internet connection (there is no wan connection for branches)
They have 80000 items and daily sales transaction would be 100-200, in that case, could we use XML port ?
please describe more details what kind of data you want to exchange. many tables in dynamics nav have a relation together. so updating on the sql database level directly could easily end in a corrupted database.
so your options are:
* change your processes, so that the branches use the same database as the headquarter. if needed you can add a company for each branch.
* if you do not want to change the processes, then you could use rapidstart services, xmlports (xml data file exchange), custom reports (processingonly)/codeunits or webservices to import data using nav standard processes. in your case you want to do it periodically. for that you could use the nav job queue.
Hi,
Ideally you should use the SQL replication mechanism to replicate the data between two different SQL database.
You can use the SQL replication features (Transaction / Merge) Replication, you can setup the SQL scheduler job to replicate the data between two databases / tables.
You can refer various blogs related to SQL replication features, which would give you complete idea about it.
This would take some time to configure at beginning, if you are not aware about SQL replication.
Another way is to do the small customization in NAV.
You can generate the XML port, which can generate the XML file at periodic basis from Branches, which can be uploaded to FTP site / Network and further can be imported at server on periodic basis. You can use the Jobs / NAS for the same.
Can you please suggest, why branch people are not connected to Server directly and perform the sales transactions?
Best Regards,
Vishal Salot
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (