Dynamics 365 creating a Virtual entity linked to CosmosDB

(0) Share

Report

Posted on by cristina_b

I've read the documentation on creating virtual entities and CosmosDB data sources but it's still unclear to me what's the External Name and External Collection Name of the Virtual Entity because the msdn documentation refers to the 'table name' but, as you know, CosmosDB doesn't really have tables, rather collections and documents.

This is what my CosmosDB portal shows (I had to obfuscate the text - sorry for this) :

2262.Azure.png

So, is the External Name, (1) 'MyData'

or (2) 'CollectionName'

or even (3) 'Documents'

Also, which is the External Collection Name in this case? (the use of 'Collection' is very confusing now in relation to the CosmosDB data source).

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

cristina_b 57 on at

Like (0)

Report

After a lot of digging up, I found the answer in the comments of the microsoft documentation: docs.microsoft.com/.../virtual-entity-documentdb-provider-requirements.

Apparently Nicolas Nowinski found the issues in Microsoft's documentation and shared the solution with the community - why Microsoft didn't update its documentation in the light of this findings, totally eludes me:

'Additional/Corrected Details Needed to Successfully Get the Provider Working

Configure Cosmos DB for the SQL API.

Azure Cosmos DB Data Source:

1. The Collection Name value is actually supposed to be the Database name.

2. Take Authorization Key and Uri from the Read-only tab in the portal.

Entity Configuration

External Name and External Collection Name should be the same value. That value is the Collection name in CosmosDB.'

Was this reply helpful? Yes No