The Data Flow Interface

As shown in the following image, when you create a new flow, the Data Flow tab opens by default, with an SQL object in the workspace to anchor the flow. By default, the Synonyms button in the navigation pane is active and ready for you to add data source objects. You can change this from the Options menu by deselecting the Automatically switch filters check box on the General page. The Flow toolbar is also active.

You add data source objects and data target objects, and use the SQL object to establish rules for extracting and moving data between them.

Note: As you build the data flow, you can click the Text View tab at any point to see the underlying code that is generated as you make your additions and selections.

Reference: Navigation Pane: Procedures Button

The Procedures button shows saved flows and stored procedures , as well as utilities and several types of reports that you can run. You can add flows and stored procedures to a process flow by dragging them from the navigation pane into the workspace. The following image shows the active Procedures button.

The process flow and Tool bar navigation image

If you right-click a flow Flow Procedure button or a stored procedure Flow Stored Procedure button or highlight one and press the menu key , a shortcut menu opens, as seen in the following image.

The following options are available:

Open

Places the flow or stored procedure in the workspace.

Edit as Text

Opens the code behind the flow in the workspace.

Note: If you change the text behind the flow, those manual changes will be lost if you edit and resave the flow in the DMC. This option is only available for a flow.

Submit

Submits the flow to the server. This option is only available for a flow.

Run

Runs the flow or stored procedure immediately.

Run Advanced

Has the following option:

Run with Options. Runs the flow or stored procedure. The Run flow/procedure dialog box opens as seen in the following image.

Run changing defaults

Allows you to run the flow or stored procedure with values assigned for any variables used in the flow or stored procedure, for example, in a WHERE condition.

Run with Limits

Allows you to set start and stop record loading limits. This option is only available for a flow.

Submit with Options

Submits the flow or stored procedure to the server to be run, with the same options available in Run with Options: Submit changing defaults and Submit with Limits. The Submit flow/procedure dialog box opens as shown in the following image.

Do not wait for completion. Allows you to continue your work as you wait for the submitted flow or stored procedure to complete. When this option is selected an additional checkbox appears which allows you to specify that the flow or procedure should be run at a specified date time.
E-mail Notification Condition. Allows you to specify conditions for sending email. The options are:
Start

When the procedure begins.

Completion

When the procedure completes.

Failure

Only used if the procedure fails.

On Completion or Failure, the e-mail message will contain attachments of the log and output from the procedure, if any.
Mail To. Field where you enter the e-mail address that the message is being sent to.
Submit changing defaults. Prompt to override default values for variables procedure or flow, then run it.
Submit with Limits. This option is only available for DataMigrator flows, not stored procedures. Allows you to specify the start and end of the loading records.

Schedule/E-mail

Has the following options:

Manage. Allows the schedule and email notification settings for a flow or stored procedure to be changed without opening the flow, as seen in the following image.

For more information about scheduler options, see Schedule Attribute Pane. For more information on e-mail notifications, see Flow Properties Pane - E-Mail Notification Attribute.
Scheduler Agents. This report runs for the user whose ID value is stored in the sched_scan_id of a Scheduler. The Scheduler must be active to run the Scheduler Agents report.
Scheduled Events. Opens a window that shows all jobs scheduled to run during a specified time range, as seen in the following image.

The Scheduler must be active to run the Scheduler Events report.

Logs

Has the following options:

Last Log. Shows the last log available for the selected flow or stored procedure.
Last Output. Shows the last output, if any, for the selected flow.
Log and Statistics. Opens the Log and Statistics dialog box that enables you to view a log or statistics report, as seen in the following image.

Report Type

Allows you to select either a log or statistics report.

Report Range

Allows you to select to view the last report, all the reports, or a report specified within a select time range.

Completion Status

Allows you to view all reports, all completed reports, all completed successfully reports, or all completed reports that contained errors.

Run by

Allows you to view reports for all flows, and those initiated by the scheduler or submit. This includes flows initiated from the DMC, WC, and CMRUN.

Impact Analysis

Opens a report that shows every flow or stored procedure that calls the selected flow.

Flow Report

Provides a summary of the attributes of the flow. This option is only available for flows.

Cut, Copy, Delete, Rename

Cuts, copies, deletes, or renames the flow or stored procedure.

Privileges

This option is only available if the server is started with security enabled. For more information, see Manage Privileges Dialog Box.

Source Control

This option only appears if you have a source management program configured on your machine. It has the following options:

Add/Check In: Adds or checks files into source management.
Check Out: Checks files out of source management.
Undo Check Out: Cancels a check out.
History: Provides the source management history of a file.

Properties

Opens a Properties dialog box of the selected flow or stored procedure.

Reference: Navigation Pane: Synonyms Button

The Synonyms button shows synonyms that describe the data. You can use them as data sources or data targets in your flow. The synonym type is listed after its name. The type of synonyms available will depend on the adapters that are configured on your server. The following image shows the active Synonyms button.

The Active Synonyms Button image

If you right-click a synonym or highlight one and click the menu key , the following options are available:

Synonym Right-Click Options

Open

Opens the synonym in the workspace. The file, segments, and columns appear on the left and their attributes and values appear on the right.

Edit as Text

Places the synonym code in the workspace where it can be edited.

Edit Access File as Text

Places a relational synonym Access File in the workspace where it can be edited. This option is not available for FOCUS files.

Create Business View

In WebFOCUS Developer Studio, enables you to create a business view of a synonym by limiting the columns available to any retrieval request that references the business view.

Note: The use of Business Views as a source in DataMigrator is planned for a future release.

Sample Data

Shows a sample of the data associated with the synonym.

Data Profiling

Provides the data characteristics for synonym columns. This selection has the following options:

Statistics: Shows the values for the selected synonym only.
Key Analysis: Allows you to select the columns that you would like to analyze as potential keys to the source table.

Data Management

This selection has the following options:

Recreate DBMS Table

Deletes the data and recreates the underlying DBMS table of the synonym.

Note: Use caution when using this command if the database table was created using the data description language of a particular RDBMS. Some attributes of relational database tables, including the column order and database constraints are not reflected in the synonym, and therefore, cannot be recreated.

Delete ALL Data

Deletes the data from a synonym. This is useful to clear a synonym that will be used as a data target.

Insert Sample Data

Loads the synonym with sample records (for relational and flat file synonyms). You will be prompted for the number of sample records to load into the table. This option is not supported BINARY fields.

Note: If you are inserting sample data into a flat file, the synonym must contain a DATASET statement indicating where to put the data, or the flat file must first be allocated with a FILEDEF statement.

Quick ETL Copy

Creates a simple Data Flow that selects all rows and columns from a source table.

Impact Analysis

Allows you to assess the impact of a change to the synonym on this server and any subservers that use it. Lists all flows, stored procedures, or reports using the synonym. For data flows, it will indicate whether the synonym is used as a source or a target. Flows and stored procedures are referred to generically as procedures.

Source Control

This option only appears if you have a source management program configured on your machine. It has the following options:

Add/Check In: Adds or checks files into source management.
Check Out: Checks files out of source management.
Undo Check Out: Cancels a check out.
History: Provides a file's source management history.

For more information regarding source management programs, see Source Management.

Cut, Copy, Delete, Rename

Cuts, copies, deletes, or renames the synonym.

Properties

Opens a Properties dialog box of the selected synonym.