# 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.

![](/files/UCJcQsIC1dsPP4bKfgIM)

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

![](/files/aG3bJs7NeJhGL7OwKPQX)

This will open a new window.

![](/files/rKqkekRcbi2WdpQTN89d)

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

![](/files/rzOn0j50bekIgmavlT5c)

*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).

![](/files/RHcIst9AFhH95b1kqnGj)

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 %}

![](/files/yk6RZ3siBkJV7vkQXjdu)

*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.

![](/files/PBp3FH9jsn0dYmc1Y4zW)

6. Select a table and click *Next.*

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

![](/files/FnmSH9UjAr9E8f8lzvB3)

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

![](/files/ELAex8pItISMHWbtv6CH)

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/astera-data-stack-v10/connectors/microsoft-dynamics-crm.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.