x

The Data Management Console normally connects to the server for each request, for example, when running a flow or stored procedure. When the task completes the connection to the server is severed. This mode of operation is similar to a web browser and helps to keep server resources available to all users.

In previous releases the option Keep Server Connection Alive kept a constant connection to the server for the duration of the DMC session. This tied up the server resources regardless of whether they were being used or not.

However, this functionality allowed for tasks to be completed such as setting a value for a variable, issuing a SET or a FILEDEF command, or establishing a DEFINE FUNCTION.

These tasks can now be accomplished with the Edit my profile option. Add any needed commands to your profile and since the profile is run for every connection to the server, they will be in effect for each session.

Note: Any changes to variables, or other settings, by running stored procedures will be overridden by the profile when connecting to the server for the next task.

x

In the previous release an agent based File Listener configured on the Web Console facilitated real time processing. While this allowed processing files to arrive in a specified directory, only Direct Load flows could be used and they could not be scheduled. The flow also did not complete until the agent was terminated, so the log could not be viewed, nor could an email message be sent after processing.

This facility has been replaced in the current release with a new adapter based file listener capability. All configuration is done in a synonym that describes the source files.

The new File Listener has added capabilities. It supports both Data Flows (SQL based) as well as Direct Load flows and these flows can also be scheduled. The flow completes when a file or time limit is reached, and an email message can be sent on completion.

x

In previous releases a target with an Adapter of Formatted File could have Format of COMT. DataMigrator would create a comma-delimited file with double quotes around all character columns and the column names as the first line of the file. The TABT format used a tab character as a delimiter instead of a comma.

In Release 7.7 support for COMT and TABT files has be superseded with the support for Delimited Flat Files that allow any delimiter to be specified, not just comma and tab. The enclosure character for strings can also be specified as any character. Inclusion of the column names as the first line is now optional.

Any Data Flows created in earlier releases with a target type of COMT and TABT will still run. However, when they are opened in the Data Management Console they will be converted to have a target of Delimited Flat File, with the Header set to yes, Enclosure set to a double quote, and Delimiter set to a comma or tab.

Since previous releases did not permit mapping to a predefined synonym describing a delimited, they allowed adding columns to the target file in the Target Transformations panel. In the current release a synonym that describes a delimited file can be used as a target. Any columns needed in the target file can be included in the target synonym and assigned in the Target Transformations panel.

x

The capability to customize the standard log and statistics reports has been discontinued.

x

The capability to submit flows directly to the deferred execution scheduler has been discontinued.

Instead, use Submit or Submit with options and select "Do not wait for completion" to run at a specific date and time.

x

The Run option has been replaced by Submit, which submits a flow to run on the sever.

Test Run has been replaced by Run on the browser context menu for flows and on the toolbar for flows.

As with Test Run when a flow is Run data is loaded and the output appears in the DMC console log (and not in the ETL Log or an E-Mail message).

However, Run is not subject to the Maximum number of rows for test reports limit found in the Run Options preferences. To limit the number of rows processed, set the limit from the Run with limits dialog box.