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:
- The values described in the Connection section of Reverse Engineering Options for Databricks.
- The personal access token from the requirements.