-k option

It provides an alternative to storing the information in the Signons list or retrieving user IDs and passwords from the configured authentication source. This is especially useful when used with .mdl files which, by default, do not use verb MDL and so do not store signon passwords.

For databases referenced in an Impromptu Query Definition (IQD) file, the signon is the logical database name that appears in the related gateway.ini file. Multiple IQD data sources can use the same signon object.

The syntax for using the -k option is as follows:

cogtr -ksignon=
userid/password -p
filename.py?|-mfilename.mdl

No spaces may appear between -k and its argument, and the signon name cannot be empty. Also, the signon name cannot contain the ASCII equals (=) character, and the user ID cannot contain a forward slash (/), because both characters are reserved for the parameter syntax.

The following Windows example opens the Field3.mdl file and grants access to the required database using the signon named field, user ID CarlosR, and password pw462. Assuming that the signon matches that defined in the model, the process runs in batch mode, creating the cubes as defined in the model.

cogtr -n -kfield=CarlosR/pw462 Field3.mdl

The following UNIX example reads the data source for model Xyzsales.mdl from an Oracle database using an IQD file, confirms the security information, and processes the model in batch mode. The signon sal_log includes the Oracle user ID corpadm and the password my_pass. The command to process the .mdl file for model Xyzsales.mdl is as follows:

cogtr -c -s -mXyzsales.mdl -ksal_log=corpadm/my_pass

When you use this command, the user ID and password appear in plain text. For information about how to avoid plain text passwords, see the topic Avoiding Plain Text Passwords When Using the -k or -l Option.