Dynamics CRM

Dynamics CRM

Follow these steps to connect Dynamics CRM to your CData Connect account:

  1. In Dynamics CRM, create a custom OAuth application.

  2. In CData Connect, open the Connections page of the dashboard.

  3. Click + Add Connection in the upper-right corner.

  4. Type Dynamics CRM in the Add Connection dialog that opens. Click the data-source name when it is displayed.

  5. On the Basic Settings tab of the new connection, enter a connection name or keep the default name.

  6. Enter the following information:

    • CRM Version—the CRM version. Choose either CRM2011+ or CRMOnline from the drop-down list.

    • URL—the root URL of the organization. The formatting of this URL depends on the version of CRM that you use.

    • OAuth Client Id—the Application (client) Id from your OAuth application.

    • OAuth Client Secret—the Client Secret from your OAuth application.

  7. Click Sign in to connect securely through OAuth. This action opens the Dynamics CRM sign-in page in a new tab.

  8. Log into your Dynamics CRM account and provide the requested permissions (if applicable).

  9. At the top of the CData Connect Add Dynamics CRM Connection page, click Save & Test.

    • If the connection test succeeds, a message indicates that your connection has been created.

    • If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.

Creating a Custom OAuth Application

Follow these steps to create a custom OAuth Application in Dynamics CRM:

  1. Open your Azure portal and open the navigation pane. Select Azure Active Directory, then App Registrations.

  2. Click New Registration.

  3. Enter the following information:

    • Name—a name for the application (for example, CData Connect).

    • Supported account types—select Accounts in any organization directory.

    • Redirect URI—select Web and enter https://oauth.cdata.com/oauth/

  4. Click Register to create the application.

  5. In the application view, select Certificates & Secrets.

  6. Select New Client Secret, set a duration, and save it. When the key value appears, copy it down to use when establishing the connection.

  7. Select API permissions and click Add a permission.

  8. Select Dynamics CRM and choose Delegated permissions. Select user_impersonation in the permissions list.

  9. Click Add permissions to save your changes.

  10. Select Overview and copy down the value for Application (client) ID.

More Information

For more information about interactions between CData Connect and Dynamics CRM, see this information page.