Versions Compared

Key

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

...

Code Block
languagejson
titleProfile JSON
collapsetrue
{
  "connections": [
    {
      "connectionNameredServerPort": "Tutorial (OLTP)5432",
      "connectionStringredUserId": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;database=WslTutorial_DataSeq;postgres",
      "passwordauthTokens": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK9Z1yRvrzEOIvwCfKZ96UAAAAAACAAAAAAAQZgAA",
{
        "userIdtoken_2": "red1"{
    },
    {
      "connectionNamevalue": "SQL_Target",
            "connectionStringdisplayName": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;database=sql15_9010_pg;",
       "password": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK9Z1yRvrzEOIvwCfKZ96UAAAAAACAAAAAAAQZgAA" },
        "userIdtoken_3": "red1"{
    },
    {
      "connectionNamevalue": "PostgreSQL_TargetAQAAANCMnd8BFdERjHoAwE",
            "connectionStringdisplayName": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;database=pg15_9010;",
       "password": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK9Z1yRvrzEOIvwCfKZ96UAAAAAACAAAAAAAQZgAA" },
       "userId": "redusertoken_user1": {
    },
    {
      "connectionNamevalue": "WslTutorial_DataSeqAQAAANCMnd8BFdERjHoAwE",
      "connectionString": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;",
      "passworddisplayName": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK9Z1yRvrzEOIvwCfKZ96UAAAAAACAAAAAAAQZgAAuser",
       "userId": "red1" }
    },
  ],
  "redConnectionMethodredDsnArchitecture": "Advanced Connect64",
    "redConnectionStringauthConfig": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;database=sql15_9010_pg;",
{
        "redDatabaseauthExpiresAfterMins": "sql15_9010_pg"20,
     "redDsn": "sql15",
  "redServerauthScriptCommand": "",
  "redServerPort": "",
  "redUserIdpowershell -executionpolicy bypass -f \"C:\\temp\\RED\\ws_auth\\ws_auth.ps1\""
    },
    "redUserPwd": "red1AQAAANCMnd8BFdERjHoAwE",
    "authConfigredDsn": {"repo",
    "authScriptCommandredConnectionString": "powershell -executionpolicy bypass -f authscript.ps1dsn=$AUTHTKN_3$;uid=$AUTHTKN_1$;pwd=$PASSWORD$;",
    "authExpiresAfterMinsschedulerDashboardUser": 60"wsdashboarduser",
    "authUrlredServer": "https://test.comlocalhost",
    "customPropertyschedulerApiUser": "wsapiuser",
    "accessTokenExpiryTimeschedulerDashboardPwd": "2025-07-03T10:51:00AQAAANCMnd8BFdERjHoAwE",
    "refreshTokenExpiryTimeconnections": "2025-07-03T10:51:00"
  },
  "redDsnArchitecture": "64",
  "authTokens": {
    "token_1": {
      "value": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAaXbH2rKfq0qz2x8mcZDgoAAAAAACAAAAAAAQZg",
 [{
            "connectionName": "Database Source System",
            "connectionString": "dsn=$DSN$;",
            "password": "AQAAANCMnd8BFdERjHoAwE",
            "userId": "",
            "dsn": "",
            "authConfig": {
                "authExpiresAfterMins": 0,
                "authScriptCommand": ""
            },
            "authTokens": {}
        }, {
            "connectionName": "Snowfalke MFA",
            "connectionString": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$$AUTHTKN_1$;passcodeInPassword=on;",
            "password": "AQAAANCMnd8BFdERjHoAwE",
            "userId": "snowfalke_user",
            "dsn": "",
            "authConfig": {
                "authExpiresAfterMins": 240,
                "authScriptCommand": "powershell -executionpolicy bypass -f \"C:\\temp\\RED\\ws_auth\\ws_auth.ps1\""
            },
            "authTokens": {
                "token_2": {
                    "value": "",
                    "displayName": ""
                },
                "token_3": {
                    "value": "",
                    "displayName": ""
                },
                "token_1": {
                    "value": "AQAAANCMnd8BFdERjHoAwE",
                    "displayName": "MFA TOTP"
                }
            }
        }, {
            "connectionName": "WslTutorial_DataSeq",
            "connectionString": "dsn=$AUTHTKN_3$;uid=$AUTHTKN_1$;pwd=$AUTHTKN_2$;",
            "password": "AQAAANCMnd8BFdERjHoAwE",
            "userId": "",
            "dsn": "",
            "authConfig": {
                "authExpiresAfterMins": 0,
                "authScriptCommand": ""
            },
            "authTokens": {}
        }, {
            "connectionName": "Data Warehouse SQL",
            "connectionString": "dsn=$DSN$;uid=$USER$;pwd=$PASSWORD$;",
            "password": "AQAAANCMnd8BFdERjHoAwE",
            "userId": "red1",
            "dsn": "",
            "authConfig": {
                "authExpiresAfterMins": 0,
                "authScriptCommand": ""
            },
            "authTokens": {
                "token_2": {
                    "value": "",
                    "displayName": ""
                },
                "token_3": {
                    "value": "",
                    "displayName": ""
                },
                "token_1": {
                    "value": "",
                    "displayName": "Access Token"
    },
    "token_2": {
      "value": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAaXbH2rKfq0qz2x8mcZDgoAAAAAACAAAAAAAQZg", }
      "displayName": "Refresh Token"
    },
       "token_3": {
   }
    ],
    "valueredConnectionMethod": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAaXbH2rKfq0qz2x8mcZDgoAAAAAACAAAAAAAQZgAdvanced Connect",
      "displayNameschedulerApiPwd": "JWT"
    }
  }, 
AQAAANCMnd8BFdERjHoAwE",
    "redUserPwdredDatabase": "AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK9Z1yRvrzEOIvwCfKZ96UAAAAAACAAAAAAAQZgAArepo"
}

Using Profiles

The following Environment Variables are created at run-time for Scripts associated to ODBC, Database and Extensible Source Connections:
Where User, Password and Connection Strings are set from the current RED session credentials in the in-memory Profile.
WSL_<META|TGT|SRC>_CONSTRING contains the complete connection string with tokens $DSN$, $USER$, $PASSWORD$ and $AUTHTKN_<1|2|3>$ replaced.
 

Metadata

Target

Source

WSL_META_DSN

WSL_TGT_DSN

WSL_SRC_DSN

WSL_META_DSN_ARCH

WSL_TGT_DSN_ARCH

WSL_SRC_DSN_ARCH

WSL_META_SERVER

WSL_TGT_SERVER

WSL_SRC_SERVER

WSL_META_DBID

WSL_TGT_DBID

WSL_SRC_DBID

WSL_META_USER

WSL_TGT_USER

WSL_SRC_USER

WSL_META_PWD

WSL_TGT_PWD

WSL_SRC_PWD

WSL_META_CONSTRING

WSL_TGT_CONSTRING

WSL_SRC_CONSTRING

WSL_META_AUTHCFG

WSL_SRC_AUTHCFG

WSL_SRC_AUTHCFG

WSL_META_AUTHTKN_[1|2|3]

WSL_TGT_AUTHTKN_[1|2|3]

WSL_SRC_AUTHTKN_[1|2|3]

...