Microsoft Dataverse

6th April, 2022
Applies to: Dataedo 10.x versions, Article available also for: 24.x (current), 23.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

Dataedo 10.2 adds native connector to Microsoft Dataverse platform.

Dataverse connector allows accessing data in Microsoft Dynamics 365 and other tables you store inside Dataverse instance.


Supported schema elements and metadata

  • Tables
    • Display name (Title)
    • Description
    • Columns
      • Logical name
      • Display name (Title)
      • Position
      • Data type
      • Description
    • Primary keys
    • Unique keys
  • Views
    • Columns
      • Logical name
      • Display name (Title)
      • Data type
      • Description
    • OfflineSQLQuery (Script)

Unique keys

Datedo marks columns as unique keys when data type equals UniqueIdentifier or column has defined alternate key on it.

Data profiling

Datedo does not support data profiling in Microsoft Dataverse.

Connecting to Dataverse

Add new connection

To connect to Dataverse and create new documentation click Add documentation and choose Database connection.

Image title

On the connection screen choose Microsoft Dataverse as DBMS.

Image title

Connection details

  • Environment URL - URL to your Dataverse instance. eg.
  • User - Dataverse username.
  • Password - Dataverse password.
  • Language
    • User localized language - The language current user has the account set up.
    • Organization base language - Default language enabled and set by organization.
  • App ID - Application ID. The default App Id is provided by Microsoft for tests and development purposes. If you’d like to change it, set up an application with the Microsoft identity platform. Learn more
  • Redirect URI - Redirect URI needs to match a URI set up with your Microsoft identity app. The default Redirect URI is provided by Microsoft and meant for tests and development. Learn more

Get Environment URL

  1. Go to and log in with you Microsoft account.
  2. Click Settings icon in the top right corner.
  3. Open Session details
  4. Copy Instance Url, this is your Dataverse Environment URL.

Image title

Saving password

You can save password for later connections by checking Save password option. Passwords are securely stored in the repository database.

Importing schema

When the connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use an advanced filter to narrow down the list of objects.

Image title

Confirm list of objects to import by clicking Next.

The next screen allows you to change the default name of the documentation under your schema will be visible in the Dataedo repository.

Image title

Click Import to start the import.

Image title

When done close import window with Finish button.


Your database schema has been imported to new documentation in the repository.

Image title

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.