Ultra Messaging Streams

The Ultra Messaging Streams connector allows connection to the Streaming Edition of Informatica Ultra Messaging products.

You can either select any of the following Configuration Types:

Using Ultra Messaging Streams - Configuration File

  1. When creating a new data table, select Ultra Messaging Streams from the Connect to Data dialog. The Ultra Messaging Connection dialog is displayed.

  2. Select Configuration File in the Configuration Type drop-down list.

  3. Browse to the Configuration File source.

  4. For the Topic section, can either:

    • just enter the Topic name if you are using the Specific Topic type, or

    • enter the Topic pattern if you are using the Perl-compatible Regular Expression (regex) Topic type then check the Wildcard box.

  1. Select any of the following Message Types:

    • Fix

    • XML

    • JSON

    • Text

    The dialog slightly changes to allow specification of the following:

      • Text Qualifier

    This drop-down list box specifies if fields are enclosed by text qualifiers, and if present to ignore any column delimiters within these text qualifiers.

      • Column Delimiter

    This drop-down list box specifies the column delimiter to be used when parsing the text file.

      • First Row Headings

      1. This checkbox determines if the first row should specify the retrieved column heading, and not to be used in data discovery.

  1. Select the Decimal Separator. This specifies the character for decimal separation, when parsing a numeric value. By default this is “.”

  2. Click Add Column.

  3. Enter or select:

    • Name

    • XPath/JsonPath/Fix Tag/Text Column Index (for example, price/@stock)

    • Type (Numeric, Text or Date/Time)

    • Date/Time format when the Data Type is Time

    1. NOTE:

    2. To parse and format times with higher than millisecond precision, the format string needs to end with a period followed by sequence of lower case Fs. There can be no additional characters following them.

    3. For example: yyyy-MM-dd HH:mm:ss.ffffff

    • Enabled (whether the message field should be processed)

    • Filter (Defined parameters that can be used as Filter)

NOTE: The Filter option is only available for JSON, Text, and XML Message types

Fix

JSON

Text

XML

You can also opt to click to delete a column in the list.

  1. Select the ID Column.

  2. You can select any of the following Time ID Columns:

    • No Time ID

Enter the Real-time limits. Default is 1000.

    • Automatic Time ID

Enter the following:

      • Time ID Column Name

      • Time Window (seconds). Default is 0.

  1. The schema of the source file is then defined by clicking the Generate Columns… button.

This populates the list of columns, with the data type found from inspecting the first ‘n’ rows of the file.

  1. Click Add Column… to add more columns and specify their properties.

  2. Click OK. The source data is returned in the Data Prep, with the fields displayed in the Data Source Preview.

 

Using Ultra Messaging Streams - Manual Configuration

  1. When creating a new data table, select Ultra Messaging Streams from the Connect to Data dialog. The Ultra Messaging Connection dialog is displayed.

  2. Select Manual Configuration in the Configuration Type drop-down list.

The dialog changes to display two tabs:

    • Basic Settings

  1. For the Topic Resolution, you can either select:

      • Multicast

        • Enter the IP address for the Multicast Group.

        • Enter the Destination Port (a numeric value between 1 and 65535).

      • Unicast

        • Click Add then enter the Resolver Daemon IP Address and the Port. You can also select an added IP Address and click Remove to delete it in the list.

      • Enter the IP address or CIDR notation pattern matching network interface on the host on which the connector is running in the Local Network Interface box.

      • Select the Reception Mode: Streaming, Persistent and then enter the Persistent Session ID, or Ultra Load Balancing and then enter the ULB Receiver Type ID.

    • Advance Settings

      • Add then enter the Scope, Attribute and Value. You can also select an added Advanced setting then click Remove to delete it in the list.

  1. For the Topic section, can either:

    • just enter the Topic name if you are using the Specific Topic type, or

    • enter the Topic pattern if you are using the Perl-compatible Regular Expression (regex) Topic type then check the Wildcard box.

  1. Select any of the following message types:

    • Fix

    • XML

    • JSON

    • Text

    The dialog slightly changes to allow specification of the following:

      • Text Qualifier

This drop-down list box specifies if fields are enclosed by text qualifiers, and if present to ignore any column delimiters within these text qualifiers.

      • Column Delimiter

This drop-down list box specifies the column delimiter to be used when parsing the text file.

      • First Row Headings

    1. This checkbox determines if the first row should specify the retrieved column heading, and not to be used in data discovery.

  1. Select the Decimal Separator. This specifies the character for decimal separation, when parsing a numeric value. By default this is “.”

  2. Click Add Column.

  3. Enter or select:

    • Name

    • XPath/JsonPath/Fix Tag/Text Column Index (for example, price/@stock)

    • Type (Numeric, Text or Date/Time)

    • Date Format

    • Enabled (whether the message field should be processed)

    • Filter (Defined parameters that can be used as Filter)

NOTE: The Filter option is only available for JSON, Text, and XML Message types

Fix

JSON

Text

XML

You can also opt to click to delete a column in the list.

  1. Select the ID Column.

  2. You can select any of the following Time ID Columns:

    • No Time ID

Enter the Real-time limits. Default is 1000.

    • Automatic Time ID

Enter the following:

      • Time ID Column Name

      • Time Window (seconds). Default is 0.

  1. The schema of the source file is then defined by clicking the Generate Columns… button.

This populates the list of columns, with the data type found from inspecting the first ‘n’ rows of the file.

  1. Click Add Column… to add more columns and specify their properties.

  2. Click OK. The source data is returned in the Data Prep, with the fields displayed in the Data Source Preview.