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