Feature TourFeature Tour

Connection Management

Previous Next

DbVisualizer is based on the JDBC toolkit and there are JDBC drivers for almost every database that is available on the market. DbVisualizer supports connecting to local, remote (with option for SSH) and embedded (Java based) databases. Connection management is flexible, with options to set up a connection via the step-by-step Connection Wizard or by manually defining the connection data.

By default, separate physical connections are used to provide transaction isolation and to ensure reliable parallel execution. When needed, e.g. when working with an embedded database, a single physical connection can be used for everything instead.


Defining a database connection is a simple task using the Connection Wizard in
DbVisualizer. In the wizard, choose what database you are connecting to,
information about the JDBC driver and finally the details about the database
server and user credentials. An alternative to the wizard is to setup the
connection manually via the Server Info and Database URL forms in the Connection tab.
Connection Wizard

Along with the Connection Wizard is the Server Info the preferred methods to
manage connection details. It presents the various parameters in a form that
adapt the choices based on your input. The screen image also show the SSH fields.
Connection setup using Server Info and SSH

The conventional JDBC setup is used for databases with no pre-defined
Server Info.
Connection setup using Database URL

Connection Details with Variables

Connection Properties

For each database connection you may assign a color and/or border. These will appear
for the components in the DbVisualizer GUI that are referenced by the connection.
This is useful in order to quickly determine what parts belong to which connection.
Borders and Colors

JDBC Driver Manager
Feature DbVisualizer
» Dynamic JDBC driver management (no CLASSPATH editing)
» JDBC drivers included with DbVisualizer:
     DB2 for LUW
     Mimer SQL
     SQL Server
     Sybase SQL Anywhere
     Sybase ASE
» SSH support with known_hosts and private key support
» Step-by-step connection setup with a wizard
» Connection Keep-Alive
» Optionally use a single physical connection for all operations
» Organize database connections in folders
» Set individual tab background color and borders for each connection
» Parameterized connection data
» Supports multiple simultaneous open database connections
» Connect a single or multiple connections with a single click
» Export and Import connections and general user settings
» Basic password Security
» Strong master password Security
» Show passwords in plain text if using master password Security