CData TDV Adapter for Microsoft Dynamics NAV
Microsoft Dynamics NAV Adapter
Microsoft Dynamics NAV Version Support
The adapter supports read/write access to Microsoft Dynamics NAV 2013+ through OData Web services. To access data through the API, you will need to publish the pages you want to work with as Web services: In the Web or Windows Dynamics NAV client, search for 'Web services.' To add a page to the list of the pages exposed, select the Object Type and Object Id.
The SQL Compliance
section shows the SQL syntax supported by the adapter and points out any limitations.