Cosmos DB NoSQL JSON DB

I worked extensively with Cosmos DB which is an Azure NoSQL JSON based database based upon and derived from MongoDB.

There's pluses and minuses with Cosmos DB and NoSQL...

The biggest challenges are dealing with slightly misnamed JSON objects and properties and getting the JSON into a relational DB such as SQL Server for reporting...and OLAP cubes.

Else you have to buy a whole new set of reporting tools to handle the JSON!