Dynamics 365
Category: Direct connection
Microsoft Dynamics 365 (Business Central / Dataverse) is connected as an OData source with OAuth2 authentication (Azure AD / Microsoft Entra ID). You select this source via the Dynamics 365 preset in the Add source wizard; the connection address and the token address are mostly built automatically from your tenant and company, so you mainly need to fill in the OAuth details of an app registration.
Expected input
Besides the shared wizard fields (source name, integration runtime, credentials identical for all environments?, credential expiry date, tags), you fill in the following fields for Dynamics 365:
| Field | Notes |
|---|---|
| URL | Read-only. Built automatically (Business Central OData V4) from the tenant + company name. |
| Access token URL | Read-only. Built as https://login.microsoftonline.com/{tenant}/oauth2/v2.0/token. |
| Tenant ID | The directory/tenant ID of your Microsoft Entra ID. |
| Company name | The name of the Business Central company you want to expose; it is woven into the OData URL. |
| Client ID | The application (client) ID of the registered app. |
| Client secret | The client secret of the app registration (shown only once when created). |
| Scope | The OAuth scope for the token request. |
| Grant Type | Client Credentials or Authorization Code. With Authorization Code, an extra Refresh token field appears. |
Fixed (hidden) parameters: pagination paginationType=BodyUrl with body_url=@odata.nextLink (Yres automatically follows the @odata.nextLink pagination of the OData feed).
Authentication method: OAuth2 via an Azure AD / Microsoft Entra ID service principal — client credentials or authorization code (with refresh token).
Integration runtime: by default the cloud runtime AutoResolveIntegrationRuntime. A self-hosted IR is not needed, because the OData endpoints are publicly reachable over the internet.
Where secrets are stored: Yres never stores passwords or secrets itself. The values you enter are placed as secrets in the Azure Key Vault of your own environment, following the pattern adf-{sourcename}-{suffix}; the linked service in Azure Data Factory references those secrets.
Preparation
- Register an app in Microsoft Entra ID — In the Azure portal → App registrations, register an application. On Overview you will find the client ID and the tenant ID.
- Create a client secret — Under Certificates & secrets, create a client secret and copy it immediately (it is no longer visible afterwards).
- Permissions on Dynamics CRM/Dataverse — Assign the app the required API permissions for Dynamics CRM/Dataverse (e.g.
user_impersonation) with admin consent. - Company and tenant — Keep the tenant ID and the company name (Business Central company) at hand; together they determine the automatically built OData URL.
Load types & delta
Dynamics 365 is exposed as an OData source. Metadata discovery runs through the standard GetMetaData pipeline; after that you set the load type and any delta/key columns per table, just like with other OData sources. The OData feed is paginated automatically via @odata.nextLink.
Official documentation: Register an app with Microsoft Entra ID (Microsoft Dataverse) — Microsoft Learn.
See also: Integration catalog · All data source requirements · Integrations — overview