-k option

This option supplies the signon information needed to establish one or more database connections during batch processing.

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 Transformer .xml file. Multiple IQD data sources can use the same signon object.

Tip: You can view these signons on the Transformer (Windows) interface, but you cannot change them.

The basic 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 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.