Getting Started
The CData ODBC Driver for Microsoft Dynamics NAV is a standards-based ODBC driver with editions for Windows and Unix-based operating systems, like macOS and Linux. The following sections show how to create an ODBC data source and query data.
Creating a DSN on Your Platform
The following guides show how to use the standard tools to configure data source names (DSN).
-
Windows
Windows DSN Configuration shows how to configure a DSN with the Microsoft ODBC Administrator tool.
-
macOS
macOS DSN Configuration shows how to configure a DSN with the iODBC driver manager.
-
Linux
Linux DSN Configuration shows how to configure DSNs with several major driver managers on Linux.
Microsoft Dynamics NAV Version Support
The driver 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.
See Also
See the following sections to connect to the DSN from tools and from code:
- Using from Tools: Connect to the DSN from various tools on different platforms.
- Using ODBC: Connect to the DSN using the native ODBC API.
- Create a Linked Server: Connect to the DSN as a remote SQL Server database.
- MySQL Remoting: Connect to the DSN over the MySQL protocol.