Microsoft Dynamics CRM

Version:
Current
Last modified: July 13, 2020
Connection Type

Alteryx Tool. The latest version is available from the Alteryx Analytics Gallery.

Driver Details

To configure a connection to Microsoft Dynamics CRM, create a Web Application Client in Azure Active Directory or a self-hosted Active Directory server, depending on the version and configuration of Dynamics CRM.

Type of Support

Read & Write

Validated On

Microsoft Dynamics 365 & Azure Active Directory

Release Notes
Version Description
v1.0.2
  • Fixed error caused by upstream tools being deleted.
  • Fix issue where default value settings were occasionally not respected.
  • Disabled production logging to prevent permissions issues for different installations/configurations of Designer and support scheduled workflow functionality.
v1.0.1
  • Fixed issue preventing packages from being installed successfully.
v1.0.0
  • Initial release for Dynamics CRM Input and Dynamics CRM Output.

 

Alteryx tools used to connect

Link
Dynamics CRM Input Tool Icon

Dynamics CRM Input Tool

Link
Dynamics CRM Output Tool Icon

Dynamics CRM Output Tool

Authentication Configuration

Before using Dynamics CRM Input or Output tools, create an application user role with permissions to access the Microsoft Dynamics CRM instance.

Azure Active Directory Setup

  1. Create a Web Application registered with your Azure Active Directory Tenant. See Create an Azure Active Directory application in the Microsoft Azure Documentation.
  2. Create a secret key and grant the Dynamics CRM Online permission to your Web Application client. See To add application credentials, or permissions to access web APIs in the Microsoft Azure Documentation site.

    Treat the secret key like any other password, and store it in a safe location.

  3. Create a custom security role to associate with the application user role created in the next step. See Create a security role for the application user in the Microsoft MSDN Documentation.
  4. Create an application user role to associate with the custom security role created in the previous step. See Create an application user associated with the registered application in Dynamics 365 in the Microsoft MSDN documentation.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.