WhereScape is pleased to announce that WhereScape RED 10.2.0.0 is now available. Before upgrading, review the Important Messages when Upgrading from Earlier Versions for more information.

To review the Release Notes for older versions visit WhereScape Documentation.

New Features and Improvements 

WhereScape presents RED 9.0 a new version of RED with new capabilities and features to enhance the user experience. This version includes Advanced Authentication Methods, an improved 3D Integration for Source Mapping Objects, and increased DDL Limits. In addition, over 50 customer-requested improvements and fixes are included in this release. 

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.

Advanced Connect is enabled through the properties screen of connections, once enabled a connection string must be defined which will be used when establishing a connection. RED Login Screen showing the new Logon Method:

RED Connection Properties Screen showing the new Connection Method:

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 User and Installation Guides for more details.

This feature is only available for SQL/Azure SQL targets and Enablement Pack target platforms, refer to your specific Enablement Pack platform on the WhereScape downloads page for compatibility.

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.

Stand-alone Script Improvements

Stand-alone Windows 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 a Windows connection to a script.

WhereScape 3D Compatibility

This release of RED is compatible with WhereScape 3D 8.6.9.1 versions and up for 3D exports to RED but it is recommended to use the latest version 9.0.2.1 of 3D to provide all feature capabilities.

Customer Improvements

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

Detailed Changes in RED 10.2.0.0

The following changes have been implemented since 10.1.0.2

 Improvements

• 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.