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 a Databricks cluster or SQL warehouse (formerly SQL endpoint).
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.
A Databricks personal access token.
As a security best practice when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens or personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.
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 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.
Starting with step 7, follow Select the Reverse Engineering Options in the erwin Data Modeler documentation to create a model from your Databricks data.
To connect to erwin Data Modeler manually and create a model from your 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.