Ribbon Tabs

Reference:

The ribbon represents the activities performed in the DMC. Commands are active or inactive depending on the activity being performed. These include a general toolbar for operations like opening and saving files, a process and data flow toolbar for operations like running and deleting flows, a specialized process flow toolbar for adding objects to the workspace, and a reports toolbar for operations like displaying data in a spreadsheet.


Top of page

x
Reference: Quick Access Toolbar

The Quick Access Toolbar contains the following buttons, as default. Other buttons can be added as required.

Button

Function

New

Creates new flows, stored procedures, synonyms, specialized flows, or server connections, as well as configure adapters.

Save

Saves the current procedure under a specified file name.

Save As

Saves the current procedure under a specified file name.

Refresh

Refreshes the Explorer tree in the navigation pane.


Top of page

x
Reference: Home Tab

The Home tab consists of the following five groups:

View Group

The View group consists of the commands shown in the following image.

Status Bar

Displays the status bar at the bottom of the DMC.

Browser

Displays the browser in the DMC.

Console Log

Displays the Console Log in the DMC.

Full Screen

Displays the workspace in full screen mode.

Explorer

Opens a Windows Explorer style window on the right side of the DMC that shows detailed information about the currently selected server object.

Back

Goes back one directory level. This option is available when in Explorer view.

Forward

Goes forward one directory level. This option is available when in Explorer view.

Up

Goes up one directory level. This option is available when in Explorer view.

Filter Group

The Filter group consists of the commands shown in the following image.

Clear

Clears any of the filters set for an application directory.

Procedures

Shows saved flows, procedures, and user functions in the application directory.

Synonyms

Shows synonyms that describe data.

Advanced

Allows you to specify what you want to see in the navigation pane. For more information, see Advanced Command.

Find File Group

The Find File group consists of the commands shown in the following image.

Find File Group

Find What

Allows you to specify a term to search for in an application directory. You can specify that the search needs to match a whole word or case, by selecting the appropriate check box below the find field.

Tools Group

The Tools group consists of the commands shown in the following image.

Tools Group

Console Log File

Opens the console log file in a text editor, such as Notepad.

Selecting the arrow opens a context menu with the following additional options:

  • View Console Log File. Opens the console log file in a text editor, such as Notepad.
  • Clear Console Log Window. Deletes all information from the message window.
  • Clear Console Log File. Deletes all information from the message window log file.
License Code

Opens the Product License Code window where you can view or change your license code.

Language Selection

Opens the Language Selection window where you can configure a localized version (for selected languages) of the Data Management Console and the language used for text entry and display.

Options

Opens the Options dialog box where you can set user preferences. For more information, see Setting User Preferences.

Configure Source Control

Opens the Configure Source Control dialog box where you can select a SCC Provider if you have one installed on your PC.

Windows Group

The Windows group consists of the commands shown in the following image.

Windows

Has the following options from the context menu:

  • Close. Closes the active window in the workspace.
  • Close All. Closes all the open windows in the workspace.
  • Close All But This. Closes all open windows in the workspace except for the one currently open.
MDI Tabs

Has the following options from the context menu:

  • New Horizontal Tab Group. Creates a new horizontal tab group and opens the last object there.
  • New Vertical Tab Group. Creates a new vertical tab group and opens the last object there.
  • Move to Next/Previous Tab Group. Changes the focus to the next or previous tab group. This option is available only if multiple tab groups are open.

Top of page

x
Reference: Flow Tab

The Flow tab consists of the following groups that apply to both a Data and Process Flow. Some of these commands are only available when working with a Process Flow.

Undo/Redo Group

The Undo/Redo group consists of the commands shown in the following image.

Undo

Undoes the last operation.

Redo

Undoes the last undo.

Clipboard Group

The Clipboard group consists of the commands shown in the following image.

Delete

Deletes the selected object.

Cut

Cuts the selected item.

Copy

Copies the selected item.

Paste

Pastes the cut or copied item.

Editing Group

The Editing group consists of the commands shown in the following image.

Find

Opens the Find dialog box, which allows you to enter a text string and search parameters. This option is available when in Text or Edit as Text view.

Find Next

Finds the next occurrence. This option is available when in Text or Edit as Text view

Find Previous

Finds the previous occurrence. This option is available when in Text or Edit as Text view.

Select All

Selects all of the text in the file. This option is available when in Text or Edit as Text view.

Replace

Opens the Replace dialog box that lets you enter a text string to find and replace it with. This option is only available when in Edit as Text view.

Go To

Opens the Go To Line dialog box, which allows you to enter a specific line number to view. This option is available when in Text or Edit as Text view.

View Group

The View group consists of the commands shown in the following image.

Data Flow

Switches to the Data Flow view in the workspace.

Process Flow

Switches to the Process Flow view in the workspace.

Text View

Switches to the Text view in the workspace.

Aerial View

Opens the Aerial View window.

FInd Flow Object Group

The Find Flow Object group consists of the commands shown in the following image.

Find Flow Object group

Find What

Allows you to specify a term to search for in the workspace. You can specify that the search needs to match a whole word or case, by selecting the appropriate check box below the Find What field.

Insert Group (Data Flow Only)

If you are working with a data flow, the Insert group consists of the commands shown in the following image.

Source

Creates a source in the workspace.

Join

Joins two objects in the workspace.

Select

Creates a select object in the workspace.

Union

Creates a union object in the workspace.

Existing Target

Adds an existing target in the workspace.

New Target

Creates a new target in the workspace.

Insert Group (Process Flow Only)

If you are working with a process flow, the Insert group consists of the commands shown in the following image.

Procedure

Creates a Stored Procedure object in the workspace.

Flow

Creates a flow object in the workspace.

E-Mail

Creates an email object in the workspace.

Parallel Group

Creates a Parallel Group object in the workspace.

Wait

Creates a Wait object in the workspace.

Set Variables

Sets variables for the process flow.

Run Group

The Run group consists of the command shown in the following image.

Run

Launches a drop-down menu for Submit, Run, Run with Options, and Impact Analysis.

Reports Group

The Reports group consists of the commands shown in the following image.

Impact Analysis

Runs the impact analysis report for the flow that is currently open.

View Last Log

Opens the last log for the flow that is currently open.

View Flow Report

Runs the flow report for the flow that is currently open.

Tools Group

The Tools group consists of the commands shown in the following image.

Arrange Items

Rearranges the objects in the workspace.

Validate

Validates the flow.

Properties

Displays the property pane for the flow.


Top of page

x
Reference: User Functions Tab

The User Functions tab becomes active when you edit functions. It contains the following additional groups:

View Group

The View group consists of the commands shown in the following image.

Tree View

Shows the selected function in a tree view.

List View

Shows the selected function in a list view.

Text View

Shows the selected function in a text view.

Insert Group

The Insert group consists of the commands shown in the following image.

Function

Creates a new function for the function.

Parameter

Creates a new parameter for the function.

Define

Creates a new define for the function.

Run

The Run group consists of the command shown in the following image.

Test Function

Opens the Test Function dialog box, where you can enter values to test the function.

Tools Group

The Tools group consists of the command shown in the following image.

Properties

Opens the Properties pane for whatever is selected in the workspace.


Top of page

x
Reference: Report Tab

The Report tab becomes active when you run a report or view the Server Session Log. The Report tab has the following additional groups.

Print Group

The Print group consists of the commands shown in the following image.

Report Print Group

Print

Opens the print dialog box to print the report.

Print Preview

Displays the preview of the to be printed.

Run Group

The Run group consists of the commands shown in the following image.

Refresh

Reruns the report.

Next Result

Displays the next report in the output.

Note: This option is only available for output with multiple pages.

Automatic Refresh

Automatically reruns the report at the refresh interval specified.

Refresh Interval (in seconds)

Allows you to specify how often a report reruns.

Tools Group

The Tools group consists of the commands shown in the following image.

Report Tools Group

Export to Excel

Exports the report as an Excel spreadsheet.

Note: This option is available for Alpha and Original output only.

Copy as Text

Copies the selected report text to the clipboard.

Filter

Allows you to specify what information is shown in the report. The options available are FOCUS, SQL/Mdx, Transform, Errors, Messages, Timestamp, and No Delay. This option is available when viewing a Server Session Log.

Clear Messages

Deletes all messages from the log and controls what types of messages appear in the server session log. This option is available when viewing a Server Session Log.

Choose Columns

Opens the Scheduler Agent page where you can select the columns that appear on the scheduler agents page. This option is available when viewing the Scheduler Agent.

Choose States

Opens the Select the states that will appear on the Scheduler Agents dialog box where you can select what states will appear on the Scheduler Agents page. This option is available when viewing the Scheduler Agent.

Activate Selected

Allows you to select multiple flows or procedures and set the schedule status as active in a single operation. When using this command, it is recommended that you use Choose columns and select the Status column to display. This option is available when viewing the Scheduler Agent.

Deactivate Selected

Allows you to select multiple flows or procedures and set the schedule status as inactive in a single operation. When using this command, it is recommended that you use Choose columns and select the Status column to display. This option is available when viewing the Scheduler Agent.


iWay Software