Connect to erwin Data Modeler by Quest

erwin Data Modeler by Quest allows you to find, visualize, design, deploy, and standardize high-quality enterprise data assets.

You can connect erwin Data Modeler to an Azure Databricks cluster or SQL warehouse (formerly SQL endpoint).

Requirements

Before you connect to erwin Data Modeler, you need the following:

  • erwin Data Modeler version 12.1 SP1 or above. See the erwin Data Modeler installation guide on the erwin website.

  • An Azure Databricks personal access token.

    Note

    As a security best practice, when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.

Connect to erwin Data Modeler manually

To connect to erwin Data Modeler manually and create a model from your Azure Databricks data, follow Select the Reverse Engineering Options in the erwin Data Modeler documentation.

In the Connection page of the Reverse Engineering Wizard, specify the following:

Additional resources