Connecting to Navision DB in ASP/web dev

threefromzero
Member Posts: 5
I've created a web portal for my company's warehouse to enter in out of stock information into. Currently, this is totally functional and keeping track of out of stocks and fill rate and the like, and generating reports based on the information straight into excel. However, it turns out that this isn't quite enough!
Now they want me to pull things like customer number, the original items ordered, and customer name into the reports. At the moment my reports are working completely off a separate mySQL DB that only contains what the warehouse types in to my web site.
So I'd like to figure out the best approach to pulling data out of navision based on order number. I'm looking at using the ODBC driver but I've heard this can be painfully slow. I've also heard of a component called C/FRONT that can be used for faster tie-ins to navision. However, I've never incorporated anything like that into my ASP code before.
We're using Navision 3.7 with the proprietary navision DB format.
So any tips on how to do this? I asked a programmer who works with navision regularly and he said there are some pit falls to connecting to the navision DB from an outside application.
Thanks for any tips or advice on this matter.
Now they want me to pull things like customer number, the original items ordered, and customer name into the reports. At the moment my reports are working completely off a separate mySQL DB that only contains what the warehouse types in to my web site.
So I'd like to figure out the best approach to pulling data out of navision based on order number. I'm looking at using the ODBC driver but I've heard this can be painfully slow. I've also heard of a component called C/FRONT that can be used for faster tie-ins to navision. However, I've never incorporated anything like that into my ASP code before.
We're using Navision 3.7 with the proprietary navision DB format.
So any tips on how to do this? I asked a programmer who works with navision regularly and he said there are some pit falls to connecting to the navision DB from an outside application.
Thanks for any tips or advice on this matter.
0
Comments
-
Hi!
I think you can make use of the N-ODBC driver. You will find the installation files in your Client's Navision Product CD. Once you install N-ODBC, you will be able to retrieve information from your Navision DB. But the process is obviously going to be slow. Try it.0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions