Configuring Connection points for a Multi-Logical ID I/O box

Applications such as Infor CloudSuite Industrial have individual connection points per site configured in ION and use the same In-box and Outbox table between them. In such situations, ION must process messages based on Tenant and based on Logical ID. To enable this, you must create an additional column in the I/O box tables. In addition to this, a property called By LogicalID is added to the category of Message Processing preference in I/O box in the Advanced Properties section of the Application connection point.

To share the same I/O box across multiple Logical IDs:

  1. Run the I/O box script <db>_upgrade.sql from the 3.0 folder in your I/O box.
    For more information, see "Download Scripts" in "Configuration Files tab".
  2. Ensure that a new column called C_LOGICAL_ID is added to both COR_OUTBOX_ENTRY and COR_INBOX_ENTRY
  3. In ION Desk, go to Connect > Connection Points.
  4. Double-click an application connection point.
  5. On the Connection tab, find the category called Message Processing preferences in I/O box.
  6. Set By Tenant and By LogicalID to True.
    You must select the Tenant before you can set the value for By Logical ID.
  7. To publish a message from your application, specify this information:
    • In the COR_OUTBOX_ENTRY table, specify a value for C_LOGICAL_ID
    • In the COR_OUTBOX_HEADERS table, specify the FromLogicalId key with the correct Logical ID value. This ID must match the Logical ID value specified in the connection point.
  8. Use the connection point in your data flow and activate it.
    Note:  ION matches the Tenant and the Logical ID value in a case-sensitive manner. To avoid inconsistencies in tenant processing, you must specify the Tenant ID and the Logical ID according to Infor standards. For the Infor Tenant ID standards, see "Configuring Connection points for a Multi-Tenant I/O box" in the Infor ION Desk User Guide.

    The Infor Logical ID standards are:

    • ID must always start with the prefix "lid://".
    • ID must contain characters ranging from a-z or 0-9 or an underscore (_) or a hyphen (-). Capitals and spaces are not allowed.