# DbVisualiser

DbVisualizer is a versatile SQL editor and universal database tool, available as an open-source application for local installation on your workstation. By leveraging the JDBC driver, DbVisualizer enables seamless access to e6data clusters, empowering users with efficient database management capabilities.

## Requirements

* Users of the e6data cluster must use DbVisualiser 23.2.4 or newer.
* Install the latest [e6data jdbc driver](/product-documentation/connectors-and-drivers/jdbc-driver.md)

## Connection

Get the necessary [connection information](broken://pages/amzyzgmFtIIvAWabchFw) for your cluster:

* JDBC URL
* Username 
* Password ([Personal Access Token](broken://pages/BO9IJX3Hj4YaBgnZ1VGK))

<details>

<summary>Connection string for Direct Connectivity Endpoint</summary>

Syntax of the JDBC URL required to establish a DB Visualiser connection with the e6data cluster when connecting using the Direct type of connectivity in endpoints:&#x20;

{% code overflow="wrap" %}

```
jdbc:e6data://<host>:<port>/database=<database_name>&catalog=<catalog_name>
```

{% endcode %}

</details>

<details>

<summary>Connection string for TLS Connectivity Endpoint</summary>

Please refer to the syntax of the JDBC URL required to establish a DB Visualiser connection with the e6data cluster when connecting via TLS type of connectivity in endpoints:

{% code overflow="wrap" %}

```
jdbc:e6data://<host_name>:<port./database=<database_name>&catalog=<catalog_name>&secure=true&cluster-uuid=<cluster_uuid>
```

{% endcode %}

</details>

1. Click on "Create Database" to establish a new connection.
2. Search and select "Custom" from the connection list.

<figure><img src="/files/UYMj3agoF69IfZ6r9Gyt" alt=""><figcaption></figcaption></figure>

3. Give the appropriate name for the driver.
4. In the settings format, select the database URL.
5. Give the connection string in the database URL.

<figure><img src="/files/yTYq8SqHgTcvQmK7Ii25" alt=""><figcaption></figcaption></figure>

6. Click "Connect" to add the JDBC jar through the driver manager.
7. Now, open the Driver Manager, provide the name, and JDBC connection string, and add the driver here.

<figure><img src="/files/VL3NvCC7OL5flzOI59bI" alt=""><figcaption></figcaption></figure>

8. Go to the database connection, add the database URL, database user ID, and password, and click on "Connect."

<figure><img src="/files/J0FFjyvcItJt75oCav15" alt=""><figcaption></figcaption></figure>

## TLS/HTTP

e6data utilizes globally trusted certificates, ensuring that the host and port provided by the connection dialogue are adequate. Any e6data cluster necessitating authentication must also employ TLS/HTTPS. If adhering to globally trusted certificate best practices, utilize the cluster’s HTTPS URL in the connection string as detailed in the aforementioned steps. (Only required for TLS connectivity type of endpoints.)&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.e6data.com/product-documentation/connectors-and-drivers/dbvisualiser.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.