Insert data into NAV from another SQL db

iqbalmad
Member Posts: 180
Hi everyone,
i would like to read data from an sql database - non nav db (X) from server (Y) and insert it in a nav sql db (Z).
can anybody help from where i should start.
i have already tried these but in vain
http://dynamicsuser.net/blogs/waldo/arc ... s-nav.aspx
http://erpnav.blogspot.fr/
i would like to read data from an sql database - non nav db (X) from server (Y) and insert it in a nav sql db (Z).
can anybody help from where i should start.
i have already tried these but in vain
http://dynamicsuser.net/blogs/waldo/arc ... s-nav.aspx
http://erpnav.blogspot.fr/
0
Comments
-
You can start with exploring the Linked Objects functionality: see Using Linked Objects on msdn.
Basically, you create a view in the SQL NAV database which retrieves the data from the other database & server. Then you create a NAV table with the same name as your view, through NAV Object Designer. Make sure you put the same fields in your table as are in your view, in the same order. Then set the LinkedObject-property. Now when you run the table, you see it has been populated with the data from your view. The data is not stored in the NAV table though, but you can write code to copy this to some other regular NAV table.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)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