App Connect

App Connect

Join this online user group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

Explore the new features in App Connect Enterprise 12.0.11.0

By Ben Thompson posted Fri December 15, 2023 06:45 AM

  
iStock_000020343379_XXXLarge


We aim to provide regular quarterly mod releases for ACE 12, which contain both new features and regular maintenance:

  • IBM App Connect Enterprise 12.0.1.0 was released in May 2021.
  • IBM App Connect Enterprise 12.0.2.0 was released in September 2021 - more information here
  • IBM App Connect Enterprise 12.0.3.0 was released in December 2021 - more information here
  • IBM App Connect Enterprise 12.0.4.0 was released in March 2022 - more information here
  • IBM App Connect Enterprise 12.0.5.0 was released in June 2022 - more information here
  • IBM App Connect Enterprise 12.0.6.0 was released in September 2022 - more information here
  • IBM App Connect Enterprise 12.0.7.0 was released in November 2022 - more information here
  • IBM App Connect Enterprise 12.0.8.0 was released in March 2023 - more information here
  • IBM App Connect Enterprise 12.0.9.0 was released in June 2023 - more information here
  • IBM App Connect Enterprise 12.0.10.0 was released in October 2023 - more information here
  • IBM App Connect Enterprise 12.0.11.0 has just been released in December 2023 - more information below.

This blog post summarizes all the latest and greatest capabilities which were made available in IBM App Connect Enterprise 12.0.11.0:

  • 19 New Discovery Request Message Flow Nodes:
    • Amazon Dynamo DB, Amazon SNS, BambooHR, CMIS (Content Management Interoperability Services), Expensify, GitLab, Google BigQuery, Greenhouse, HubSpot CRM, HubSpot Marketing, IBM Cloud Object Storage, IBM Supply Chain Intelligence, Insightly, Microsoft Active Directory, Microsoft OneNote, Microsoft Viva Engage, Square, SurveyMonkey, Wufoo
  • 8 New Discovery Input Message Flow Nodes:
    •  CMIS (Content Management Interoperability Services), Coupa, Insightly, Microsoft Active Directory, Microsoft Viva Engage, Oracle Human Capital Management, SurveyMonkey, Wufoo

  • New Log message flow node for writing log record entries to Activity Log
  • New HTTP Request Policy type for use with the HTTPRequest node
  • OAuth support for the EmailInput and EmailOutput nodes
  • Web UI Enhancement - Retrieve as BAR File menu option

19 New Discovery Request Message Flow Nodes

Continuing our 2023 mission to rapidly expand the available Toolkit message flow nodes for easy connection to third party applications, this quarter ACE 12.0.11.0 has an expanded Toolkit palette offering an additional set of 19 new Discovery Request Message Flow nodes:

  • Amazon Dynamo DB Request node: Use the Amazon DynamoDB Request node to connect to Amazon DynamoDB and issue requests to perform actions on objects such as backups, items, regions, tables, and tags.
  • Amazon SNS Request node: Use the Amazon SNS Request node to connect to Amazon SNS and issue requests to perform actions on objects such as subscriptions, tags, and topics.
  • BambooHR Request node: Use the BambooHR Request node to connect to BambooHR and issue requests to perform actions on objects such as employees, employee dependents, employee files, benefit deduction types, custom reports, list fields, and time tracking records.
  • CMIS (Content Management Interoperability Services) Request node: Use the CMIS Request node to connect to CMIS and issue requests to perform actions on objects such as documents, folders, and repositories.
  • Expensify Request node: Use the Expensify Request node to connect to Expensify and issue requests to perform actions on objects such as receipts, expense reports, and vendor invoices.
  • GitLab Request node: Use the GitLab Request node to connect to GitLab and issue requests to perform actions on objects such as epics, issues, branches, milestones, pipelines, commits, and merge requests.
  • Google Cloud BigQuery Request node: Use the Google Cloud BigQuery Request node to connect to Google Cloud BigQuery and issue requests to perform actions on objects such as datasets, jobs, tables, and views.
  • Greenhouse Request node: Use the Greenhouse Request node to connect to Greenhouse and issue requests to perform actions on objects such as applications, candidates, jobs, job posts, job stages, prospects, and scheduled interviews.
  • HubSpot CRM Request node: Use the HubSpot CRM Request node to connect to HubSpot CRM and issue requests to perform actions on objects such as companies, contacts, deals, line items, owners, and products
  • HubSpot Marketing Request node: Use the HubSpot Marketing Request node to connect to HubSpot Marketing and issue requests to perform .actions on objects such as contacts, contact lists, email campaigns, and marketing events.
  • IBM Cloud Object Storage Request node: Use the IBM Cloud Object Storage S3 Request node to connect to IBM Cloud Object Storage S3 and issue requests to perform actions on objects such as CORS, buckets, and objects.
  • IBM Supply Chain Intelligence Request node: Use the IBM Supply Chain Intelligence Suite Request node to connect to IBM Supply Chain Intelligence Suite and issue requests to perform actions on objects such as catalogs, demand plans, inventories, orders, and products.
  • Insightly Request node: Use the Insightly Request node to connect to Insightly and issue requests to perform actions on objects such as contacts, events, leads, opportunities, or tasks.
  • Microsoft Active Directory Request node: Use the Microsoft Active Directory Request node to connect to Microsoft Active Directory and issue requests to perform actions on objects such as computers, contacts, entries, groups, organizational units, and users.
  • Microsoft OneNote Request node: Use the Microsoft OneNote Request node to connect to Microsoft OneNote and issue requests to perform actions on objects such as pages, notebooks, sections, and section groups.
  • Microsoft Viva Engage Request node: Use the Microsoft Viva Engage Request node to connect to Microsoft Viva Engage and issue requests to perform actions on objects such as files, groups, messages, topics, and users.
  • Square Request node: Use the Square Request node to connect to Square and issue requests to perform actions on objects such as customers, invoices, orders, and payments.
  • SurveyMonkey Request node: Use the SurveyMonkey Request node to connect to SurveyMonkey and issue requests to perform actions on objects such as collectors, contact lists, and surveys.
  • Wufoo Request node: Use the Wufoo Request node to connect to Wufoo and issue requests to perform actions on objects such as forms, form entries, reports, and users.

Each new type of connector also has a corresponding new policy type, which helps Toolkit users define configuration properties for easy connection to the applications. These policies also link to credential information that can be encrypted and stored in an ACE vault, enabling the ACE runtime to safely and securely connect to your applications.

8 New Discovery Input Message Flow Nodes

From ACE 12.0.11.0 the Toolkit palette has been expanded to include 8 new Discovery Input Message Flow nodes:

  • CMIS Input node: Use the CMIS Input node to trigger a message flow and receive input from CMIS. For example, you can use the CMIS Input node to monitor CMIS for new documents.
  • Coupa Input node: Use the Coupa Input node to trigger a message flow and receive input from Coupa. For example, you can use the Coupa Input node to monitor Coupa for new purchase orders.
  • Insightly Input node: Use the Insightly Input node to trigger a message flow and receive input from Insightly. For example, you can use the Insightly Input node to monitor Insightly for new leads.
  • Microsoft Active Directory Input node: Use the Microsoft Active Directory Input node to trigger a message flow and receive input from Microsoft Active Directory.  For example, you can use the Microsoft Active Directory Input node to monitor Microsoft Active Directory for new contacts.
  • Microsoft Viva Engage Input node: Use the Microsoft Viva Engage Input node to trigger a message flow and receive input from Microsoft Viva Engage. For example, you can use the Microsoft Viva Engage Input node to monitor Microsoft Viva Engage for new files.
  • Oracle Human Capital Management Input node: Use the Oracle Human Capital Management Input node to trigger a message flow and receive input from Oracle Human Capital Management. For example, you can use the Oracle Human Capital Management Input node to monitor Oracle Human Capital Management for new candidates.
  • SurveyMonkey Input node: Use the SurveyMonkey Input node to trigger a message flow and receive input from SurveyMonkey. You can use the SurveyMonkey Input node to monitor SurveyMonkey for new responses. 
  • Wufoo Input node: Use the Wufoo Input node to trigger a message flow and receive input from Wufoo. For example, you can use the Wufoo Input node to monitor Wufoo for new form entries.

New Log message flow node for writing log records to Activity Log

For the last few mod releases of App Connect Enterprise, and as shown by the sections above, we have rapidly expanded the number of available Discovery Connector message flow nodes - both input nodes to trigger a message flow and also mid-flow request nodes. The design inspiration for these nodes originates from our App Connect Designer tool which can be used for authoring simple flows in our managed cloud offering and our software container offerings. In a similar design style, the ACE 12.0.11.0 Toolkit now provides a new Log message flow node which helps simplify the task of writing log records to Activity Log in the ACE Web UI. The Basic property tab has a Configure button which opens a more detailed configuration page that looks just like the Discovery Connector configuration pages.

After dragging the node from the Toolkit palette onto the message flow canvas, click the Configure button and use the available properties to control the contents of the Activity Log entries that you wish to generate. The graphical editor also lets you take advantage of the JSONata expression language capabilities which were first made available in Toolkit as part of the mapping capability for discovery nodes which was introduced in 12.0.10.0  For more information about JSONata, which itself is an open source technology, check out the website here which also includes a JSONata exerciser. The Log Node configuration panel lets you select a hard-coded value for the Log level of Debug, Info or Error. Alternatively you can choose a Custom... option which will identify the log level dynamically using a field from the data passed into the Log node. There is also a Message detail property which lets you type free-form text that will appear in the log entry. You can supplement this text with values from the data passed into the Log node or details about the flow such as the Flow name shown in the screenshot below. You can also optionally choose to define Custom message fields to be included in the log entry. Any custom message fields that you define will appear as tags in the generated activity log entry:

You can also add Custom message fields from the data coming in to input terminal of the Log message flow node. Adding entries to the Map Inputs property tab's table, before clicking the Configure button on the Basic property tab, informs the message flow node about the structure of data which is expected to be received by the node and lets you easily address fields using the handy JSONata selection windows like the one shown in the picture above.

In this simple example we just display the default settings above as we have no need for data modelled in further schemas. Having saved all your node configuration, deployed the message flow, and sent some data through the flow, the results of the Log node entries in the Activity Log panel of the ACE Web UI will look similar to the screenshot below:

New HTTP Request Policy type for use with the HTTPRequest node

ACE 12.0.11.0 introduces a new type of policy that can be used to help configure the HTTPRequest and HTTPAsyncRequest message flow nodes. The HTTP Request policy can be deployed and referenced from a message flow node to control connection properties at run time. This new type of policy can be created in a Policy Project in the Toolkit and used to influence outbound HTTP connections from a message flow:

You can attach an HTTP Request policy to an HTTPRequest or HTTPAsyncRequest node to control connection properties at run time. The policy is mainly utilised when you require a simple way to define security settings - for example if you want to configure an outbound HTTP connection to use basic authentication of if you wish to use API key credentials which are saved in the App Connect Enterprise vault, or which were defined using the mqsisetdbparms command.  The API key location property dropdown can be set to header (as shown in the example above) when passing an API key inside the HTTP request header, or body when passing an API key in a URL-encoded format within the request body.

OAuth support for the EmailInput and EmailOutput nodes

For many years, the ACE software product has provided generic EmailInput and EmailOutput nodes which enable emails to be automatically sent as part of a message flow. This can be useful for various logging or auditting scenarios. The product also benefits from dedicated message flow nodes that can interact with specific email providers such as the Gmail message flow nodes (Input and Request) and Microsoft Exchange message flow nodes (Input and Request). The generic EmailInput and EmailOutput nodes have long been configurable with credentials that require a Basic Authorization security model to be adopted when communicating with the email server but starting from App Connect Enterprise 12.0.11.0, you can authenticate with an email server by using the OAuth (Open Authorization) standard.

The Email server name property of the message flow node accepts server addresses which are defined with the imap, imaps, pop3 or pop3s transports. The Security identity property of the EmailInput message flow node links to the definition of credentials which are to be used when communicating with the Email server. You can supply these credentials using the mqsicredentials command.

ACE 12.0.11.0 introduces some new connection parameters for exploitation when using the EmailInput and EmailOutput nodes. These parameters (Enable the use of the STARTTLS command and Requires the use of the STARTTLS command) have been added to the required policy types for the two types of message flow node:

  • The Email Server type policy for the EmailInput node
  • The SMTP Server type policy for the EmailOutput node

The parameters involve commands using StartTLS, a concept that readers may be familiar with from other email clients. It is used to tell the email server that the email client wants to upgrade from an insecure connection to a secure one using TLS or SSL, before issuing any login commands. The pictures below show how you can successfully configure these parameters for an EmailInput node when using OAuth with a Gmail server:

The next picture below shows how you can successfully configure these parameters for an EmailOutput node when using OAuth with a Gmail server:

The examples above are for interaction with a Gmail email server, but you can change these values to be relevant for whichever email server you wish to interact with. The examples above expect the definition of a security identity named acegmailinput for the EmailInput node and acegmailoutput for the EmailOutput node. Here are some example commands for creating the security identities:

  • mqsicredentials  --ext-vault-dir <Your External Directory Vault Directory Location> --ext-vault-key <Your External Directory Vault Password> --create --credential-type email --credential-name acegmailinput --access-token <Your Access Token>  --client-id <Your Email ID>
  • mqsicredentials  --ext-vault-dir <Your External Directory Vault Directory Location> --ext-vault-key <Your External Directory Vault Password> --create --credential-type smtp --credential-name acegmailoutput --access-token <Your Access Token>  --client-id <Your Email ID>

For further information about the new OAuth capabilities, check out the documentation here.

Web UI Enhancement - Retrieve as BAR File menu option

The ACE 12.0.11.0 Web UI includes a useful enhancement which enables you to quickly retrieve from the runtime a BAR file which contains an application that has previously been deployed to your integration server. This feature mirrors equivalent capability which was added to the Toolkit in previous mod releases. This capability can be particularly useful if you have an application deployed to one integration node's integration server and you are keen to quickly create a copy of the application and deploy it to a different server, but you don't have the source files or a built BAR file for the application readily available. This could be through a desire for the speed and simplicity afforded by the use of a web browser, or maybe because you are an administrator and you don't have a Toolkit installation to hand.

Please also bear in mind that there are some limitations surrounding the retrieval of particular older legacy flow formats which are documented in detail here

0 comments
97 views

Permalink