Configuring ODBC Driver for Dynamics 365 Business Central

Windows DSN Configuration

After installing the driver, create a DSN for Dynamics 365 Business Central in the ODBC Data Source Administrator.

1. Open the ODBC Data Source Administrator in one of the following ways:
   • In the Windows search box, enter ODBC Data Sources, then choose the application that matches the bitness of the third-party application (32-bit or 64-bit).
   • In Control Panel, select System and Security > Windows Tools, then double-click ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). Note that before Windows 8, the icon was named Data Sources (ODBC).
   • Run C:\Windows\SysWOW64\odbcad32.exe to create a 32-bit DSN or C:\Windows\System32\odbcad32.exe to create a 64-bit DSN.
2. Select the User DSN or System DSN tab. Most applications work with both types, yet some applications require a specific type of DSN.
3. Click Add. The Create New Data Source dialog opens.
4. Select Devart ODBC Driver for Dynamics 365 Business Central, then click Finish. The driver configuration dialog opens.
5. Enter the connection information in the appropriate fields.

Basic Authentication

If you choose this authentication type, enter the username and password for your Dynamics 365 Business Central account.



Token-Based Authentication

If you authenticate with OAuth2, click Sign in to Dynamics BC, enter your credentials, and grant the requested permissions to generate a refresh token.



6. Optional: Click Test Connection to verify the connection settings.
7. Click OK.

See Also

Connection String Parameters

Obtaining an Access Key

Obtaining a Refresh Token