Configuring an ADF Linked Service Connection for Dynamics AX
For information on how to enable a connection for use with linked services, see Configuring a Linked Service Connection.
Field labels in this walkthrough follow the underlying Azure Data Factory property names, with the connection column that carries each value named alongside. The exact labels shown in the BimlFlex Connection Editor may differ.
After selecting Dynamics AX from the Linked Service Type dropdown, the form required for creating a Dynamics AX Linked Service will appear.
Source Only Connector
A Dynamics AX connection is used as a source. It is not available as a target.
The connector reads Dynamics AX through its OData endpoint. It can also read Dynamics 365 Finance and Operations.
Choosing an Authentication Method
| Method | Credentials | Additional Settings |
|---|---|---|
| Service Principal | Service Principal Id, Service Principal Key and Tenant | None |
Recommendation: Store the Service Principal Key in Azure Key Vault rather than entering it as plaintext.
Complete Example: Service Principal with Azure Key Vault
| Field | Example Value |
|---|---|
| Connect via Integration Runtime | AutoResolveIntegrationRuntime |
| URL | https://contoso.sandbox.operations.dynamics.com/data |
| Service Principal Id | <client-id-of-app-registration> |
| Tenant | contoso.onmicrosoft.com |
| AAD Resource Id | https://contoso.sandbox.operations.dynamics.com |
| Azure Key Vault Linked Service | bfx-kv |
| Secret Name (for Service Principal Key) | BFX-SRC-DynamicsAxClientSecret |
Required Fields
Common Required Fields
A Dynamics AX Linked Service connection uses a single Authentication Type, so the same fields are required on every connection.
These common required fields are:
- Connect via Integration Runtime
- URL
- Service Principal Id
- Service Principal Key (or Azure Key Vault)
- Tenant
- AAD Resource Id
Connect via Integration Runtime
Connect via Integration Runtime names the integration runtime for a Dynamics AX Linked Service connection.
The default value is AutoResolveIntegrationRuntime.
To use another runtime, select it from the dropdown or choose + New to add one.
When a custom value is saved in the linked service form, it will be added to the custom integration runtimes.
The custom values that appear in this dropdown can be maintained in Settings under Azure - AzureIntegrationRuntime.
URL
The URL is the OData endpoint of the Dynamics AX or Dynamics 365 Finance and Operations instance (for example, https://contoso.sandbox.operations.dynamics.com/data).
It is stored in the connection's LS_Url column and maps to the ADF url property.
Authentication Type
The Dynamics AX Linked Service connection signs in with a service principal. The form has no Authentication Type field for this connector.
For Service Principal, a Service Principal Id, Service Principal Key and Tenant are required.
Service Principal
Service Principal authentication authorizes access with an application registered with the Microsoft identity platform and granted permission in Dynamics AX.
The Service Principal Id supplies the client ID of the application and is stored in the connection's LS_ServicePrincipalId column. It maps to the ADF servicePrincipalId property.
The Service Principal Key supplies the application key as plaintext in the LS_ServicePrincipalKey column, or as an Azure Key Vault reference held in the LS_ServicePrincipalKeyKVS_ fields that resolves to the key at runtime. It maps to the ADF servicePrincipalKey property.
When an Azure Key Vault reference is set, the plaintext key is not written to the linked service.
The Tenant is the domain name or tenant ID under which the application resides (for example, contoso.onmicrosoft.com).
It is stored in the connection's LS_Tenant column and maps to the ADF tenant property.
It is suggested that Azure Key Vault be used in place of manually entering the Service Principal Key.
AAD Resource Id
The AAD Resource Id is the Microsoft Entra resource that the connector requests authorization for.
For a URL of https://contoso.sandbox.operations.dynamics.com/data, the resource is usually https://contoso.sandbox.operations.dynamics.com.
It is stored in the connection's LS_AadResourceId column and maps to the ADF aadResourceId property.
Azure Data Factory Linked Service Additional Information
For additional information on ADF Dynamics AX Linked Service and its connection requirements see the Azure Data Factory Dynamics AX Connector documentation.