Microsoft Dynamics 365 CRM V2
Microsoft Dynamics 365 is a cloud-based business applications platform that provides customer relationship management (CRM). You can use Microsoft Dynamics 365 CRM as a data source when landing or replicating data.
Microsoft Dynamics 365 CRM integration replicates data using the Dynamics 365 Web API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To retrieve your credentials:
- Log into your Microsoft Azure account.
- Click New registration.
- Set Name to Precog.
- Set the redirect URL to https://precog.cloud and click Register.
- Copy the Application (client) ID and paste it into a secured file.
- Click Endpoints.
- Copy the value in OAuth 2.0 authorization endpoint (v1) — this is your Authorization Endpoint — and paste it into a secured file.
- Copy the value in OAuth 2.0 token endpoint (v1) — this is your Token Endpoint — and paste it into a secured file.
- Click API permissions.
- Click Add a permission > Microsoft Graph > Delegated permissions, select offline_access, and click Add permissions.
- Click Add a permission > Dynamics CRM, select user_impersonation, and click Add permissions.
- Click Grant admin consent for... and click Yes. If you do not have administrator rights, ask your Azure Active Directory administrator to grant consent.
- Click Certificates & secrets > New client secret, set the expiry to Never, and click Add.
Copy the Value — this is your Client Secret — and paste it into a secured file.
- In your Dynamics CRM instance, navigate to Settings > Customizations > Developer Resources.
Copy the Service Root URL and paste it into a secured file.
Creating the connection
자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.
- 필요한 연결 속성을 입력합니다.
연결 이름에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
만들기를 클릭합니다.
| Setting | Description |
|---|---|
| Data gateway | 사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모 이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Client ID | Client ID. |
| Authorization Endpoint | Authorization endpoint. |
| Token Endpoint | Token endpoint. |
| Client Secret | Client secret. |
| Service Root URL | Service root URL. |
| Resource | The first part of your Service Root URL.
Example: https://example.crm.dynamics.com |
Schema
Schemas and naming conventions can change from version to version. Verify your version before continuing.
Datasets are discovered dynamically from the Microsoft Dynamics 365 CRM metadata endpoint. All standard Dynamics 365 entities are supported.
Depending on your destination, table and column names may not appear as they are outlined below.
| Replication Method | CDC |
| Replication Key | modifiedOn |