IBM MQ Connector > Mappings and mapping tasks with IBM MQ Connector > IBM MQ targets in mappings
  

IBM MQ targets in mappings

To write data to an IBM MQ database, configure an IBM MQ object as the target in a mapping.
Specify the name and description of the IBM MQ target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for an IBM MQ target:
Property
Description
Connection
Name of the target connection.
You can select an existing connection, create a new connection, or define parameter values for the target connection property.
To overwrite the target connection properties at runtime, select the Allow parameter to be overridden at run time option.
Target Type
Type of the IBM MQ target object.
Select one the following target types:
  • - Single Object
  • - Parameter
Default is Single Object.
Object
Name of the IBM MQ target object.
Specify the target object that you want to create. You can also select an existing object from the list.
If you enable the Skip Metadata Fetch property in the IBM MQ connection, only a placeholder object appears as an IBM MQ target object in the list, and you need to enter the queue name in the advanced target properties.
Parameter
A placeholder to dynamically assign values at run time for the target object without the requirement to edit the task.
Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object.
The Parameter property appears only if you select parameter as the target type.
If you want to overwrite the target object at runtime, select the Allow parameter to be overridden at run time option. When the task runs, the agent uses the parameters from the file that you specify in the advanced session properties.
Operation
Type of the target operation.
You can perform only the insert operation on an IBM MQ target.
The following table describes the advanced target properties that you can configure for an IBM MQ target:
Property
Description
Queue Name
The queue name in the Queue Manager in IBM MQ where you want to write messages.
If you enable the Skip Metadata Fetch property in the IBM MQ connection, you need to enter the queue name.
Note: When you specify a queue name in both the Object and Queue Name fields, the queue name specified in the Queue Name field takes precedence.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the mapping task forwards rejected rows to the next transformation.
If you enable the option, the Secure Agent flags the rows for reject and writes them to the reject file.
If you don’t enable the option, the Secure Agent drops the rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.