Skip to main content

Improvements for ETL

The following usability improvements for the ConSol CM plugins for Pentaho Data Integration have been made.

Contact ID lookup plugin extended (#632113)​

The *ConSol CM Contact ID lookup plugin for Pentaho Data Integration has been enhanced. It now supports searches in lists, i.e. in contact fields which belong to fields of the type Columns (struct) or List (list).

Case-insensitive search in contact plugins (#657350)​

The following plugins for Pentaho Data Integration now allow searching for contacts in a case-insensitive way:

  • ConSol CM contact output: for string fields, the value "true" can be selected in the column Search case insensitive to ignore the case
  • ConSol CM contact ID lookup: for string fields, the value "true" can be selected in the column Case insensitive to ignore the case

This can be helpful, for example, to avoid duplicates if the data contains email addresses, which are not case-sensitive.

In addition, the operation types have been renamed in the contact output plugin:

  • Save -> Create or error
  • Update -> Update or error
  • Select -> Fetch or error
  • Save or update -> Create or update
  • Save or select -> Create or fetch

Wording and icons of ETL plugins improved (#658583)​

The ConSol CM ETL plugins for use in Pentaho Data Integration have been improved. Their names and the labels in the plugin settings have been adapted to the latest terminology used in ConSol CM, so that the objects are named in the same way as in the Web Admin Suite. In addition, the plugins now have new icons which are similar to the ones used in the standard PDI plugins.

ETL plugin Activity execute removed (#658615)​

The plugin Activity execute which could be used in jobs in Pentaho Data Integration (PDI) to execute activities for cases has been removed because it was broken and not in use.

tip

As an alternative, the default PDI plugins Modified JavaScript value and REST client can be used to execute activities via REST API.