WhereScape is pleased to announce that WhereScape that WhereScape RED 10.34.0.0 is now available.

This release of RED is compatible with WhereScape 3D 9.0 versions and up.

...

Log into the WhereScape Support Portal to access downloads.

Access the User Guide here.

New Features and Improvements 

WhereScape presents RED 10.3 4 a new version of RED with new features that ease RED 10 migrations and continue to enhance scheduling capabilities. The features implemented in this version are mainly focused on enabling RED 10 migration pathways for traditional RED customers on SQL Server, Oracle and Teradata inbuilt targets.

Target License Improvements

RED 10 now accepts existing Oracle and Teradata licenses for use on RED 10 PostgreSQL metadata.

Additionally, RED target licenses for SQL, Oracle and Teradata now allow those traditional target types and their accompanying options in RED without the need to use a Custom target license. Unlike these targets in RED 9 and below, these target types will employ a completely template and configuration driven automation approach and will require an accompanying Target Enablement Pack just as existing targets on RED 10 do.

Note: Enablement packs to support these traditional RED target types in RED 10 will soon follow. 

Other Improvements

This release also includes over 20 customer improvements and fixes, please refer to the Detailed Changes section for the full list, but here are a few of note:

Scheduler

The RED metadata connection resilience of the WhereScape Job Plugin for Azkaban has been improved, allowing automatic recovery from intermittent connectivity issues. This feature ensures jobs are resumed as required and the RED job metadata is kept up to date with the Azkaban job run status. 

The Azkaban Web Server's connection to the RED metadata has also undergone connection resilience improvements allowing recovery from intermittent RED metadata connectivity issues.

Application Deployment

Simplified application deployment DML and DDL logging. The feature of logging DML and DDL to a file during deployment was conditional on another setting that disabled deployment changes on the target warehouse, now the logging will be generated regardless of other settings.

Deployment of Custom Object Sub-Types from 3D to RED requires the equivalent Object Sub-Types to exist in RED for successful deployment and code generation automation, the error messaging has been improved to list all Object Sub-Types which do not have a match in RED so that the synchronization between the configurations can more easily be resolved by the user. 

Advanced Connect

3rd party integrations with external tools like GIT, but also enhances the UI  and enables the ability to add scripted workflows based on the current context in the RED UI. 

Workflow Scripts

Workflow scripts, when defined, will appear in the context menu throughout the RED UI.  When clicking on them in any context menu, the underlying script will be executed and provided with the complete object list contained by the context. This allows for integration scripts to be written that can perform actions on lists of objects, such as: creating deployment applications, checking items in and out of GIT, running external tests on the objects selected, exporting data to catalog tools, backing up scripts to disk and more!

The following changes have been made to support this new feature:

• A new Host Script Language category has been added for Workflow scripts:

Image Added

• Host Script Objects assigned to a Workflow script type will appear in most context menus in RED and when selected will execute the script and provide a file containing the objects contained by the context:

Image Added

Image Added

• Host Script Languages can now have specific icons assigned (via Host Script Language maintenance):

Image Added

Improvements for 3rd Party Integrations

• CheckIn/CheckOut feature will now trigger execution of a script, if present, to support GIT integrations. Add script names of wsl_workflow_checkin and wsl_workflow_checkout to enable this feature.
• Added new endpoints to the RED metadata service, objectsExportByName and jobsExportByName, that export metadata in a GIT friendly format.
• Deployment Application Creation via command line now accepts a specific set of objects to deploy based on the JSON structure that RED Workflow scripts produce.
• RedCli commands on script, procedure and templates now support an 'export-all' option, useful for GIT integrations. Additionally single export allows specifying a directory for auto creation of the filename and extension for the object.
• Added Scheduler API environment variables to all script executions to support actions like releasing another job via scripts.

3D Integration - New Merge Settings for Source Mappings

When deploying Objects with multiple Source Mappings via 3D Export to RED you can now control the merge behavior when updating existing Objects Source Mapping Sets. There is now a new option with three settings when deploying from 3D to RED.

Option: ‘Existing Source Mapping Sets will be’

• Replaced: [Default] Replaces the entire Source Mapping Set (Source Mappings can be removed in this mode)
• Merged using Application: Merges the Sets, resolving conflicts by deploying Source Mappings from this Application - Add and Update.
• Merged using Repository: Merges the Sets, resolving conflicts by retaining Source Mappings in the Repository - Add only.

This feature will be particularly useful to organizations with multiple development teams or projects affecting the same objects in RED, allowing them to deploy only the new Source Mappings that they have added and avoid deploying out-of-date changes to existing Source Mappings.

Other Improvements and Fixes

In addition to the major improvements above please see the following Detailed Changes section for the full list of customer fixes and improvements in this releaseImproved save workflow for RED Profiles so that passwords are not lost inadvertently when forgetting to tick the save passwords checkbox. Also f ixed an issue where the last logged in profile was not remembered at the RED Login Screen.

Detailed Changes in RED 10.

...

4.0.0

The following changes have been implemented since 10.23.0.01

Improvements

• RED-11870 Existing RED Oracle and Teradata licenses are now accepted in RED 10 and Target Types SQL, Oracle and Teradata have been enabled.
• RED-11800 Added multi-select capability to the tree view controls in 'Project Object Maintenance' and 'Job Tasks Definitions' screen.
• RED-11927 Improved RED metadata connection resilience of the WhereScape Job Plugin for Azkaban.
• RED-11893 Improved connection resilience between Azkaban Web Server and the RED Metadata.
• RED-11072 Simplified deployment setting 'Log Metadata DML and Data Warehouse DDL to a File' to always be honored regardless of other settings.
• RED-11965 When saving an Advanced Connect Profile, 'Include Session Passwords' is now selected by default.
• RED-11966 Last Profile is now remembered at the RED login screen.
• RED-11854 Updated 3rd party libraries in Azkaban components.
• RED-11002 Added a new User Preference to allow override of Template operation timeout.
• RED-11881 Improved 3D to RED deployment failure messages when deploying new Object Subtypes which don't match to RED parent types.

Fixes

...

Fixes

...

Anchor
upgradeMessages upgradeMessages

Important Messages When Upgrading