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
- 270 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
Writing to Navi tables using SQL
greg@mesa
Member Posts: 2
Can it be done?
I assume there are issues with flowfields, but is it possible to use SQL to put data directly into a Navision table? What does it take? Is this a recommended practice? My client will be using SQL7 with Nav2.50.
-Greg
I assume there are issues with flowfields, but is it possible to use SQL to put data directly into a Navision table? What does it take? Is this a recommended practice? My client will be using SQL7 with Nav2.50.
-Greg
0
Comments
For example you can link MS-Access 97/2000 via ODBC to a Navision Table and use queries to insert/modify data in the Fin DB. I tied that already and it works fine.
Marcus
Marcus Fabian
m.fabian@thenet.ch
+41 79 439 78 72
Marcus Fabian
We did this for a client where it was needed to synchronize the Customers with the central SAP database in Paris (FR), the Ship-to addresses with an Oracle database in Houston (USA) and the Items (their web-catalog) with the Oracle system in The Hague (NL). All replications are done through Stored Procedures on SQL 7 Server, updating/inserting the various tables of Navision 2.5 directly with SQL queries.
John