Charles Allen covers Using Extender to Create SQL Views in a great new post.
Using Extender to Create SQL Views | Dynamics GP Insights
SQL & DataDevelopment & Integration
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.
