Some of us have wondered how to quickly perform data integrations and transformations and Azure Data Factory is clearly one of them.
Getting started with Azure Data Factory: Data Factory – Data Integration Service | Microsoft Azure
For Microsoft Dynamics 365 for Finance and Operations we will have our own connector for Azure Data Factory called “Dynamics AX”, this connector can be used from the Datasets that define our data sources:
Copy data from Dynamics AX – Azure Data Factory | Microsoft Docs
When adding our connector as a new data source, we must specify the entity from which we want to obtain the data and also the configuration to authenticate with Azure Active Directory (Register a web application with AAD)
The Dynamics AX connector basically makes OData calls, so it is important to read the OData documentation (Open Data Protocol (OData) – Finance & Operations | Dynamics 365 | Microsoft Docs)
This connector allows you to specify additional parameters to perform OData queries to filter or select specific records.
One of the common questions we see is how to make the call to obtain the records of all the companies and just add the appropriate query component to our OData query like this:
It is necessary to edit the parameters with which the connector executes the query
Add the filter to the query (“query”: “&cross-company=true”) :
Things to consider when setting up your dataset in Azure Data Factory
- Create a separate Azure Active Directory application registration per environment
- Validate the secret key expiration time
- Configure the Azure Active Directory application in D365FO
- Configure the appropriate company for the user who will use the ODATA protocol.
- Specify the additional parameter for the OData query on Azure Data Factory datasets