DbSchema for Dataverse Databases

DbSchema is a powerful database management and design tool for Dataverse. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.

How to Connect to Dataverse

Retrieve environment host and make sure TDS endpoint is enabled

Open the Power Platform admin center at https://admin.powerplatform.microsoft.com/

The following instructions depend on whether you are using the old or the new UI.

Old UI

You know that you're using the old admin center UI if this toggle is off in the top toolbar: Toggle showing New Admin Center disabled.

In this case:

  1. Go to Environments in the left sidebar
  2. Click on an environment that has Dataverse enabled (it has Yes in the Dataverse column)
  3. Copy the host name of the environment from the Details panel (org63ec15e8.crm4.dynamics.com in this case):

    Environment URL (hostname)

  4. Choose Settings on the top toolbar
  5. Go to Product -> Features
  6. Enable TDS endpoint in the section with the same name:

    Toggle showing TDS endpoint enabled

New UI

You know that you're using the new admin center UI if this toggle is on in the top toolbar: Toggle showing New Admin Center enabled.

In this case:

  1. Go to Manage in the left sidebar
  2. Click on Environments
  3. Click on an environment that has Dataverse enabled (it has Yes in the Dataverse column)
  4. Copy the host name of the environment from the Details panel (org63ec15e8.crm4.dynamics.com in this case):

    Environment URL (hostname)

  5. Choose Settings on the top toolbar
  6. Go to Product -> Features
  7. Enable TDS endpoint in the section with the same name:

    Toggle showing TDS endpoint enabled

Connect from DbSchema

  1. Access the Connection Dialog

    Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

    DbSchema automatically downloads the JDBC driver to ensure a smooth connection to Amazon Athena.

  2. Configure the Connection

    3. In the Connection Dialog window, select the JDBC URL you want to connect with.

    Choose Microsoft Entra / Active Directory Interactive Multi-Factor Authentication if the authenticating user has MFA enabled. When attempting to connect, a browser window will be opened where you can input your MFA code.

    Choose Microsoft Entra / Active Directory User and Password if the authenticating user doesn't have MFA enabled.

    Enter the host name that you copied from the UI, the authentication details, and the database name as described in the Connection Dialog page.

    Connecta to Dataverse in DbSchema