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 treenodes in the Enterprise Manager, you will see the databases or connection profiles available to you.
Below is an example of the Enterprise Manager with 3 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 green rectangle around the database icon - once disconnected, this green rectangle will be removed.
A connected database
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 metadata changes to a logfile.