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

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

...

Go to https://www1.wherescape.com to see available product versions and release notes for older versions.

Log into the WhereScape Support Portal to access downloads.

Access the User Guide here.

WhereScape RED 10.3.0.1 Release Update

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

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

Go to Go to  https://www1.wherescape.com to see available product versions and release notes for older versions.

Log into the WhereScape Support Portal to access downloads.

Access the User Guide here.

New Features and Improvements Improvements 

WhereScape presents RED 10.2 3 a new version of RED with new capabilities and features to enhance the user experience. This version includes Advanced Authentication Methods.

Advanced Authentication Methods

The Advanced Connect feature provides a new way to manage connection security and modify ODBC connection attributes in RED enabling a wide variety of authentication mechanisms for your metadata, source, and target connections. This feature combines session-based authentication, complete control over ODBC connection strings, and secure encrypted storage of passwords.

This feature is designed with security in mind and adds even more ways for enterprises to secure their metadata, sources, and targets for a wide variety of authentication methods such as OAuth, Azure Active Directory, and multifactor authentication (depending on vendor driver capabilities). Please see the product documentation for more details.

Advanced Connect is always enabled in RED 10.2 and therefore a connection string must be defined for every ODBC, Database and applicable Extensible Source Connections in RED. The connection string will always be used when establishing ODBC connections from this release onwards. RED provides suitable default connection strings when not provided by the user. 

...

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

Improved 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.3.0.0

The following changes have been implemented since 10.2.0.0

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

• RED-11844 Resolved errors when copying or moving projects with nested object tree view enabled.
• RED-11806 Fixed "Cannot retrieve default template" error after reverting a target connection from a version.
• RED-11852 When creating new tables, with nested object tree view enabled, the new table is now correctly positioned in the object tree.
• RED-11650 Fixed truncated dialog label in Scheduler Refresh Settings.
• RED-11771 Fixed a deployment issue from 3D affecting tables with multiple surrogate key joins, where only the first column's join metadata was populating.
• RED-11929 Resolved an issue where RED could crash when Data Vault Hash Key column name length exceeded 64 chars.
• RED-11969 Fixed issue where the metadata port was not added as an environment variable for scripts.
• RED-11562 Fixed an issue where Documentation Generation could lead to application crash in some cases when using remote desktop software.
• RED-11988 Fixed issue with 3D integration with RedDeploy not honoring the Profile selected.
• RED-11941 RedCli Connection Add/Modify now ignores credentials args to avoid them being entered into the metadata.
• RED-11984 Fixed issue where a trailing semicolon was incorrectly added to procedures compiled through RED UI for Custom targets.

Detailed Changes in RED 10.3.0.1

Image Removed

RED Connection Properties Screen showing the new Advanced Connect Parameters:

Image Removed

Stand-alone Script Improvements

Stand-alone scripts can now be associated with Database/ODBC and Extensible Source Connections providing access to the associated connection settings and Credentials in your scripts.

This feature is particularly useful for “High Water Mark” scripts that require access to target connection properties. When combined with Advanced Connect this provides a secure way to run scripts directly against source and target connections in RED. Previously you could only associate Windows or Linux connections to scripts.

Online Documentation

The WhereScape product family is moving towards online product documentation which allows us to keep the documentation more up to date outside of traditional release cycles and continue to make improvements that enable our customers to use our products to their full potential. 

From this release onwards when using the in-product help you will be redirected to our documentation website hosted on https://wiki.idera.com/category/ws. Contextual product help buttons are not yet linked to the relevant pages and instead take you to the landing page, contextual based help links will follow soon. 

For offline documentation requirements you will still be able to download the full user guide PDF's. 

Customer Improvements

This release also includes the customer enhancements and support fixes listed in the Detailed Changes section.

...

The following changes have been implemented since 10.13.0.20

...

Fixes

• RED-11900 Updated the WslMetadataServiceClient.dll to work with the connection string arg. Updated the scheduler integration script to use the metadata connection string. 
• RED-11895 RED Help (User and Installation Guide) is no longer installed with the product and now links to the online documentation at http://wiki.idera.com/category/ws
• RED-11829 Azkaban core components and RED Azkaban plugin updated for Advanced Connect feature.
• RED-11821 Improvements to the Windows Azkaban Scheduler installer to support Advanced Connect with DPAPI encryption. 
• RED-11816 Added an encryption utility
• RED-11813 Moved the RED Scheduler Configuration credentials to the RED Profile.
• RED-11752 Stand-alone scripts can now be associated with Database and Extensible Source Connections providing access to target settings and credentials
RED-11745 Added Advanced Connect feature to RED 10 and forced its usage, this has potentially breaking changes, please refer to the important upgrade messages.
• 12010 Resolved an issue generating update routines during deployment from 3D of data vault tables with columns > 64 chars.
• RED-12009 Fixed issue with deploying data vault tables from 3D with column names greater than 64 chars, now the full 256 chars limit for column names will work.
• RED-12008 Improved the performance of starting up RED on large repositories with many Groups and Projects.
• RED-12007 Storage Settings on Named Targets are now exposed to the template engine for DDL code generation.
• RED-12000 Fixed Teradata Target creation issue in RED Setup Wizard.
• RED-12017 Loads on Named targets sourced from Windows/Linux connection now allow template driven code generation for all load types.

Anchor
upgradeMessages upgradeMessages

Important Messages When Upgrading