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 using Partner Connect

To connect to erwin Data Modeler using Partner Connect, do the following:

  1. In the sidebar, click Partner Connect button Partner Connect.

  2. Click the erwin tile.

  3. In the Connect to partner dialog, for Compute, select the Azure Databricks compute resource that you want to use.

  4. Click Download connection file.

  5. Open the downloaded connection file, which starts erwin Data Modeler.

  6. On the Connection page of the Reverse Engineering Wizard, enter your authentication credentials:

    For User Name, enter token. For Password, enter the personal access token from the requirements.

  7. Click Connect.

  8. Starting with step 7, follow Select the Reverse Engineering Options in the erwin Data Modeler documentation to create a model from your Azure Databricks data.

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