Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
NAV 2017/Dynamics 365 - data exchange with external web application. Web services?
DmitriySozinov
Member Posts: 23
Hi guys,
There is a SharePoint web-application which exchanges data with NAV using a 'buffer' SQL database (iDB).
NAV exports master data (vendors, gl accounts, dimensions, etc.) into iDB and imports processed accounting data (e.g. journal lines) from iDB.
In most cases NAV server & clients are located in a different network/domain than the 'buffer' database, in which case a VPN connection is established between the networks.
Data exchange is coded using ADO.NET in NAV.
We think about switching from ADO.NET to some other technology, which would not require a VPN connection between NAV server and 'buffer' database.
This is especially relevant for Dynamics 365 for Financials, since it would be an Azure virtual machine hosting the NAV and apparently it would not be possible to establish a VPN to it.
1. With this, please advise if it would be possible/good idea to allow web application to 'import' master data into 'buffer' db using exposed web-services in NAV?
2. Are there are any performace issues with using web-services for large amounts of data?
3. Will it be possible to allow the web-application to create journal lines in NAV using, e.g. exposed 'Purchase Journal' web-service?
4. What would be an alternative to using web-services in this scenario?
Thanks in advance and looking forward to hearing from you ;-)
There is a SharePoint web-application which exchanges data with NAV using a 'buffer' SQL database (iDB).
NAV exports master data (vendors, gl accounts, dimensions, etc.) into iDB and imports processed accounting data (e.g. journal lines) from iDB.
In most cases NAV server & clients are located in a different network/domain than the 'buffer' database, in which case a VPN connection is established between the networks.
Data exchange is coded using ADO.NET in NAV.
We think about switching from ADO.NET to some other technology, which would not require a VPN connection between NAV server and 'buffer' database.
This is especially relevant for Dynamics 365 for Financials, since it would be an Azure virtual machine hosting the NAV and apparently it would not be possible to establish a VPN to it.
1. With this, please advise if it would be possible/good idea to allow web application to 'import' master data into 'buffer' db using exposed web-services in NAV?
2. Are there are any performace issues with using web-services for large amounts of data?
3. Will it be possible to allow the web-application to create journal lines in NAV using, e.g. exposed 'Purchase Journal' web-service?
4. What would be an alternative to using web-services in this scenario?
Thanks in advance and looking forward to hearing from you ;-)
0