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.

 

               
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
Pro
DbVisualizer
Free
» Dynamic JDBC driver management (no CLASSPATH editing)
» JDBC drivers included with DbVisualizer
     DB2 for LUW
     H2
     JavaDB/Derby
     Mimer SQL
     MySQL
     PostgreSQL
     Oracle
     SQLite
     SQL Server
     Sybase SQL Anywhere
     Sybase ASE
» SSH support with known_hosts and private key support
» Step-by-step connection setup with a wizard
» 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