Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article outlines how to use the copy activity in Data pipeline to copy data from Dynamics AX.
For the configuration of each tab under copy activity, go to the following sections respectively.
Refer to the General settings guidance to configure the General settings tab.
The following properties are supported for Dynamics AX under the Source tab of a copy activity.
The following properties are required:
If you select Path:
Path: Specify the path to the Dynamics AX OData entity.
If you select Query:
"?$select=Name,Description&$top=5"
.Note
The connector copies data from the combined URL: [URL specified in linked service]/[path specified in dataset][query specified in copy activity source]
. For more information, see OData URL components.
Under Advanced, you can specify the following fields:
For Mapping tab configuration, see Configure your mappings under mapping tab.
For Settings tab configuration, go to Configure your other settings under settings tab.
The following tables contain more information about the copy activity in Dynamics AX.
Name | Description | Value | Required | JSON script property |
---|---|---|---|---|
Data store type | Your data store type. | External | Yes | / |
Connection | Your connection to the source data store. | <your Dynamics AX connection> | Yes | connection |
Connection type | Select a type for your connection. | Dynamics AX | Yes | / |
Use query | The way to read data from Dynamics AX. Apply Path to read data from the specified path or apply Query to read data using queries. | • Path • Query |
Yes | / |
Path | The path to the Dynamics AX OData entity. | < your path > | Yes | path |
Query | OData query options for filtering data. For example, "?$select=Name,Description&$top=5" . Note: The connector copies data from the combined URL: [URL specified in linked service]/[path specified in dataset][query specified in copy activity source] . For more information, see OData URL components. |
< your query > | No | query |
Request timeout | The timeout (the TimeSpan value) for the HTTP request to get a response. This value is the timeout to get a response, not the timeout to read response data. | timespan (the default is 00:05:00 - 5 minutes) |
No | httpRequestTimeout |
Additional columns | Add additional data columns to store source files' relative path or static value. Expression is supported for the latter. | • Name • Value |
No | additionalColumns: • name • value |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today