Purpose
To define a message queue server and the user information for connecting to it.
Format
/MQCONNECTION type server [ALIAS alias] [connection_option] [stream_option] [location_option]
where
| type | = | {APACHEKAFKA} {MAPRSTREAMS} {WEBSPHERE} |
| connection_option | = | [AUTHENTICATION {AUTODETECT|NONE|KERBEROS}] [{USER|REPOSITORY|CYBERARK|AZUREVAULT} username password] |
| stream_option | = | STREAM stream |
| location_option | = | LOCATION location |
Arguments
| type | The type of connection used to establish connectivity with the server. |
| server | The server on which the message queue resides. |
| alias |
An alternate name used to identify the message queue server. You can use this alias to refer to the server from other options. When you do not assign an alias, use the server argument to refer to the connection in other options. When you define an alias for the connection, you should reference the connection only through the alias; you can no longer reference the database name directly in other options. |
| username | The user name used to connect to the server. |
| password |
The password associated with the user name that is used to connect to the server. To use a repository password, specify REPOSITORY, and enter a password variable for the password. Create password variables using the Connect ETL repository manager as described in the Connect help. Note that you must define the password variable on the same system on which, and as the same user by whom, this command application will be run. At runtime, dmexpress will retrieve the password associated with the specified variable from the repository. A repository password can be specified as an environment variable that points to the repository variable. To use passwords stored in CyberArk, specify CYBERARK and enter a password variable for the password. Setup a password variable manually in an execution profile as described in the Connect help. Connect ETL retrieves the password associated with the specified variable from CyberArk. CyberArk also requires a TLS-secured HTTPS connection to deliver passwords, which requires client certificates setup in the Connect ETL Server dialog or repository manager. To use passwords stored in Azure Key Vault, specify AZUREVAULT and enter a password variable for the password. Setup a password variable manually in an execution profile as described in the Connect help. Connect ETL retrieves the password associated with the specified variable from Azure Key Vault. Azure Key Vault also requires a TLS-secured HTTPS connection to deliver passwords, which requires client certificates setup in the Connect ETL Server dialog or repository manager. |
| stream | The stream of the connection (for mapr Streams only). |
| location | The location of the connection; for mapr Streams, this would be the stream. |
Location
The option may appear anywhere in the task definition.
Notes
Use the connection in the /MQINPUT option to identify the message queue that is defined as the source of records.