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

IBM MQ sources in mappings

To read data from IBM MQ, configure an IBM MQ object as the Source transformation in a mapping. Enable partitioning when you configure the Source transformation in the Mapping Designer to optimize the performance of the mapping task.
Specify the name and description of the IBM MQ source. Configure the source and advanced properties for the source object.
The following table describes the source properties that you can configure for an IBM MQ source:
Property
Description
Connection
Name of the source connection.
You can select an existing connection, create a new connection, or define parameter values for the source connection property.
If you want to overwrite the source connection properties at runtime, select the Allow parameter to be overridden at run time option.
Specify the parameter file directory and name in the advanced session properties.
Source Type
Type of the source object.
Select one of the following source types:
  • - Single Object
  • - Parameter
Default is Single Object.
Parameter
A placeholder to dynamically assign values at run time for the source object without the requirement to edit the task.
Select an existing parameter for the source object or click New Parameter to define a new parameter for the source object.
The Parameter property appears only if you select parameter as the source type.
If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option.
Object
Name of the IBM MQ source object.
Specify the source object that you want to use. 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 queue name appears as an IBM MQ source object in the list, and you need to enter the queue name in the advanced source properties.
Filter
Not applicable.
Sort
Not applicable.
The following table describes the advanced source properties that you can configure for an IBM MQ source:
Property
Description
Destructive Read
Determines whether Data Integration permanently deletes messages from the IBM MQ source after it reads the messages:
  • - If you enable the option, Data Integration deletes the messages from the source after reading them and saves a copy of the messages to a cache folder. The Recovery Cache Folder property specifies the folder in which Data Integration saves the messages.
  • - If you don’t enable the option, Data Integration permanently deletes messages from the source after it reads them.
Default is disabled.
Real Time
Determines whether Data Integration reads the messages from the message data component of IBM MQ in real time:
  • - If you enable the option, Data Integration reads messages continuously from the message data component and does not terminate the mapping.
  • - If you don’t enable the option, Data Integration reads messages in batches and terminates the mapping after processing all messages.
Default is disabled.
To read messages in real time, select Source as the commit type and set a commit interval in the Advanced Session Properties section in the mapping task.
Recovery Cache Folder
The directory of the cache folder where the recovery files are created when the mapping runs with the Destructive Read option enabled.
The recovery file stores messages that Data Integration deletes from the IBM MQ source.
Specify the directory of the recovery cache folder in the following format:
/root/<folder name>/
Queue Name
The queue name in the Queue Manager in IBM MQ from where you want to read 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.
Tracing Level
Determines the amount of detail that appears in the log file.
Select one of the following options:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose Data
Default is Normal.

Fixed partitioning

You can configure fixed partitioning to optimize the performance of mapping tasks when you read data from IBM MQ sources.
When you run a mapping task enabled for fixed partitioning, the Secure Agent distributes the source data across the partitions to read data in parallel based on the number of partitions that you specify in the Source transformation.
To configure fixed partitioning, on the Partitions tab, select fixed partitioning and enter the number of partitions based on the amount of data that you want to read. By default, the value is one. The maximum number of partitions you specify must not exceed 25.
The following image shows the configured fixed partitioning:
The configured fixed partitioning for the IBM MQ source in the Source transformation