...

This feature is enabled through the following new functionalities of RED for ODBC/Database and Extensible Source Connections:

New

...

Advanced Connect Parameters on Connections

Two new groups under Advanced Connect Parameters have been added to Connections, all of these session-level fields are in-memory only and can be persisted to your RED Profile between sessions.

Image Added

Auth Configuration

• Auth Configuration JSON - Arbitrary JSON storage of any required authentication attributes for this connection. 
• Auth Script Command - When specified this command will be triggered during RED's authentication process to this connection.
• Auth Expires After - Duration in mins after which RED will reconnect at the next opportunity.

Auth Tokens

• Token (1,2,3) - Three new encrypted fields which can be used in connection strings using the token format $AUTHTKN_[1|2|3]$ for expansion at runtime. Display names can be adjusted via the RED Profile to suit a particular authentication type.

...

Scripted Authentication

Scripted Authentication can be enabled for a connection by providing a command line to run in the 'Auth Script Command' field. This command will be triggered by RED when it needs to authenticate with this connection for the first time and then again whenever the 'Auth Expires After' minutes has been exceeded.

...

1. RED UI
   1. Save the current RED Profile to disk and provide access to this Profile file and the connection name requiring authentication via environment variables.
   2. Run the 'Auth Script Command'
2. Authentication Script
   1. Reads the RED Profile and retrieves any required Connection details from it.
   2. Perform the required authentication workflow for the connection.
   3. Updates the RED Profile on disk with refreshed Auth Tokens and other Auth Configuration values as required. 
3. RED UI
   1. Merges the updated RED Profile file back into memory.
   2. Completes the authentication process for the connection.
   3. Resets the internal expiry for the connection based on 'Auth Expires After' mins. 

Authentication Environment Variables for All Scripts

The Extensible Authentication feature also enables the following new environment variables in RED Scripts, both via Azkaban and RED UI:

• WSL_[META|SRC|TGT]_AUTHCFG - contains the complete JSON structure in the 'Auth Configuration JSON' field.
• WSL_[META|SRC|TGT]_AUTHTKN_[1|2|3] - Sets of three decrypted Token values from the 'Auth Tokens' fields.

The RED Scheduler Profile table has been updated to incorporate these new fields in order to provide these values to Azkaban jobs, these can be maintained via the Scheduler Profile Maintenance script. Scripted Authentication is not supported for Azkaban in this version. 

Other Improvements

Performance Improvements

• This release adds new indexes to the RED Metadata to enhance metadata query performance throughout the product.
• Improved the performance of opening object properties on large repositories.

Scheduler Improvements

• Improved publishing of Jobs via Application deployment

Detailed Changes in RED 10.6.0.0

...

...