Hide databases in Preferences

You can now use a Preferences option on a modeling workbench to hide databases from the Databases tree. When you hide a database, it is hidden in the Databases tree on both the modeling workbench and in books (Reports and Analysis). Though hidden, an active database remains running and available to processes, chores, action buttons, and any other components or features that reference the database.

  1. Open a modeling workbench.
  2. Click Preferences icon to open Preferences.
  3. Click the Database tree preference section.
  4. On the Hidden databases preference, search for the database that you want to hide or click the Open icon Open icon to reveal all running databases.

    If there are fewer than five databases running in your environment, you don't need to click the Open icon; all running databases are shown

    The list of running databases is static, so it's possible that a database could start after you open the Preferences and not be visible in the list. You can click Refresh databases to update the list.

  5. Toggle the visibility of a database by clicking the box next to its name.

    The Hidden databases preference indicates how many databases are hidden.

    Database tree preferences
  6. To see your changes, refresh the Databases tree on the workbench.

This new preference also applies to the display of databases on the search panel. There is no impact on open editors or saved workbenches, however, Find in tree will not find hidden databases.

Note: While this preference can be set only on modeling workbenches, the setting also applies for the same modeler user in books. If a modeler hides a database on the tree in a modeling workbench, the database is also hidden for the same modeler on the tree in a book.

For more information on preferences, see Workbench preferences.