Page History
...
Options | Description |
|---|---|
Session User ID | Session User ID used for Advanced Connect. |
Session Password | Session Password used for Advanced Connect. |
Connection String | Used when establishing a connection, accepts automatic replacements of RED Tokens. |
Auth Configuration
| Options | Description |
|---|---|
| Auth Configuration JSON | Additional attributes in JSON format, these are stored in the RED profile. |
| Auth Script Command | Command to facilitate authentication workflows, this script modifies the profile file and then reloads it. |
| Auth Expires After | Expiration time in minutes, after the time runs out, RED reauthenticates |
Auth Tokens
| Options | Description |
|---|---|
| Token 1 | Encrypted field available as WSL_[META|SRC|TGT]_AUTHTKN_1 environment variable, its display name 'Token 1' can be changed on the profile file |
| Token 2 | Encrypted field available as WSL_[META|SRC|TGT]_AUTHTKN_2 environment variable, its display name 'Token 2' can be changed on the profile file |
| Token 3 | Encrypted field available as WSL_[META|SRC|TGT]_AUTHTKN_3 environment variable, its display name 'Token 3' can be changed on the profile file |
Other
Options | Description | ||
|---|---|---|---|
Default Schema for Browsing | Optional comma-delimited list of schemas for the browser pane filter. Enter the schema(s) you want the connection to browse by default on the right browser pane. | ||
New Table Default Load Type | The default Load Type for new Load tables is created using this connection as a source. Select the desired default load type from the list, e.g. Database Link Load, Script-based load, Integration Services Load or Externally Loaded.
| ||
New Table Default Load Script Connection | The default Script Connection to used when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
New Table Default Load Script Template | The default Script Template to use when a Script-based load type is defined for a Load table object that is sourced from this connection. | ||
SSIS Connection String (OLEDB) | The connection string that is used by Microsoft SQL Server Integration Services (SSIS) to connect to the data source using the OLE DB connection manager. | ||
Data Type Mapping Set | Mapping Set to use when converting from a source database data type to a destination database data type. Setting this field to (Default) makes RED automatically select the relevant mapping set, otherwise, you can choose one of the standard mapping sets from the drop-down list or create a new set. | ||
Default Transform Function Set | Function Set that is selected by default in the Transformation dialogs. |
...