How to integrate with Mysql DB

gkishorenav

Dear All,
Can you please let us know how to integrate with MYSQL from NAV 2009.

Please advice.



Regards,
Kishore.

rsaritzky

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.

Ron