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:
In the sidebar, click
Partner Connect.Click the erwin tile.
In the Connect to partner dialog, for Compute, select the Azure Databricks compute resource that you want to use.
Click Download connection file.
Open the downloaded connection file, which starts erwin Data Modeler.
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.Click Connect.
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:
- The values described in the Connection section of Reverse Engineering Options for Databricks.
- The personal access token from the requirements.