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
Connection
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."
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.)
Last updated