Open in new window

back

Database Explorer

The Data Tools plug-in provides two special views: the Database Explorer view and the DB Output view. The Database Explorer view is where you will create connections, view your database objects, and launch actions from those objects. The DB Output view is where query results and messages are displayed.

You can open either one by selecting Window/Show View/Other... from the menu bar and then choosing the appropriate view under the Data node.

DatabaseExplorerShowView

The Database Explorer view shows all available connections. To create a new connection right-click anywhere in the window and select New Connection... from the context menu.

Then, follow these steps:

  1. Specify a name for this connection.

    DatabaseExplorerNewConnectionStep1

  2. Select a Database Manager from the tree on the left and specify connection parameters on the right. You can test the connection by selecting the Test Connection button.

    DatabaseExplorerNewConnectionStep2

  3. On this page you can filter the database objects that are retrieved. If you are connecting to a database with a large number of database objects, it is important to filter appropriately to reduce the number of tables returned.

    DatabaseExplorerNewConnectionStep3

  4. The summary page gives you a chance to review the parameters for this connection.

    DatabaseExplorerNewConnectionStepLast

In the Database Explorer, you will see a tree structure representing your connection and the database objects retrieved.

DatabaseExplorerConnectionTree

To sample the data from a table, select the table in the Database Explorer and select Sample Contents from the context menu.

DatabaseExplorerSampleData

This displays the table's sample data in the DB Output view.

DatabaseExplorerSampleDataResult

back