# Configuring available server connections for a workspace

When you add a database connection to a database, or export data to an external database, you select the server connection to use.

From the **Server Connections** section of the workspace settings page, you manage the available server connections for the workspace.

<figure><img src="https://4109733485-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmoU4gTR9LxlzHeWmQCUZ%2Fuploads%2FI6TKMZX1b4rGst3cmmxW%2FWorkspace_ServerConnections.png?alt=media&#x26;token=aa1ec12e-da64-45b4-802c-24dfc94c8209" alt=""><figcaption><p>Server Connections section of workspace settings with a defined server connection.</p></figcaption></figure>

When you create a server connection during database connection configuration or data export, Fabricate automatically adds the server connection to the list.

## Adding a server connection

From the **Server Connections** list, to add a server connection:

### Selecting the platform and providing name

1. Click **Add Server Connection**.

<figure><img src="https://4109733485-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmoU4gTR9LxlzHeWmQCUZ%2Fuploads%2FvQS2a8uFm51jhoQ37R9I%2FWorkspace_NewServerConnection.png?alt=media&#x26;token=df95d8ce-c826-4d83-be22-4356e7851889" alt=""><figcaption><p>New Server Connection panel to create a server connection</p></figcaption></figure>

2. From the **Platform** dropdown list, select the server platform.
3. On the **New Server Connection** panel, in the **Name** field, provide a name to use to identify the server connection.

### Connection details

#### Platforms other than Databricks

For platforms other than Databricks, some platforms allow you to provide a connection string. Fabricate then parses the string and populates the connection fields.

To use a connection string to configure the connection:

1. Click **Paste connection URL**.
2. On the **Paste connection URL** panel, paste the connection string into the field.
3. Click **Apply**.

To fill out the fields manually:

1. In the **Host** field, provide the hostname for the server.
2. In the **Port** field, provide the port to connect through.
3. From the **TLS** dropdown list, select whether to enable Transport Layer Security (TLS).
4. In the **Username** field, provide the username to use to make the connection.
5. In the **Password** field, provide the password.

#### Databricks

For Databricks:

<figure><img src="https://4109733485-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmoU4gTR9LxlzHeWmQCUZ%2Fuploads%2FVmn12loYfWjfimcDZPzO%2FWorkspace_NewServerConnectionDatabricks.png?alt=media&#x26;token=f49003b8-90e7-415e-bcbd-6f60d5ffce0d" alt=""><figcaption></figcaption></figure>

1. In the **Host** field, provide the host where the database is located.
2. From the **Credential Type** dropdown list, select the type of authentication to use. The options are:
   * **Service Principal**
   * **Personal Access Token**
3. For **Service Principal** authentication:
   1. In the **Client ID** field, provide the client identifier.
   2. In the **Secret** field, provide the secret that is associated with the client identifier.
4. For **Personal Access Token** authentication, in the **Access Token** field, provide the access token to authenticate to the database.
5. In the **Warehouse ID** field, provide the data warehouse for the data.

### Testing and saving the connection

1. To test the server connection, click **Test Connection**.
2. To save the server connection, click **Create Server Connection**.

## Editing a server connection

To edit a server connection:

1. Click the **Edit** option for the server connection.

<figure><img src="https://4109733485-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmoU4gTR9LxlzHeWmQCUZ%2Fuploads%2FpgJA4jOFBO8nHN6USEZj%2FWorkspace_EditServerConnection.png?alt=media&#x26;token=ffa2c4bd-7c67-4b85-b654-ad200684304e" alt=""><figcaption></figcaption></figure>

2. On the connection details panel, update the connection information.\
   \
   Note that if you are not changing the password or a Databricks secret for the server connection, then leave the **Password** or **Secret** field empty.
3. To test the updated configuration, click **Test Connection**.
4. To save the changes, click **Save Changes**.

## Deleting a server connection

You cannot delete a server connection that is either:

* Used in a database connection.
* The server connection for a database export target. Before you can delete the server connection, you must remove the export target.

From the **Server Connections** list, to delete a connection, click its **Delete** option.
