Versions Compared

Old Version 5

changes.mady.by.user eric revollo

Saved on

compared with

New Version 6

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Auth Configuration

OptionsDescription
Auth Configuration JSONAdditional attributes in JSON format, these are stored in the RED profile.  
Auth Script CommandCommand to facilitate authentication workflows, this script modifies the profile file and then reloads it. 
Auth Expires AfterExpiration time in minutes, after the time runs out, RED reauthenticates 

Auth Tokens

OptionsDescription
Token 1Encrypted field available as WSL_[META|SRC|TGT]_AUTHTKN_1 environment variable, its display name 'Token 1' can be changed on the profile file
Token 2Encrypted field available as WSL_[META|SRC|TGT]_AUTHTKN_2 environment variable, its display name 'Token 2' can be changed on the profile file
Token 3Encrypted 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.

Note

The available options in this drop-down list are configured from Home > Options > Available Load Types.


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.

...