Using the Datasource Navigator

From DBArtisan
Jump to: navigation, search

Go Up to Datasource and Server Management

The Datasource Navigator provides a visual method for browsing, accessing, and manipulating objects. The Datasource Navigator contains a hierarchy consisting of groups, datasources, object type, and object nodes. Higher level nodes in the hierarchy have an associated Expand/Collapse icon, letting you drill down through the hierarchy to expose lower level nodes and objects.



  • Groups organize the available data sources. A default set of groups corresponds to the supported DBMS platforms. You can also create custom groups to organize your data sources. For more information, see Categorizing Datasources using Color-coding and Labeling.
  • Inside these groups are the data sources on your network that you have registered. You must register data sources in order to work against them. For more information, see Registering Datasources and Connecting to Datasources.
  • With the exceptions of the Filters node, nodes below the datasource level correspond to the object types supported on the DBMS platform. For more information on the Filters node, see Filtering in the Navigator.
  • At the lowest level, are the individual database objects on the data source. For a listing of object types by DBMS platform and detailed support summaries for each type, see Supported Objects.

DBArtisan also provides the Database Explorer, providing functions similar to the Navigator. Key differences are as follows:

  • It is a two-pane window that lets you use the left pane to drill down to the object level while using the right pane to view details on the currently selected node. For example, if the selected node is a supported object type, the right pane will show individual objects of that type. For details, see Navigating the Datasource Explorer and Displaying Nodes or Objects.
  • Intermediate level nodes correspond to a default hierarchy of object type categories. For example, the Security node for a given platform may contain object types such as users, logins, or roles. For an introduction to the hierarchy of datasource nodes, see Understanding the Explorer Tree Hierarchy.

For information on opening and closing the Navigator, Hiding and Displaying the Datasource Navigator

Bookmarks provide another means to quickly navigate to specific Navigator object nodes. For details, see Working with Bookmarks.

You can also initiate object type-specific actions and open object editors from the Navigator. For details, see Initiating Object Actions in the Navigator.

A number of viewing and organization options are available. They let you optimize the Navigator for your own purposes. These include:

  • Basic viewing options that let you toggle between type-based or owner-based display, one-step expansion and collapse of hierarchy elements, hiding or display of system objects, saving of view option settings.
  • Creating custom datasource groups to provide a deeper level of organization.
  • Categorizing datasources using color-coding and labeling to quickly distinguish between datasources used for different purposes in your organization.
  • Filtering the Navigator tree to display only selected nodes and objects. You can filter by name, schema or object type,