Source
r/PowerApps•
andyIMC

Where is the Common Data Store located and what DB engine is being used?

Hi all,

I need to understand the underlying technology that Microsoft is using for their Common Data Store. Anyone have any idea as to where the data is stored and using what DB mechanism? It doesn't seem like SQL as it's more flexible that that, so to me it seems to be more like a NoSQL DB like Mongo, which I am sure MS aren't using...

Posted Oct 24, 2019, 8:54 PM UTC

46
dyma97•

It's a combination of a few things as SaaS offerings tend to be and is kind of the point. Azure SQL Server, Azure BLOB, Azure AAD, etc.

2
andyIMCOP•

Right, I figured it would be more like what you describe here.... as the data is coming from a avariety of sources... I just wondered if MS stored a cache of CDS data in something like a NoSQL DB for easier user access...

1
codebound•

I think Microsoft somewhat intentionally abstracts this through API and other access points. What is your use case that you need to know the internal tech?

1
andyIMCOP•

I am presenting at a conference on CDS and I wanted to have an answer to the inevitable question from techies in the crowd... where and how is this data stored?

1
carlsheffield•

CDS looks a lot like the Dynamics 365 CE

1
rdmDgnrtd•

Common Data Service storage is done as CSV files in a folder hierarchy in Azure Data Lake Storage Gen2:

1