How to integrate with Mysql DB
gkishorenav
Member Posts: 5
Dear All,
Can you please let us know how to integrate with MYSQL from NAV 2009.
Please advice.
Regards,
Kishore.
Can you please let us know how to integrate with MYSQL from NAV 2009.
Please advice.
Regards,
Kishore.
0
Comments
-
There may be better ways, but I've done this using an ADO connection, building a query and pulling data into an "interim" table for processing. Once the data is in NAV's table, then a normal codeunit or processing-only report can do the trick. I seem to remember I learned enough about ADO connections and processing here in MIBUSO. Try searching for ADO, or post another message or PM me and I can send you a code sample.
RonRon0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions