Connections once defined, are typically browsed and used as a source for drag and drop operations. For database connections, a database link is normally required. This link can be created via the right-click context menu of the selected connection.

Note

WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected connection, and pressing V creates a new version of the connection. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.


Menu Options

Description

Properties

Displays the Properties window for the selected connection.

Version Control

A version of a Connection is a copy of the metadata definition of the Connection at the time of the versioning. This version information can be used to create a new Connection object or can be left as a backup and reference point. Select this option to perform one of the following:

  • New Version - Enables you to create a new version of the selected Connection.
  • Duplicate Object - Enables you to create a new Connection object as a duplicate of the selected Connection.
  • Revert to Version - Enables you to revert to a previous version of the selected Connection. Displays a list of the available versions of the selected Connection object, from which you can select and revert.

Create a SQL Window Connection

Opens the RED SQL Admin tool which enables you to perform SQL queries in the database connection.

Browse Connection

Displays the List Source Tables Connection window which enables you to change the properties of the connection you are browsing or switch to another connection. Refer to Browsing a Connection for details.

Telnet Window

Creates a Telnet window for UNIX connections.

Create Remote View Procedure

Creates a remote view creation procedure, if required for database connections and loads. Refer to Remote View Extract for details.

Create Database Link

Establishes a database link after the relevant connection has been created in RED. Refer to Creating a Database Link for details.

Delete

Deletes the metadata of the selected connection, including all related information.A version of the object's metadata is normally auto-created (depending on the settings in Tools > Options > Metadata Versioning).

Documentation

Select this option to generate (or read if already generated) the WhereScape RED HTML documentation for the selected object. Select this option to perform one of the following:

Projects

Select this option to perform one of the following:

  • Remove from Project - Select to remove the Connection from a project. Refer to Removing Objects from Projects for details.
  • Add to Project - Select to add the Connection to a project. Refer to Adding Objects to Projects for details.
  • List Projects - Displays a list of projects which contain the current object, results are shown in the bottom pane. Refer to List Project Memberships for Objects for details.
    Refer to Organizing Objects for details.

    Note

    • Multiple objects can be selected by double-clicking the Object Group icon in the left pane and then Ctrl + clicking multiple objects in the Drop Target (middle) pane.
    • The above options are unavailable if there aren't any projects in the repository.

Impact

Select this option to run reports on Load and Export objects associated with the connection. Select this option to perform one of the following:

  • Load Tables Report
  • Export Tables Report
    Refer to Table Reports for details.

Build

Select this option to build an application based on the connection(s) selected from the middle pane. Refer to Building Applications from Object Groups for details. This option is available from the context menu of connections in the middle pane.

  • No labels