DbVisualizer

DbVisualizer is a desktop SQL client. Download a ready-made connection from the Universe page and import it, so DbVisualizer can query your DataMind OS data without you setting up the connection by hand.

Before you start

Use a computer. The Universe page is not available on phones.
Install DbVisualizer on your computer.
Have your DataMind OS email and password ready. DbVisualizer asks for your password when you connect.

Download the connection file

Open Universe in the sidebar.
In Integrations, find the DbVisualizer tile.
Click Configuration. Your browser downloads a .jar file, and a Download successful message confirms it.

If you see a Download failed message, try again. If it keeps failing, see Troubleshooting integrations.

Import the file into DbVisualizer

Keep the downloaded file as it is. Do not open or run it.
In DbVisualizer, choose Tools > Import Connections and select the file.
Connect to The Best Data Platform. When DbVisualizer asks for a password, enter your DataMind OS password.
Choose the database you want to work in. The connection does not select one for you.

What the connection contains

The file adds one connection, set up for your account.

Setting	What it does	Default
Name	The name of the connection in DbVisualizer.	The Best Data Platform
Driver	The database driver the connection uses.	ClickHouse
User	The user the connection signs in as.	Your DataMind OS email
Password	Your DataMind OS password.	Empty. DbVisualizer asks for it
Server and port	Where the connection reaches DataMind OS.	Filled in. They match the values in Connection settings
Database	The database the connection opens.	Empty
SSL	Whether the connection is encrypted.	On only when DataMind OS uses encryption

Who can download the file

Any signed-in user can download the connection file. You do not need a special permission.

What you can read in DbVisualizer depends on your roles, the same as in the Editor. See SQL dialect and data scope and Roles and permissions.

Limits and edge cases

The file contains your DataMind OS email as the user name. Each person downloads their own copy, so a colleague cannot use yours.
The file does not contain your password. After you change your password, use the new one in DbVisualizer. See Your profile and preferences.
If the server sends no data for five minutes, the connection times out. Your account also has its own query time limit. See Connection settings.
The file is built when you click Configuration, using the address you opened DataMind OS with. If that address changes, download a new file.

Questions, answered

Should I open the .jar file?

No. Do not open or run it. Import it in DbVisualizer with Tools > Import Connections.

What is The Best Data Platform connection?

It is the name DbVisualizer shows for the connection after you import the file. It connects to your DataMind OS data.

DbVisualizer asks for a password. What do I enter?

Enter your DataMind OS password, the one you use to sign in. The connection is already set up with your email, and the file does not store a password. If you sign in with single sign-on and have no password yet, see Connection settings for how to set one.

Do I need a new file after I change my password?

No. The file does not contain your password, so use your new password when DbVisualizer asks for it.

Can a colleague use my file?

No. The file contains your email, so each person should download their own copy from their own Universe page.

My browser blocked the download. What do I do?

Allow the download in your browser. The file holds connection settings only.

Do I need to set SSL in DbVisualizer myself?

No. The file turns SSL on only when DataMind OS uses an encrypted connection.

Why is no database selected?

The connection leaves the database empty. Choose the database you want to work in after you connect.

What if the import fails?

Create the connection by hand. Use the Host and Port from Connection settings, choose ClickHouse as the driver, and sign in with your DataMind OS email and password.