DbVisualiser
Last updated
Last updated
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.
Users of the e6data cluster must use DbVisualiser 23.2.4 or newer.
Install the latest
Get the necessary connection information for your cluster:
JDBC URL
Username
Password (Personal Access Token)
Click on "Create Database" to establish a new connection.
Search and select "Custom" from the connection list.
Give the appropriate name for the driver.
In the settings format, select the database URL.
Give the connection string in the database URL.
Click "Connect" to add the JDBC jar through the driver manager.
Now, open the Driver Manager, provide the name, and JDBC connection string, and add the driver here.
Go to the database connection, add the database URL, database user ID, and password, and click on "Connect."
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.)