Defining the Message Type in Data Sources

You can select the message type that specifies the format of the data within the message in ActiveMQ, Google Cloud PubSub, MQTT, RabbitMQ, Solace, and WebSocket connectors.

1. Select the Message Type:

   

   • FIX

     

   • JSON

     If JSON is selected, enter the Record Path which allows the identification of multiple records within the JSON document (e.g., myroot.items.item) and select the Array Handling setting.

     

   • SVG

     

     NOTE: This parser is not available on the MQTT connector.

   • Text

     If Text has been selected, confirm the Decimal Separator, Text Qualifier, Column Delimiter, and if the first row of the message includes column headings.

     

   • XML

     

2. Define or set the columns that represent the sections of the message.

   Property	Description
   Name	The column name of the source schema.
   Fix Tag/JsonPath/Text Column Index/XPath	The Fix Tag/JsonPath/Text Column Index/XPath of the source schema.
   Type	The data type of the column. Can be a Text, Numeric, or Time
   Date Format	The format when the data type is Time.
   Enabled	Determines whether the message field should be processed.

    

   NOTE: To parse and format times with higher than millisecond precision, the format string needs to end with a period followed by sequence of uppercase S. There can be no additional characters following them. For example: yyyy-MM-dd HH:mm:ss.SSSSSS.

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support