What database does MS Dynamics 365 use to store its entities and records? Does CRM use its own database?

Jerminator 21 Reputation points
2020-06-17T10:43:46.07+00:00

What database does MS Dynamics 365 use to store its entities and records?
Default entities like Accounts, Contacts, etc. as well as customized ones.
Is it SQL Server or does CRM use its own custom database?
I didn't find much information anywhere regarding where exactly this data is being stored.

Is the database different for online vs on-premise?

I have been asked this question three times now and I just say it has its own database; and then I regret saying it.

Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
56 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,821 Reputation points
    2020-06-17T11:42:48.477+00:00

    Hi,

    Dynamics 365 is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can ask the experts in the dedicated Dynamics 365 forum over here:
    https://community.dynamics.com/f

    (Please don't forget to accept helpful replies as answer)

    Best regards,
    Leon

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Julian Sharp 41 Reputation points MVP
    2020-07-03T08:39:41.543+00:00

    Dynamics 365 uses the Common Data Service to store its data - see https://learn.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro

    The Common Data Service abstracts the application from how the data is stored. In actual fact, the Common Data Service uses a mixture of Azure SQL, Azure Blob, and zure Data Lake.

    For on-premise, it uses SQL Server

    6 people found this answer helpful.
    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.