Skip to end of metadata
Go to start of metadata

To access a database with DbVisualizer, you must first create and setup a Database Connection. The easiest way to set up a connection is to use the Connection Wizard, but you can also do it manually.

Using the Connection Wizard

  1. Launch the wizard from Database->Create Database Connection and click Use Wizard when prompted,
  2. Enter a name for the connection on the first Wizard page and click Next,

  3. Select an installed JDBC driver (marked with a green checkmark) on the second wizard page (see Installing a JDBC Driver for how to install a JDBC driver manually),

  4. Enter information about the database server on the third wizard page (see below for details),
  5. Verify that a network connection can be established to the specified address and port by clicking the Ping Server button,
  6. If Ping Server shows that the server can be reached, click the Finish button to create the connection.
  7. An Object View tab for the new connection is opened automatically. If the connection to the database can be established, the Connection Message area in the tab shows the database and driver versions, otherwise it shows a message about what is wrong. 
     

See Fixing Connection Issues for some tips if you have problems connecting to the database.

The information about the database server that needs to be entered depends on the which JDBC driver you use. For most drivers, you need to specify:
FieldDescription
Database ServerThe IP address or DNS name for the server where the database runs.
Database PortThe TCP/IP port used by the database.

Database Userid

The database user account name. Enter (null) to not send an account name.
Database PasswordThe database user account password. Enter (null) to not send a password.

For some database such as Oracle, you may use a TNS name instead of specifying the server and port. Other drivers may add more fields that are driver specific.

You may also optionally specify SSH tunneling information and Options, such as:

OptionDescription
Auto CommitCheck if you want to enable auto commit in the SQL Commander by default for the connection.
Save Database PasswordCheck if you want the password to be saved (encrypted) during the session, between sessions, or cleared when you disconnect.
Permission ModeOne of Development, Test or or Production to select which set of Permissions to use.

Additional options are available for some JDBC drivers, such as Authentication Method for the SQL Server jTDS driver.

See the Configuring Connection Properties page for related topics.

Setting Up a Connection Manually

  1. Create a new connection from Database->Create Database Connection and click No Wizard when prompted. An Object View tab for the new connection is opened,
  2. Enter a name for the connection in the Name field, and optionally enter a description of the connection in the Notes field,
  3. Leave the Database Type as Auto Detect,
  4. Select an installed JDBC driver (marked with a green checkmark) from the Driver (JDBC) list (see Installing a JDBC Driver for how to install a JDBC driver manually),
  5. Enter information about the database server in the remaining fields (see below for details),
  6. Verify that a network connection can be established to the specified address and port by clicking the Ping Server button,
  7. If Ping Server shows that the server can be reached, click Connect to actually connect to the database server.

See Fixing Connection Issues for some tips if you have problems connecting to the database.

Alternatively, you can set the Settings Format to Database URL (this is the only choice for some custom JDBC drivers). This replaces the fields for information about the database server with a single Database URL field, where you can enter the JDBC URL.

The information about the database server that needs to be entered depends on the which JDBC driver you use. For most drivers, you need to specify:
FieldDescription
Database ServerThe IP address or DNS name for the server where the database runs.
Database PortThe TCP/IP port used by the database.

Database Userid

The database user account name. Enter (null) to not send an account name.
Database PasswordThe database user account password. Enter (null) to not send a password.

For some database such as Oracle, you may use a TNS name instead of specifying the server and port. Other drivers may add more fields that are driver specific.

You may also optionally specify SSH tunneling information and Options, such as:

OptionDescription
Auto CommitCheck if you want to enable auto commit in the SQL Commander by default for the connection.
Save Database PasswordCheck if you want the password to be saved (encrypted) during the session, between sessions, or cleared when you disconnect.
Permission ModeOne of Development, Test or or Production to select which set of Permissions to use.

Additional options are available for some JDBC drivers, such as Authentication Method for the SQL Server jTDS driver.

See the Configuring Connection Properties page for related topics.

  • No labels