使用 Azure 数据工厂从 Dynamics AX 中复制数据Copy data from Dynamics AX by using Azure Data Factory

• 09/21/2020
• • W

适用于： Azure 数据工厂 Azure Synapse Analytics

本文概述了如何使用 Azure 数据工厂中的复制活动从 Dynamics AX 源复制数据。This article outlines how to use Copy Activity in Azure Data Factory to copy data from Dynamics AX source. 本文是根据总体概述复制活动的 Azure 数据工厂中的复制活动编写的。The article builds on Copy Activity in Azure Data Factory, which presents a general overview of Copy Activity.

支持的功能Supported capabilities

以下活动支持此 Dynamics AX 连接器：This Dynamics AX connector is supported for the following activities:

• 包含支持的源/接收器矩阵的 Copy 活动Copy activity with supported source/sink matrix
• Lookup 活动Lookup activity

可以将数据从 Dynamics AX 复制到任何受支持的接收器数据存储。You can copy data from Dynamics AX to any supported sink data store. 有关复制活动支持作为源和接收器的数据存储的列表，请参阅支持的数据存储和格式。For a list of data stores that Copy Activity supports as sources and sinks, see Supported data stores and formats.

具体而言，此 Dynamics AX 连接器支持将 OData 协议与服务主体身份验证配合使用来从 Dynamics AX 中复制数据。Specifically, this Dynamics AX connector supports copying data from Dynamics AX using OData protocol with Service Principal authentication.

入门Get started

若要使用管道执行复制活动，可以使用以下工具或 SDK 之一：To perform the Copy activity with a pipeline, you can use one of the following tools or SDKs:

• 复制数据工具The Copy Data tool
• Azure 门户The Azure portal
• .NET SDKThe .NET SDK
• Python SDKThe Python SDK
• Azure PowerShellAzure PowerShell
• REST APIThe REST API
• Azure 资源管理器模板The Azure Resource Manager template

对于特定于 Dynamics AX 连接器的数据工厂实体，以下部分提供了有关用于定义这些实体的属性的详细信息。The following sections provide details about properties you can use to define Data Factory entities that are specific to Dynamics AX connector.

先决条件Prerequisites

若要使用服务主体身份验证，请执行以下步骤：To use service principal authentication, follow these steps:

1. 遵循将应用程序注册到 Azure AD 租户，在 Azure Active Directory (Azure AD) 中注册一个应用程序实体。Register an application entity in Azure Active Directory (Azure AD) by following Register your application with an Azure AD tenant. 记下下面的值，这些值用于定义链接服务：Make note of the following values, which you use to define the linked service:

   • 应用程序 IDApplication ID
   • 应用程序密钥Application key
   • 租户 IDTenant ID

2. 转到 Dynamics AX，向此服务主体授予用于访问 Dynamics AX 的正确权限。Go to Dynamics AX, and grant this service principal proper permission to access your Dynamics AX.

链接服务属性Linked service properties

Dynamics AX 链接的服务支持以下属性：The following properties are supported for Dynamics AX linked service:

示例Example

{
    "name": "DynamicsAXLinkedService",
    "properties": {
        "type": "DynamicsAX",
        "typeProperties": {
            "url": "<Dynamics AX instance OData endpoint>",
            "servicePrincipalId": "<service principal id>",
            "servicePrincipalKey": {
                "type": "SecureString",
                "value": "<service principal key>"
            },
            "tenant": "<tenant info, e.g. microsoft.partner.onmschina.cn>",
            "aadResourceId": "<AAD resource, e.g. https://sampledynamics.sandbox.operations.dynamics.com>"
        }
    },
    "connectVia": {
        "referenceName": "<name of Integration Runtime>",
        "type": "IntegrationRuntimeReference"
    }
}

数据集属性Dataset properties

本部分提供了 Dynamics AX 数据集支持的属性列表。This section provides a list of properties that the Dynamics AX dataset supports.

有关可用于定义数据集的各部分和属性的完整列表，请参阅数据集和链接服务。For a full list of sections and properties that are available for defining datasets, see Datasets and linked services.

要从 Dynamics AX 复制数据，请将数据集的 type 属性设置为 DynamicsAXResource。To copy data from Dynamics AX, set the type property of the dataset to DynamicsAXResource. 支持以下属性：The following properties are supported:

示例Example

{
    "name": "DynamicsAXResourceDataset",
    "properties": {
        "type": "DynamicsAXResource",
        "typeProperties": {
            "path": "<entity path e.g. dd04tentitySet>"
        },
        "schema": [],
        "linkedServiceName": {
            "referenceName": "<Dynamics AX linked service name>",
            "type": "LinkedServiceReference"
        }
    }
}

复制活动属性Copy Activity properties

本部分提供了 Dynamics AX 源支持的属性列表。This section provides a list of properties that the Dynamics AX source supports.

有关可用于定义活动的各个部分和属性的完整列表，请参阅管道。For a full list of sections and properties that are available for defining activities, see Pipelines.

作为源的 Dynamics AXDynamics AX as source

若要从 Dynamics AX 复制数据，请将复制活动中的 source 类型设置为 DynamicsAXSource。To copy data from Dynamics AX, set the source type in Copy Activity to DynamicsAXSource. 复制活动 source 节支持以下属性：The following properties are supported in the Copy Activity source section:

示例Example

"activities":[
    {
        "name": "CopyFromDynamicsAX",
        "type": "Copy",
        "inputs": [
            {
                "referenceName": "<Dynamics AX input dataset name>",
                "type": "DatasetReference"
            }
        ],
        "outputs": [
            {
                "referenceName": "<output dataset name>",
                "type": "DatasetReference"
            }
        ],
        "typeProperties": {
            "source": {
                "type": "DynamicsAXSource",
                "query": "$top=10"
            },
            "sink": {
                "type": "<sink type>"
            }
        }
    }
]

“查找”活动属性Lookup activity properties

若要了解有关属性的详细信息，请查看 Lookup 活动。To learn details about the properties, check Lookup activity.

后续步骤Next steps

有关 Azure 数据工厂中复制活动支持用作源和接收器的数据存储的列表，请参阅支持的数据存储和格式。For a list of data stores that Copy Activity supports as sources and sinks in Azure Data Factory, see Supported data stores and formats.