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, 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 simply 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 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 meta data of the selected connection, including all related information.A version of the object's meta data is normally auto created (depends 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:

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.
  • If there aren't any projects in the repository, the above options are unavailable.


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 listed in the middle pane.

  • No labels