Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user eric revollo

Saved on

Key

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

...

Environment variableDescription
WSL_LOAD_FULLNAMEThe fully-qualified load table name.
WSL_LOAD_TABLEThe unqualified load table name.
WSL_LOAD_SCHEMAThe schema for the load table.  
WSL_LOAD_DBThe name of the database for the load table.
WSL_TEMP_DB
  • PDW: The name of the staging database for the load. Others: Not Used.
WSL_TGT_AUTHCFGAdditional user defined attributes as JSON, scripts can load attributes from this variable.
WSL_TGT_AUTHTKN_1

Encrypted field “Token 1” can be replaced in connection strings by specifying the token: $AUTHTKN_1$. It is intended to contain tokens, passwords or secrets related to authentication.

DSNThe ODBC data source name (DSN) for the load table's storage connection.

WSL_TGT_SERVERAUTHTKN_2

Encrypted field “Token 2” can be replaced in connection strings by specifying the token: $AUTHTKN_2$. It is intended to contain tokens, passwords or secrets related to authentication

The server for the load table's storage connection

.

WSL_TGT_AUTHTKN_DBPORT3

Encrypted field “Token 3” can be replaced in connection strings by specifying the token: $AUTHTKN_3$. It is intended to contain tokens, passwords or secrets related to authentication

The database port for the load table's storage connection

.

WSL_TGT_DBIDThe Database ID property of the load table's storage connection.
WSL_TGT_USERThe user id for the load table's storage connection.
WSL_TGT_PWDThe password for the load table's storage connection.

...

Environment variableDescription
WSL_SRC_AUTHCFGAdditional user defined attributes as JSON, scripts can load attributes from this variable.
WSL_SRC_DSNThe ODBC data source name (DSN) for the source connection.
WSL_SRC_SERVERThe server for the source connection.
WSL_SRC_DBPORTThe database port for the source connection.
WSL_SRC_DBIDThe Database ID property of the source connection.
WSL_SRC_DBThe name of the database for the source connection.
WSL_SRC_AUTHTKN_1

Encrypted field “Token 1” can be replaced in connection strings by specifying the token: $AUTHTKN_1$. It is intended to contain tokens, passwords or secrets related to authentication.

WSL_SRC_AUTHTKN_2

Encrypted field “Token 2” can be replaced in connection strings by specifying the token: $AUTHTKN_2$. It is intended to contain tokens, passwords or secrets related to authentication.

WSL_SRC_AUTHTKN_3

Encrypted field “Token 3” can be replaced in connection strings by specifying the token: $AUTHTKN_3$. It is intended to contain tokens, passwords or secrets related to authentication.

WSL_SRC_SCHEMA

The Source Schema property of the load.

Note

The property is fetched without modification, so there may or may not be a trailing dot depending on how it is configured.
However, it is better not to assume the trailing dot is or isn't appended by using the variable like this, when it is not empty:

OSIf no trailing dot is wantedIf a trailing dot is wanted
Windows !WSL_SRC_SCHEMA:.=! !WSL_SRC_SCHEMA:.=!.
UNIX/ Linux ${SRC_SCHEMA%.} ${SRC_SCHEMA%.}.


WSL_SRC_USERThe user id for the source connection.
WSL_SRC_PWDThe password for the source connection.

...

Environment variableDescription
WSL_META_AUTHCFGAdditional user defined attributes as JSON, scripts can load attributes from this variable.
WSL_META_AUTHTKN_1

Encrypted field “Token 1” can be replaced in connection strings by specifying the token: $AUTHTKN_1$. It is intended to contain tokens, passwords or secrets related to authentication.

WSL_META_AUTHTKN_2

Encrypted field “Token 2” can be replaced in connection strings by specifying the token: $AUTHTKN_2$. It is intended to contain tokens, passwords or secrets related to authentication.

DSNThe ODBC data source name (DSN) for the meta-repository connection.

WSL_META_SERVERAUTHTKN_3

Encrypted field “Token 3” can be replaced in connection strings by specifying the token: $AUTHTKN_3$. It is intended to contain tokens, passwords or secrets related to authentication

The server for the meta-repository connection

.

WSL_META_DBIDThe Database ID property of the meta-repository connection.
WSL_META_DBThe name of the database for the meta-repository connection.
WSL_META_SCHEMAThe meta-repository schema name, with a trailing dot.


 
WSL_META_USERThe user id for the meta-repository connection.
WSL_META_PWDThe password for the meta-repository connection.
WSL_WORKDIR
  • Windows: The work directory defined in the Windows connection.
  • UNIX/Linux: The work directory defined in the UNIX/Linux or Hadoop connection.
WSL_SEQUENCEA unique sequence number for the load or export task.
WSL_PARAMnnnAny parameters that start with the load table or export object name. Example: A table called load_abc has a parameter called load_abc_server defined. In this case, a variable called WSL_PARAM_SERVER (Windows) or PARAM_SERVER (UNIX/Linux) will be created.
WSL_SCH_RESTAPI_URLThe server URL for the scheduler connection.
WSL_SCH_RESTAPI_USERThe api user id for the scheduler connection.
WSL_SCH_RESTAPI_PWDThe password for the scheduler connection
WSL_JOB_KEYID of the Job which started the script, '0' for interactive execution.
WSL_JOB_NAMEName of the Job which started the script, 'Develop' for interactive execution.
WSL_TASK_KEYID for the Task within the Job, or Object ID for interactive execution.
WSL_TASK_NAMEName of the Task within the Job, or Object Name for interactive execution.

...