# Microsoft Dynamics CRM

Microsoft Dynamics CRM is a customer relationship management software package developed by Microsoft. The product focuses mainly on the sectors of sales, marketing, and service (help desk). The focus is to enhance customer relationships for any organization.

### Connecting to Microsoft Dynamics CRM in Astera Data Stack

Astera Data Stack offers the *Microsoft Dynamics CRM* connector within the *Database Source* object.

1. Drag and drop the *Database Source* object from the *Sources* section of the Toolbox in Astera.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FnusLYUaMQKWVgsHpeCrG%2F01-Drag-Drop.PNG?alt=media\&token=fc5ceb3e-f06c-4a8a-96f0-44c787743f63)

2. Right-Click on the object and select *Properties* from the context menu.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FtXKBXOn9T0hVyHs2zYQw%2F02-Right-Click.PNG?alt=media\&token=4aa2aaa1-b42f-419a-b948-e0ea09897c7e)

This will open a new window.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fx9bC6yW1p7y0LqzOlPIR%2F03-Properties-Open.PNG?alt=media\&token=eda4686f-1465-4293-82af-d9878ba7e558)

3. From the *Data Provider* drop-down menu, select *Microsoft Dynamics CRM*.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FVCD3kBz8mluDf8ZmxOvh%2F04-CRM-Select.PNG?alt=media\&token=7e78030e-6f72-45bc-843e-0753860a1047)

*Server:* This is where the link to the CRM server is added.

A *Client ID* and *Client Secret* are required to connect to Microsoft Dynamics CRM, which can be found on the Azure Active Directory once the user registers an application.

This application is registered to access Dynamics CRM. To register an application, you can follow the guide given [here](https://learn.microsoft.com/en-us/power-apps/developer/data-platform/walkthrough-register-app-azure-active-directory).

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FUy4KvXzHYPejNoOCEvsV%2F05-Credentials-Authentication.PNG?alt=media\&token=e136620f-1da1-4c11-a340-20a1397e8d75)

4. Select *Request Token,*

{% hint style="info" %}
**Note:** After clicking on *Request Token*, a Microsoft Portal Authentication window opens, where the user must log in.
{% endhint %}

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F77n4SlCWRdpXca2DOLOw%2F06-Tokens-Generated.PNG?alt=media\&token=316f5475-afa2-4e15-97d3-c770d0095142)

*Access Token:* An authentication token is added to this field after selecting the *Request Token* option.

*Refresh Token:* When the *Access Token* expires, its *Refresh Token* is used to obtain another valid *Access Token.*

5. Once the connection is successful, click *Next* and you will be taken to the next screen.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F18qoihk7Hzfu1iklWsfA%2F07-Partition-Table.PNG?alt=media\&token=e6c5172c-6dd1-4450-ad02-733acdffed2b)

6. Select a table and click *Next.*

You will be taken to the *Layout Builder* screen.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FMJHPFbGtxxh4S7tfs9cB%2F08-Layout-Builder.PNG?alt=media\&token=9a162332-da33-4b64-90fe-323031c3d98d)

7. Click *OK* and the *Database Source* object will be configured.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F6nFI6wqnW1N5KZpcChin%2F09-Configured.PNG?alt=media\&token=48770c36-8269-45ac-aa14-864f4f70a2a2)

This concludes the Authentication and Configuration of the *Microsoft Dynamics CRM* provider in Astera Data Stack.