Nice features in NAV 2016 Table i.e One can specify the Table type
Earlier version we are using property called ‘LinkedObject’ to link the external table/view.
In New version we have property Table type which contains three different type as follows called ExternalSql’ wherein one can specify table/view from sql server that is not in MS Dynamics NAV DB
- Normal :- Specified the table as normal table . This is default value whenever you create table in NAV
- CRM:- Integration table for integrating NAV with Microsoft dynamics CRM
- ExternalSQL:- Specify the table/view in sql server which is not in NAV database.
When one select ‘ExternalSQL’ two other properties will enable automatically
1) ExternalName :- specify the name of external table from database
2) External Schema :- Specify the database schema.
You can look at How to register External Tables
Cheers!!!!
Like this:
Like Loading...
Related
Author: Ammolh Saallvi
I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development.
Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin
Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs.
Certifications:-
Microsoft Certified Technology Specialist -Dynamics
Microsoft Sure Step Certified Professional
Moderator at DUG Forum
Specialties: • ERP Implementation
• Client/Server Programming
• Coding, Testing, troubleshooting and documentation.
• Database Tuning and SQL
• Database Performance
• Debugging large programs
• Project Management and Resource Management.
View all posts by Ammolh Saallvi