Connect to a Database

Previous  Index  Next  How To Use

Once you have registered one or more servers, depending on the database engine type, you can connect to databases available on the server (or Schemas, as some call them) or create a connection profile (Oracle) and see what schemas are available after establishing a session.

 

If you expand the Servers and each server tree nodes in the Server Manager, you will see the databases or connection profiles available to you.

 

Below is an example of the Server Manager with 2 registered servers and several databases:

The Enterprise Manger with listed databases per server

As you can see on the left, each servers lists available database. Double clicking a database or connection profile or right clicking it and select Connect will connect you to the database/schema on the server or establish a database session and opens up a Database Navigator.

 

A connected database/schema will show a less opaque database icon, a more vivid more colorful version of the database.

 

Active Connection

Once connected, the connection will also appear in the upper left corner of the screen of Database Workbench, at the Connection toolbar.

 

The Connection Toolbar

 

All connections are listed in the drop down box and it shows you the "active" connection. When you, for example, open a SQL Editor, the editor will be in the context of the current active connection. Selecting an item from the drop down box will activate that selection.

 

If you have turned on Session Logging in the Database Options, the Database Navigator will automatically start logging all meta data changes to a log file.