Page History
...
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 User and Installation Guides for more details.
Advanced Connect is always enabled by default 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 a ODBC connections from this release onwards, . RED will provide provides suitable default connection strings when not provided by the user.
Here is the
In conjunction with Advanced Connect, RED Profiles are used to store encrypted user specific credentials outside the metadata, for the RED UI these profiles are stored on disk using Windows DPAPI encryption, for the Azkaban Scheduler the profile is stored within a new metadata table in the 'redadmin' schema and encrypted with a new encryption utility provided in this release.
RED Login Screen showing the new fields 'Profile' and 'Connection String':
...
RED Connection Properties Screen showing the new Advanced Connect Parameters:
...
Stand-alone Script Improvements
...