Welcome to Semarchy Convergence for MDM.
This document provides the latest information about this Semarchy Convergence for MDM Release, including new features and bug fixes.

New Features in Version 3.2

Convergence for MDM 3.2 introduces new features enabling data stewards and business users to easily manage their master data. It includes customized search forms and a new match and merge technology supporting multiple match rules, suggestions and automated merge and confirmation of duplicates groups based on scoring.

Highlights

Multiple Match Rules with Automated Validation and Scoring

This version includes an extended configuration for matching records. Matchers now support multiple match rules, each rule defining a specific condition for detecting possible duplicates, with a confidence score. Depending on confidence scores, actions are automated triggered on match groups, to suggest or perform a group merge, and optionally confirm the consolidated golden record.

Improved Duplicate Management Editor

To complement the new matching mechanism, the duplicate management editor has been improved and simplified to support matching suggestions and scoring. Duplicates are displayed using grouped view and customized tables to facilitate analysis and decisions on duplicates.

Customized Search Forms

Designers can now create customized forms to search data in the hub. These search forms support simple and complex search patterns as well as display types for the search parameters. Designers can also choose the search methods and search forms available to the business users in the business object views of the MDM applications.

Lineage Navigation in SemQL

The SemQL language is extended to support lineage navigation. Using the updated syntax, designers can define rules and filters that seamlessly leverage golden, master or source records, as well as the errors.

Post-Consolidation Enrichers

Enrichers can now run not only on source data but also on consolidated records. Using these enrichers, matched and merged data passes through additional augmentation and standardization transformations before being published into golden records.

Convergence Pulse Dashboard Enhancements

Designers can configure the Convergence Pulse dashboards to show metrics for the current application only or for all applications. Each dashboard has been localized and now displays additional description and tooltips explaining the dashboard and the metrics. The color schemes used in the dashboards have also be enhanced for better consistency and readability.

PL/SQL Functions

Designers can declare in the data model PL/SQL functions and packages developed separately. By declaring these functions, they make them available in the SemQL editor and make possible syntactic validation while editing expressions.

Auto-Refresh

Designers can configure applications and business object views to support auto-refresh. With auto-refresh, activity lists as well as data tables, automatically refresh to reflect in the application user interface the most recent information from the hub.

Folders and Business Object View Customized Order

Designers can explicitly define the order of the folders and business objects displayed in the applications, using alphabetical or positional ordering.

Other Changes

Design Time

  • Workflow transitions can be configured to skip the complete task dialog.

  • Integration job batch ID (V_BATCHID) is available for enrichers and validators

  • New Download Hyperlink display type for binary content that should be downloaded by default.

MDM Applications

  • The record edition dialog no longer displays the Enrich and Validate buttons if no enricher or validation is configured for the task.

  • The record edition dialog now supports immediate data save and task completion.

  • Transitions no longer show the complete task dialog depending on the workflow configuration.

  • Data entry workflows now support Select All then Remove action.

  • Duplicate manage workflows support Select All actions.

  • Tables in the application now save column width in the user preferences.

  • Pulse dashboard for duplicates now exposes the confirmation status for the golden records.

  • Activity overview and activity lists now display the workflow submit/cancel date and time for a completed task.

  • Claim task is checked by default in the complete task dialog if the user can claim the next task.

  • Notify Assignee is checked by default in the complete task dialog if notification is possible.

  • The Suggest Mapping feature in the data import wizard is enhanced to support reference fields (e.g.: Column named like FID_…​, )

  • Number form fields raise better warning for invalid or overflowing numbers.

Administration

  • Model edition deployment uses a non-modal dialog during job execution.

  • OpenID Connect Connector is provided for Tomcat

Integration

  • New Web Service exposes ID generation.

New Features in Version 3.1

Convergence for MDM 3.1 introduces new features for designers to deliver a highly customized and efficient user experience for the data management applications. It also includes productivity features for the business users and data stewards who use these applications.

Highlights

Application Customization

This version is enhanced with a series of features for application designers. Object duplication is now supported for Form Views, Tables Views, Business Objects, Business Object Views and Workflows. User interfaces can be customized with new capabilities, including a compact mode and a read-only option for fields, display properties to configure the display and sort mode for list of values, plus customizable patterns for formatting numbers. Access to business objects can be limited to a required role.

Re-Designed Activity Lists

The activity lists and overview displayed in the applications are entirely redesigned to expose all relevant activity information at a glance. These lists support a full set of usability features (click-vertizing, multi-selection, pagination) as well as user customization.

Activity Management

Workflows can now be configured to support updates of their label, priority and startup comment while running. Similarly, users can add information to a task comment while processing the task.
Data entry workflows now support different privileges for creating records and checking out records for update.

Select All and Mass-Update

The activity experience have been enhanced to support Select Page and Select All operations. Data Entry now supports Mass-Update of selected records. In the mass-update editor, power users may choose to preserve or overwrite field values for an unlimited number of records. Mass update processes records and reports possible data issues at the end of the process.

Plug-in Parallel Processing and Error Management

The plug-in framework is now enhanced to support parallel processing. Designers can define the number of parallel threads for each plug-in enricher/validator. All built-in enrichers and validators are updated to support this feature.
Plug-ins are also enhanced to support error recovery. Designers can indicate, for each plug-in call, a number of attempts and a behavior on error.

Pulse Metrics Configured and Managed in the Workbench

The Convergence for MDM platform now technically includes the Pulse Metrics option. Setup, configuration and administration of Convergence Pulse is dramatically simplified and takes place entirely within the Workbench.

Customizable Notification for Integration

Application and User Notifications - sent when a certification process completes - are now unified in the plug-in framework that support advanced conditions as well as customized notifications. Built-in notification plug-ins supporting Email, JMS, File, HTTP/Web Services are provided out of the box.

Web Services for Batch Data Integration

Web services for data integration have been updated at platform and data-edition level. They now manage every aspect of the batch data integration process (load management and data load).

Other Changes

Design-Time

  • Design-time object duplication for Form Views, Tables Views, Business Objects, Business Object Views and Workflows.

  • SemQL now support function names with 2 qualifiers: <schema name>.<package name>.<function name>

  • A default record-level consolidator is created when creating a new entity. Switching from a record-level to a field-level consolidator and vice-versa is now possible.

  • New CompactMode display properties enables removing the "Clear" end "…​" (More) buttons on attributes for more compact forms.

  • Form designer can now explicitly make form attributes Read-Only

  • New display property to configure the display mode (code, label, both or user-defined) for list of values in form and table views.

  • Form fields containing numbers can now be explicitly formatted using patterns supporting decimal and grouping separators, padding and currencies.

  • Hide URL for Embedded URL to display only the content.

  • New LovSortMode defines a list of values attribute sort order, by code or label.

  • An optional role can be defined on business object views to define the privilege to see this business object view.

  • Record Checkout and Record Creation privileges are now separated.

  • Support multiple transitions from Task_A to Task_B

  • Configure parallel processing for plug-ins to execute enrichment and validations faster in parallel threads. Built-in plug-ins are updated to support multi-thread processing.

  • Error behavior for plug-ins can be configured with a number of retry and a behavior on error to skip records, the entire plug-in task or to fail the task.

MDM Applications
  • Filters can be toggled from the Search menu item.

  • Quick Search now automatically targets the currently opened business object view.

  • The semarchyAdmin built-in role no longer has full access to models' data. A privilege grant must be created for this role to define his access rights.

  • Mass-update for a set of records in data entry.

  • Select Page and Select All options for selecting and managing large data sets.

  • The activity initiator or administrator can update the label, priority and startup comment of a running activity.

  • Activity task comment can be modified while processing the task.

  • New activity lists and editors to easily track the status and progress of the data management workflows: Task/Activity lists are entirely re-designed in the application interface:

  • Design-time object duplication for Form Views, Tables Views, Business Objects, Business Object Views and Workflows.

  • SemQL now support function names with 2 qualifiers: <schema name>.<package name>.<function name>

  • A default record-level consolidator is created when creating a new entity. Switching from a record-level to a field-level consolidator and vice-versa is now possible.

  • Support for paging, multiple selection and clickvertizing in activity lists

  • Display recently completed activities on the home page with the status of their data certification job

Administration

  • Pulse Metrics configuration and runtime is integrated in Convergence for MDM

  • Repositories can be named with installing the repository. Repository name appears in the upgrade process and in the repository information dialog.

Integration

  • Plug-in architecture for notifications sent upon batch terminations. Notification framework for JMS, FILE, HTTP, SMTP

  • Integration web services for publishing data batches in a generic way at platform-level or at data-edition level.

  • Advanced security documentation to configure role mapping, OpenID, mixed authentication and SSO.

Previous Releases

New Features in Version 3.0

Convergence for MDM 3.0 introduces many new capabilities that expand your ability to manage master and reference data. This release includes a simplified user experience supporting mobile devices, greater control over visual composition for data forms and enhancements to the data models

Highlights

Redesigned User Experience

The user experience in MDM applications has been redesigned in this version from the ground up, to make it more intuitive for business users. By implementing principles such as clickvertizing (only show available actions), single-click and responsive design, we have made this interface simpler to use on every device. By adding dozens of enhancements including breadcrumbs and a new search window. We ensure that you have the power of the platform at your fingertips.

Embedded Dashboards - Powered by Pulse

Pulse Metrics dashboards are automatically embedded in the applications generated for business users and data stewards.
MDM users and data stewards can now access Data Quality, Duplicates, Timeline and Workflow Performance dashboards right from their application.

Application Design Enhancements

This release enables application designers to deliver highly customized MDM applications.

Application designers can now choose the available features (dashboards, lineage, etc.) for the applications, and limit the access to these applications and their features to specified roles.

Form views now support flow and grid layouts to quickly create simple forms or highly complex ones, using a visual composition editor. You can now choose the exact position, sizing, and more, for each attribute and section in a form. Attributes in these forms benefit for a rich palette of display components. You can design forms that will look good on desktop and mobile platforms, without a line of code.

Business object views are enhanced: they support customized labels and display names as well as sort in the hierarchy. You can also explicitly design the reference navigation and selection in business object views.

New and Updated Plug-ins

New built-in plug-ins are added to the platform:

  • Person Name enricher to extract the given name, surname and gender from a person’s full name,

  • Google Translate enricher to automatically translate text for 80 languages,

  • Phone Extractor enricher to retrieve the phone numbers from any text,

  • OpenStreetMap enricher plug-in for address enrichment,

  • Email Validator to check syntactic and domain validity of emails.

Other Changes

Design-Time
  • Additional validations detect if the integration job at the end of a workflow does not process all entities referenced in the workflow.

  • Nodes are reordered in the model to indicate the sequence of objects to create.

  • Validations and enrichers support parent and child entities’ attributes.

  • References now support Referencing Role Plural Label and Referencing Role Label to refer to one or multiple child records.

  • Field Level Consolidators using a Custom Ranking strategy now support a Skip Null option to skip null values and pick the highest-ranking not null value.

  • Attribute Groups are deprecated. Entities automatically display attributes in the order defined in the entity in a User Attributes group. Technical attributes are displayed in a Built-in Attributes group.

  • Consolidators now default to Most Frequent for all non-LOB values, and Longest Value for LOB values.

  • Transitions in Business Objects now support a Customized Label options that allows defining a custom label, plural label and description for the transition.

  • Default Application is created on model creation. The upgrade process replaces the No Application pseudo application with the Default Application.

  • Applications now support global access restrictions and specific features access restrictions by role.

  • Customize business object views to open with a search on the list of records or the first record.

  • Business object views support data entry form views in addition to the data browsing form views.

  • Reference Navigation is now customizable for business object views. The navigation target may point to another business object view.

  • Selection of references from business object views for data entry can also be configured with a filter applied to the reference picker. This makes Data Stewards more efficient while working with very large data sets.

  • Visual Composition for Table and Form Views, including a grid-based design for form views.

  • Display Name can be customized for a node in a BO View.

Administration
  • Data Location deletion also supports optional drop for all the objects in the data location schema. This convenient mechanism allows resetting the hub content at the early model design stages.

  • Notification Servers now support a Default option to indicate which notification server is used for human workflow notification emails.

  • Notification Servers creation wizard now includes SMTP authentication options.

  • Administrators can now suspend a Job that is running in order to abort it.

Platform
  • Performances

    • Data Certification Process now uses NDV Algorithm for gathering statistics for Oracle 11g versions and above.

    • Matching Process Performance improvement for incremental loads

  • Certifications

    • Apache Geronimo 3.0.1 and IBM WebSphere Liberty Profile 8.5.x are now certified.

    • Oracle WebLogic 11g is no longer supported as it is not JEE 6 compliant.

MDM Applications
  • Master/Detail editors reorganized using tabs

  • Responsive home page, layout, editors and toolbars

  • Suggest Mappings in the Excel import wizard ignores noise (case, underscores, spaces) when matching Excel columns and attributes.

  • Action clickvertizing

  • Simplified customized Sort with support for multi-column sort

  • Breadcrumb in data browsing editor

  • Dialogs with a file download option immediately download (no extra clicks needed).

  • Data entry workflow editor layout change: the history and overview tab now appear in a popup dialog.

  • Data Filtering is enhanced with a new single window to manage and edit all filters.

  • Seamless navigation experience in BO View and Entity: Access the whole lineage from the business object views.

  • Explicit record selection with a selection column.

  • Reorganized display properties menu. Pagination directly customized from the display menu

  • Improved selection dialog when moving a master record to a new golden

  • Embedded Pulse Metrics dashboards: Data Quality, Duplicates, Timeline and Workflow Performance

Plug-ins
  • Phone

    • New Phone Extractor Enricher to extract a list of phone numbers from a given text

    • Phone Enricher changes: Now supports better localization of phone numbers and detailed return codes and messages explaining phone processing. Support for time zones and carrier detection from the phone number.

    • Phone enricher returns the original phone number instead of a null value when parsing fails.

    • Phone Validator supports validation leniency parameter to manage validation level.

  • Text Enricher

  • Email

    • New Email Validator Plug-in checks email validity without transforming it.

    • Email Enricher: Valid Domain and Valid Input Domain now return null instead of N/A for domains that are unchecked.

      • New Processing Mode for email enrichers uses an in-memory-only domain cache.

  • Translate

    • New Google Translate Enricher using the Google Translate service.

  • Person Name

    • New Person Name Enricher extracts from a person’s full name his/her Given Name, Surname and Gender.

  • Geocoding

    • Yahoo! PlaceFinder Plug-in is removed from the product and documentation due to Yahoo discontinuation of this service.

    • Added OpenStreetMap plug-in.

    • Google Maps enricher now supports a Status output to indicate the status of the request and possible errors.

    • Google Maps enricher now returns a Formatted Address output that contains the human-readable version of the geocoded address.

    • Google Maps enricher now supports request throttling.

New Features in Version 2.2

Semarchy Convergence for MDM 2.2 brings master data governance to the next level by introducing a redesigned user experience with enhanced interactivity.

Redesigned Master Data Governance Experience

Convergence for MDM introduces a redesigned interface for business users and data stewards exercising master data governance.

This user interface is separated from the design-time workbench and provides simplified and powerful access to the master data. It has been enhanced in the following areas:

Clarity
  • An updated Home page with shortcuts to workflows

  • A simplified layout showing only relevant content and options

  • Simplified forms and editors

  • An issue detection report showing all data issues data validations, duplicates, concurrent changes ) in a single place, with the capability to export the issue report.

Efficiency
  • A reorganized navigation panel

  • Quick Search to find any piece of data at any time

  • Consistently reorganized actions

  • Direct activity actions to claim, un-claim, or complete a task in a single step

  • Direct duplicate management actions (merge, split, etc.) from the data lists and tree view

  • Direct data editing actions from the data lists and tree view

Comfort
  • URLs to directly access applications and data editions

  • Support for multiple browser tabs

  • An elegant theme with an improved icon set

With no additional design-time effort, this new simple, fast and elegant interface is available from your Convergence for MDM instance on the /data path.

Interactive and Safe Data Authoring

Convergence for MDM 2.2 adds new benefits for users authoring data in the hub: data entry is made simpler, faster and safer.

Interactive Data Augmentation and Validation

With this feature, developers can define enrichers and validations triggered on workflow tasks and transitions. Resulting workflows deliver more interactivity to the business users and data stewards authoring master data in the hub:

  • Enrichers are triggered from data entry forms, automatically augmenting input fields or filling in computed fields. At the same time, validations pro-actively notify users of possible data issues. All this happens interactively while the user enters keystrokes or moves from field to field.

  • When the user completes a workflow task, enrichers and validations are automatically triggered to enforce data quality policies. Issues detected are reported as simple warning messages or may be configured to block the user from completing the task.

Developers can configure enrichers and validations from the Properties view for tasks and transitions in the Workflow diagram for data entry workflows.

Pro-active Duplicates and Unique Keys Detection

ID Matching entities, frequently used for data authoring patterns, now support duplicate and unique key violation detection within workflows:

  • Developers can define matchers on ID Matching entities. Such matchers detect duplicates for a record while it is created.

  • Unique Keys defined in the model on ID Matching entities are also checked in data entry workflows.

When a business user edits a record in a workflow, the interface warns him immediately if he is about to create:

  • A record similar to one that already exists (according to the matcher), allowing him to check this record out and modify it instead of creating a duplicate.

  • A record that violates a unique key definition.

Developers enable duplicate detection on ID Matching Entities by creating Matchers for these entities. Unique key validation is configured as a validation in a workflow task or transition.

Concurrent Change Detection

Data being processed in an activity may become out of sync if the original record is modified by another human workflow or by a publishing process.

Such concurrent change is now automatically detected in the workflows. A warning is raised to the user working on the out-of-sync data, allowing him to ignore or merge these changes into his data transaction.

Concurrent changes are automatically detected and raised as needed when processing data entry workflows.

Design-Time Enhancements

Designers benefit from the productivity features of Convergence for MDM 2.2 to deliver faster iterations for their MDM initiatives.

Workflow Design Productivity

The workflow design has been enhanced with capabilities to support not only Interactive Data Augmentation and Validation, but also with the ability to add Customized Labels on transitions.

The design-time workflow editor now includes a Properties view. Using this view, developers can modify tasks and transitions without leaving the diagram, enhancing their productivity in workflow design.

Filters on Child Records

SemQL has been enhanced to support conditions based on child records.

For example, if a Customer has several Contacts, you can now easily design filters involving the customers’ contacts:

  • Customers with at least one contact.: ANY contacts HAVE (1=1)

  • Customers with all contacts without email. ALL contacts HAVE (email IS NULL)

  • Customers with contacts located in a different country than the customer: ANY contacts HAVE (country != customer.country)

The new ANY/ALL syntax is available from the Expression Editor. For more information, see the new Semarchy Convergence for MDM SemQL Guide available in the documentation library.

Export/Import Models Everywhere

Model edition export is now allowed from deployment repositories. With this option, administrators can transfer models as they were originally deployed between test/UAT and production environments.

Model edition import is now possible to development repositories. Import closed or open model editions either as new models, or on top of open model editions.
Using this feature, developers can transfer models across repositories at design-time with a just few clicks.

New Plug-in: Text Normalization and Transliteration

This new plug-in applies normalization, transliteration (including Cyrillic, Arabic, Japanese and other eastern languages) and phonetic (metaphone, soundex, double metaphone, caverphone, refined soundex) transformations to text strings.

With this plug-in, the data certification process can transform international strings to a common standard, which makes fuzzy matching possible even for data published in different languages and character sets.

Other Changes

Design-Time
  • Field-Level Consolidators using the Preferred Publishers strategy now have a Skip Null option.

  • New golden record attributes: Masters Count stores the number of master records contributing to a golden and Is Confirmed indicates whether a user has validated the matching group.

Administration
  • Web Services management is now attached to the Execution Engine platform privilege

  • Notification Servers and Variable Value Providers management are now attached to the Data Location platform privilege.

Deployment
  • Administrators can now close data editions with open workflows, and have these workflows continue in the new data edition.

  • New closeAndCreateNewDataEdition web service to support Data Edition management automation.

  • External Loads are no longer attached to a data edition:

    • In the Data Locations editor, the Latest Loads are now under the data branch node, and no longer under each data edition.

    • Loads start automatically on the latest edition of the data branch and the Data Edition ID is no longer needed to start a load.

    • The new version 1.1 of the Integration Web Services is updated and the dataEditionID element is no longer needed for the getNewLoadID operation.

    • In the repository schema, the MTA_GET_NEW_LOADID, MTA_CANCEL_LOAD and MTA_SUBMIT_LOAD PL/SQL functions and procedures are deprecated (but still work) and replaced by the GET_NEW_LOADID (this new function does not have a Data Edition ID parameter), SUBMIT_LOAD functions and the CANCEL_LOAD procedure in the INTEGRATION_LOAD package.

  • In the Activity web service, the CompleteTask request now requires a transition name (TransitionName) instead of a task name (TransitionTaskName is deprecated). Existing workflows will work with the new web services as the upgrade names the transitions as their target tasks.

New Features in Version 2.1

Overview

Semarchy Convergence for MDM 2.1 introduces new features to make the life of business users and data stewards easier and more productive: As they browse the data, then can perform quick records checkouts and immediately start authoring and managing data in newly organized editors. While working on this data, which now can includes errors and rejects, the are assisted with features such as automated ID generation and inline and bulk data validation. They can also take advantage of the improved data import/export in Excel and CSV and work with their favorite data editor.

With this release, developers and administrators are also invited to use the new design options for entity matching behavior and create retention policies and scheduled purges to enforce data governance and compliance policies.

Detailed Features

Entity Matching Behavior

This release introduces a new naming convention for entity types that replaces the Primary Key Type (SDPK, UDPK).
Entities are now identified by their Matching Behavior:

  • ID Matching (formerly known as UDPK): Records in entities using ID Matching are matched if they have the same ID. This matching behavior is well suited when there is a true unique identifier for all the applications communicating with the MDM hub and for simple Data Entry use cases.

  • Fuzzy Matching (formerly known as SDPK): Records in entities using Fuzzy Matching are matched using a SemQL expression defined in a matcher.

The matching behavior is defined when creating the entity and is modified using the Alter Entity action.

Automated ID Generation

Entities Primary Keys (IDs) can now be automatically generated in the data entry forms. The method for generating IDs is configured in the entity definition and may use sequence or a built-in UUID generator.

This feature facilitates data authoring through applications for business users and data stewards and they no longer need to enter ID values.

Error Processing Workflows

Contributions via data entry workflows now include fixing rejects, in addition to authoring or modifying data.
Model designers can define whether golden data, master data and/or rejects can be brought into the workflow that they create.

Using this feature, data stewards can now address data issues detected in the golden data certification process using regular data manipulation workflows, which are managed in the Convergence for MDM platform.

Improved Experience for Data Authoring and Stewardship

The data entry and duplicate management activities are now made easier to use through subtle improvements of the data entry and duplicate management editors.
This includes a complete reorganization and renaming for the actions. The are now grouped in a single Actions menu. Users can flag frequently used actions as Quick Actions to make them available in the editor toolbar.

Quick Records Check out

Users can now quickly select and check out records as they browse them. This operation adds these records to an existing activity or creates a new activity with these records. This activity automatically opens and the user can immediately start working on these records.

With this feature, users can naturally and quickly trigger activities as they see the data, dramatically boosting their productivity.

Workflow Data Validation

Data modified or entered in the context of a data entry activities is now be validated at two levels:

  • Form Data Validation: Within data entry forms, information not compliant with the data quality rules defined in the model is detected and errors are raised to the user.

  • Bulk Data Validation: All the data modified or entered in the context of a data entry activity can be validated against the data certification rules in bulk using the new Validate action.

Using these two features, data authors can now pro-actively fix issues that may cause data rejection before saving each data record and before completing a task.

Improved Data Import/Export in Excel and CSV

The import/export feature available to extract data from the hub or bulk import data is now improved with the following capabilities:

  • CSV Files Support: Data import and export now support CSV files in addition to Microsoft Excel workbooks.

  • Reusable Import Settings: Import settings, including file format specification and columns to attributes mappings can be saved and reused for subsequent imports.

  • Advanced Export Settings: The format of the exported files (list of values, references, complex attributes and header columns) can be customized through advanced options.

These new capabilities help business users and data stewards manage customized exports and import for data viewing and bulk changes.

Retention Policies and Scheduled Purges

Preserving the lineage and history of the golden data is a frequent master data governance and regulatory compliance requirement. To make sure that the data lineage and history are preserved according to the governance and compliance requirements, model designers can now define Data Retention Policies for the model and for individual entities.

For example:

  • The hub is configured to retain no history at all. This is the general policy.

  • Employee data is retained for 10 years.

  • Product and Financial data is retained forever.

However, keeping this information may also create a large volume of data in the hub storage. To keep a reasonable volume of information, administrators can now schedule Purges for this data. These schedules are handled by a Purge Scheduler, accessible from the administration view. These purges respect the retention policies defined in the model design.

Retention policies and scheduled purges guarantee ease of administration, data volume control as well as compliance with data retention policies for regulatory compliance.

For more information about Retention Policies, see the Defining Data Retention chapter in the Semarchy Convergence for MDM Developer’s Guide. For more information about purge scheduling, see the Scheduling Data Purges section in the Semarchy Convergence for MDM Administration Guide.

New Features in Version 2.0

Major Features

Support for High-Availability Deployment

Convergence for MDM 2.0 supports the clustered deployment of the Convergence for MDM web application for high-availability and failover. A clustered deployment can be set up for example to support a large number of concurrent users performing data entry or duplicate management operation.

For more information, refer to the High-Availability Configuration section in the Semarchy Convergence for MDM Installation Guide.

Display Components

The display of form and table view attributes can be configured by setting a Display Type and optionally the height and width of the display component. Display types allow including Embedded Content or URL, Images and Hyperlinks into the data access form and table views.

For more information, refer to the Display Types section in the Semarchy Convergence for MDM Developer’s Guide.

Row-Level Security

Convergence for MDM 2.0 introduces a new level of details for securing data access.
It is possible to define SemQL Filters for the entities in a Model Privilege Grant. This filter will make accessible only the filtered records for the user having this role. Using filters, model designer can choose to restrict the access to specific entity records depending on the roles.

For more information, refer to the Securing Data chapter in the Semarchy Convergence for MDM Developer’s Guide.

Model Variables

Model Variables can be defined in the model, these variables’ values are refreshed from a query to an external provider. The Variable Value Providers, defined in the Administration Console perspective, can be either an LDAP-compatible directory or a database connected via a JDBC Datasource.
Variable values are refreshed when a user connects to access the hub data, and are local to this user’s session. The variable can be used for example in the filters defined for row-level security.

For more information, refer to the Model Variables section in the Semarchy Convergence for MDM Developer’s Guide and the Configuring Variable Value Providers section in the Semarchy Convergence for MDM Administration Guide

Model Documentation

Semarchy Convergence for MDM 2.0 introduces a new feature to generate a model documentation set in HTML format.
This documentation set includes the Logical Model, Applications and Physical Model documentation.

For more information, refer to the Generating the Model Documentation'' section in the Semarchy Convergence for MDM Developer’s Guide.

Client API

A new client API is available to design and develop customized user interfaces to:

  • Explore the structure (metadata) of the MDM hub content.

  • Access the data stored in the MDM Hub,

  • Interact with the workflows

This API is available in the semarchy-mdm-client-<version tag>.zip file with documentation and samples.

Other Changes

Administration
  • The Plug-ins editor now shows only plug-ins added by the user and supports plug-in removal.

  • Plug-ins added by the user are stored in the repository and not deleted when re-deploying the application in some application servers (Tomcat).

  • New Include Model Edition in Namespace option in the Web Service Manager.

  • Batch Poller frequency is now configured by default to 10 seconds.

  • Auto-start preferences for the web services are lost in the upgrade process and must be reset.

Deployment
  • It is possible switch the deployed model edition of a given data edition without closing and opening a new data edition. Switching a model edition preserves the old version of the jobs under a Deprecated Jobs node.

  • Data edition Closing mode is now called Maintenance mode.

Integration
  • The following table structure changes must be taken into account in the integration flows targeting the MDM hub:

    • In the SD_ tables, the B_BATCHID column no longer exists.

    • In the SD_ tables, the B_BRANCHID column is mandatory and must be loaded with the data branch ID.

  • New/updated web service in this release:

    • Platform Services > Metadata Web Service, for the client API.

    • Data Services now expose two new WDSL per data edition: ActivityService and GenericDataService. See the Convergence for MDM Integration Guide for more information.

Change Log

Version 2.0.1.

  • 590 - The popup window for an image attribute does not preserve the aspect ratio

  • 595 - Missing Dependency Error when installing the Convergence for MDM Plugin SDK 2.0.0

  • 596 - Attribute names in a form view are incorrect for the attributes of a parent entity.

  • 597 - MTA_SUBMIT_LOAD to submit Deprecated Jobs causes an ORA-01422 Error

  • 600 - RuntimeException: Cannot update a deployed Model Edition in a production environment. on Install Model Edition in Repository with DEPLOYMENT type

  • 604 - Tomcat Server does not shut down if a session is running

  • 605 - OutOfMemory PermGen Space error when validating a model

  • 607 - Button requires a double-click to open the SemQL editor (Enricher and Binning Expression)

Version 2.0.2

  • 87 - Contextual menu is empty on the model edition tree view after a validate action

  • 125 - Non admin users connecting while the repository is down have no privileges until they logout and login again

  • 423 - Update to the workflow notification message and subject

  • 433 - Editor toolbars stop working after perspective switching

  • 442 - Notification Servers: wizard should automatically set first server as default

  • 470 - Improved user experience when upgrading a model edition to fix a job that failed

  • 472 - Job Logs view allows deleting running Jobs

  • 498 - Validator for Plugin should raise warning when some input/outputs are not mapped but enricher/validation is disabled

  • 499 - Model Validation should raise a warning when an entity is not processed by any job

  • 507 - Right-click Validate should put the focus back on the Progress Editor

  • 550 - Fonts used are now suitable for Linux, Mac and Windows

  • 562 - Columns displayed in duplicate management workflows’ tables are persisted in the user preferences

  • 598 - Job are not ordered correctly under the data location tree

  • 599 - Model Edition Import Wizard should refresh the Model Edition tree after import

  • 611 - LOV import from excel imports formula text instead of formula result

  • 613 - Validator now prevents using Large Objects (LOB) attributes in entity or complex type subject names

  • 615 - Duplicate Management workflows: The treeview status (expanded) is lost when any action is done

  • 616 - Error ORA-00904: GD.FS_XXX when starting a data entry workflow with a UDPK entity referencing a SDPK entity

  • 618 - Excel Import Wizard: Added a progress bar during the file processing

  • 626 - NullPointerException error when an importing Excel data with rows containing only blank cells with formatting info

Version 2.0.3

  • 636 - Data Entry: Unable to create a child record if parent entity is inherited

  • 637 - Missing Validator for a Record Level Consolidator with Publisher Ranking and no Publisher in the List

  • 642 - GD analyze statistics analyzes the wrong table (MD)

  • 643 - In the Reference creation wizard a whitespace in the physical name causes an error flag that never disappears

  • 644 - Error This binding expression S.B_LOADID is not present in this row in data entry workflows when entering a new record with a row filter on the entity

  • 653 - Convergence for MDM Plugin SDK is now signed

  • 654 - Home Dashboard has an incorrect scrolling behavior

  • 661 - Attribute Group Namespace is incorrectly checked. Namespace should be across entity inheritance hierarchy

  • 662 - Support inherited entities in data entry workflows

  • 663 - Entities are not ordered in the Job Creation Wizard

  • 664 - Publisher code is now autofilled in uppercase in the publisher creation wizard

  • 666 - On BO Views, search is not persisted when using the Back button

  • 672 - Validation does not raise any issue for form views with no attributes

  • 673 - Importing of large Excel file cause the application to become unresponsive

  • 677 - Data Entry usability improvements for dates: display a format hint and a decorator for invalid values

  • 678 - Data Entry: ClassCastException when displaying a record with invalid Multi-LOV values in a table view

  • 696 - Date picker displays date format helper message and picker button even for read only fields

Version 2.0.4

  • 704 - Incorrect French translation La Clé de Licence est invalide when registering a valid license key

  • 706 - Excel Import Fails with Empty Cell

  • 702 - Error when importing Excel an worksheet with cells containing formulas returning error values

  • 700 - IE9/IE10 is unable to display HTML object type image/png

  • 712 - Excel Import adds .0 to a numeric cell value imported in a string attribute

  • 715 - java.lang.IndexOutOfBoundsException in the Excel Import wizard when previewing a different worksheet with a larger number of columns

Version 2.0.5

  • 721 - Model Import on in a production repository fails

Version 2.0.6

  • 724 - New applications do not appear after moving a model to production

Version 2.1.0

  • 432 - Count query to display the total number of rows in tables are computed on demand

  • 471 - New Batch Poller option Plugin Tasks Feedback Interval defines row count refresh interval for long running plugin tasks

  • 520 - Session Timeout Window has a broken layout

  • 572 - Refresh button in Data Entry View does not correctly refresh the table content

  • 586 - Convergence workbench incorrectly freezes on Loading page if the repository database is unavailable.

  • 609 - No scrollbar on the workflow editor with small browser windows

  • 612 - Excel Import resolves formulas while importing data

  • 620 - Excel import mapping suggestion is not case insensitive

  • 625 - A new dialog show the number of records imported successfully or failed

  • 641 - Scripts in the bin folder do not have execution permission on after uncompressing the distribution

  • 655 - The initial focus is not correctly set in the wizards with Firefox

  • 658 - Home Dashboard fails to load with a DataAccessPermissionDenied exception if user has row-level security defined

  • 684 - Certain actions are incorrectly enabled for multiple-selections in the duplicate management editor

  • 686 - Dialog for selecting candidate values (for example in a filter) incorrectly allows multiple values selection

  • 692 - ORA-00001: unique constraint (XXX) violated if the same complex type is used twice in the same entity and if both attribute are in error.

  • 693 - A value selected in the selection dialog is ignored for Date types in criteria filter definition

  • 695 - Finish button is now disabled on the first page of the Open Data Edition wizard

  • 697 - A zero rows sample raises an exception when clicking Next in the Excel Import Wizard

  • 698 - Export button should be disabled when list of records is empty

  • 701 - Default validation is now pre-consolidation for newly created validation elements

  • 705 - Reference validation scope is not exported in Model Documentation export for References that are not mandatory

  • 707 - Excel Import fails with an Excel file with lines that have been emptied.

  • 716 - Incorrect display type used for complex attribute’s definition attributes in form and tables views.

  • 718 - ORA-30926: unable to get a stable set of rows in the source tables error occurs on the Consolidate singleton master records into GI table task.

  • 727 - Erratic layout behavior of the sections in the Home Dashboard

  • 730 - Folder Names instead of labels incorrectly shown in the model tree view

  • 739 - Getting Started Actions are now hidden if user does not have the semadmin role

  • 740 - Changing the name of an object does not change the editor’s tab label

  • 741 - It is no longer possible to remove all the displayed columns from a data table

  • 743 - Business Object Views are not ordered alphabetically by label in the Structure of a Data Entry Activity

  • 746 - New Display Format and Export Format options for List of Values in User Preferences and Export Dialog

  • 747 - Integration Job incorrectly validates mandatory attributes existing only in child entities (inheritance)

  • 749 - Better error message when a multi-LOV value cannot be stored due to the attribute size

  • 750 - Missing Remove button for Embedded Content display type during Data Entry

  • 754 - Image are displayed too large in the Data Entry activity table

  • 756 - Wrong label for BO views selection step in the Data Entry workflow creation wizard

  • 776 - Invalid SQL generated when using BETWEEN in SemQL

  • 787 - Job Remains Running after a repository crash

Version 2.1.1

  • 898 - Fixed slower opening of data editions in 2.1 compared to 2.0

  • 889 - Submitting a workflow while a record is displayed in a form view generates an AssertionFailedException

  • 888 - A model validation is added to have at least one output for plug-in enrichers

  • 895 - End of record error with CSV files

  • 906 - Filters do not seem to apply correctly to data editors opened twice

  • 896 - Editable table cells containing SemQL expressions incorrectly keep the focus on exit

  • 890 - Documentation export on a model using inheritance and attribute privileges generates an IllegalArgumentException

  • 905 - The overview page does not appear when the engine is stopped

  • 892 - AssertionFailedException: assertion failed: Getter called on disposed observable is logged when closing a data editor

  • 891 - A NullPointerException appears when checking rejects out if the table view contains attributes using SemQL expressions

Version 2.2.0

Known Issues

  • MDM-1298 - [Weblogic 12] 403 error page is not displayed when user is not authorized

  • MDM-1201 - Incorrect Mixed Content Warning in IE8 with HTTPS Configuration (IE Bug)

New Features

  • MDM-970 - Support Filters on the Many relationships

  • MDM-971 - Support for enrichers and validations in task and transition in data entry workflows

  • MDM-975 - Support for BO Views defined at task level for data entry workflows.

  • MDM-1000 - Design time Import/Export of Model Edition

  • MDM-1041 - BO View display order can be defined for data entry workflows.

  • MDM-1083 - Automated ID generation in Data Entry for Fuzzy Matching Entities

  • MDM-1110 - Support export from Deployment repository

  • MDM-1140 - Add Masters Count on Golden Records

  • MDM-1141 - Add a new attribute on Golden records to tell whether Golden Is Confirmed or not

  • MDM-1144 - Closing and creation new data editions should keep running workflows and loads

  • MDM-1146 - New Web Service to Close and Create a New Data Edition

  • MDM-1213 - New xframeoptions context parameter (web.xml/semarchy.xml) to configure iframe embeddability (X-Frame-Options)

  • MDM-290 - Web Service Administration is now attached to the Execution Engine Privilege, and the Notification Servers to the Data Location Privileges.

  • MDM-847 - Improved user feedback when using reserved names for attributes

  • MDM-870 - Support for Browser Multi-Tab

  • MDM-1126 - First Form/Table View created for an entity is called DefaultFormView/DefaultTableView by default

Bug Fixes

  • MDM-622 - Search/filter is not persisted when using the Back button on BO Views

  • MDM-743 - New option for default Data Import settings

  • MDM-746 - Data Import: Date and DateTime format preferences do not have default values

  • MDM-756 - New Warning in model validation if an integration job has a possible wrong order in tasks

  • MDM-796 - Sequences might not be ordered sequentially when using RAC

  • MDM-840 - [Address Enricher] OnDemand mode doesn’t work anymore

  • MDM-850 - In data import, if no PK is defined in the form view, the mapping is impossible

  • MDM-860 - Incorrect attributes order in attribute picker: foreign attribute is always listed at the end

  • MDM-863 - Setting an empty field separator in data import wizard hangs preview and allows the Next button

  • MDM-864 - Display types not used in record checkout tables view

  • MDM-866 - Refresh Button does not work on a BO View after it was modified in data entry

  • MDM-867 - Session ending do not redirected to the login screen on Internet Explorer

  • MDM-868 - Data Import Fails if the option The imported file contains an ID column is selected and the form view does not contain SourceID or the preferences reference obsolete attributes

  • MDM-873 - Incorrect ordering of the BO Views in the hierarchy of the data entry editor

  • MDM-874 - Data Entry raises a Not Yet Implemented exception when there is a unique key check marked as pre-consolidation

  • MDM-875 - LOVs contained in Complex Types do not appear according to the LOV Display Format Preference

  • MDM-1162 - Data export fails when a Form Attribute is an expression

  • MDM-1191 - HTTP Status 408 Error when accessing the login page

  • MDM-1192 - Checking out a record already checked out does not refresh the record from the hub

  • MDM-1196 - Duplicate Management Checkout filter expression editor warns when an unknown function is used

  • MDM-1198 - Link to a Grand-Parent FDN causes an Unhandled event loop exception

  • MDM-1275 - [Weblogic 12c] Data UI cannot be opened and Data Edition Web services cannot be started (Issue with JAXB)

  • MDM-1276 - [Weblogic 12c] Error 404 when accessing http://host:port/semarchy instead of http://host:port/semarchy/

  • MDM-1295 - Unable to the Email of a Role in the Administration Console

  • MDM-1317 - Incorrect definition for the entity Remove privilege indicated in the Administration Guide

  • MDM-1326 - NullPointerException and Action buttons disappear when clicking record with specific record level privileges defined

  • MDM-1329 - SQL Query Generation generates aliases containing reserved keywords

  • MDM-1330 - Data Import now handles files with a large number of columns detected due to incorrect separator definition

  • MDM-1331 - Embedded content in form views does not display correctly in Internet Explorer

  • MDM-1335 - Checking-out a cluster of objects containing a child with no privileges is enabled but causes an exception.

  • MDM-1383 - Export Menu appears even without export privilege on entity

Version 2.2.1

New Features

  • MDM-58 - Excel and CSV export limits can be configured from the Administration Console.

  • MDM-664 - Email Enricher now provides an Offline mode.

  • MDM-846 - Purge Scheduler wizard and editor: Schedule definition interface review.

  • MDM-1012 - Google Maps Plug-in now supports Client ID and Key.

  • MDM-1161 - DataSource Value Provider now supports JDBC datasource selection in a dropdown component.

  • MDM-1301 - New Microsoft Bing Maps plug-in for address enrichment

  • MDM-1340 - Enricher’s Active property label is renamed to Run in Jobs.

  • MDM-1377 - Editable state of the Source ID field is made more obvious in data entry forms.

  • MDM-1389 - Engine Administration: Ignore Failure action is renamed to Cancel Job.

  • MDM-1392 - Convergence for MDM is now certified on Glassfish 4.0.

  • MDM-1403 - Reviewed title and button labels for the Open Data Edition dialog.

  • MDM-1437 - Convergence for MDM is now certified on non-CDB Oracle 12c instances.

  • MDM-1438 - Convergence for MDM is now certified on Tomcat 8 and Wildfly 8. Dropped support for JBoss 5.x.

  • MDM-1455 - MDM Applications Logo can be customized from the Administration Console.

  • MDM-1467 - Date management is now consistently based on the application server time zone.

  • MDM-1477 - Workbench and Applications URLs changed to /semarchy/workbench and /semarchy/data.

  • MDM-1478 - Added a view action when browsing BO View records.

  • MDM-1479 - Added Start/End/Duration values to the Data Certification Queue page.

  • MDM-1480 - New Welcome Page for /semarchy.

Bug Fixes

  • MDM-710 - Overview page not correctly refreshed when a data location upgrade fails.

  • MDM-1343 - Data location upgrade now fails with an appropriate message if the model edition has validation errors.

  • MDM-1359 - Data location’s datasource selection drop-down misses certain datasources if some of them are invalid.

  • MDM-1369 - Activity task overview in the applications does not have enough space for activity diagram.

  • MDM-1404 - Cryptic warning message during checkout is now removed One or more records in the hierarchy to check out already exist in Data Entry publisher Product Hub Data Entry. If you proceed, those Data Entry records…

  • MDM-1426 - Missing Scrollbar on Home Page’s Navigate view.

  • MDM-1428 - In the data entry forms, the Save button is now disabled if errors prevent from saving the record.

  • MDM-1429 - In data entry forms, attributes with embedded content display type are displayed twice.

  • MDM-1434 - Client API method completionResult.getNewTask() returns null value.

  • MDM-1435 - Attribute with Image Display Type is not updated when using Previous/Next record if new record contains null image.

  • MDM-1456 - Character & disappears from labels coming from Model Design.

  • MDM-1462 - Paginated Queries are too slow due to wrong pagination query.

  • MDM-1468 - Import (Exact ID Matching/ID generated) fails with could not find row with ID xxx from hub when record exists only with non data entry publisher id in hub.

  • MDM-1471 - Missing Horizontal Scrollbars in Form Editor.

  • MDM-1472 - Data entry Enricher on Field Exit is not triggered when exiting a LOV field.

  • MDM-1482 - Exporting Documentation should raise an error for an invalid model.

  • MDM-1484 - REGEXP_SUBSTR Syntax misses subexpr parameter.

  • MDM-1486 - Multiple malfunctions with the Refresh button of the Validation report.

  • MDM-1487 - SemQL does not support CURRENT_TIMESTAMP() without precision.

Version 2.2.2

Known Issues

  • MDM-1463 - Geronimo 3.0.1 and WebSphere Liberty Profile 8.5 are not supported due to classloading incompatibility.

  • MDM-1393 - Data export (XLSX) opens in Excel 2010 with hidden columns. This problem is due to a JVM versions 1.7.0_21. To solve it, upgrade to a later JVM Version.

  • MDM-1386 - Fuzzy Matching Entities with a single attribute are not correctly handled by the integration process. These entities can be used for inheritance purposes.

Bug Fixes

  • MDM-1509 - The Welcome page raises a HTTP-500 error when a model is not valid.

  • MDM-1508 - Upgrading to version 2.2 generates invalid validation configuration errors on data entry workflows.

Version 2.2.3

Known Issues

  • MDM-1463 - Geronimo 3.0.1 and WebSphere Liberty Profile 8.5 are not supported due to classloading incompatibility.

  • MDM-1393 - Data export (XLSX) opens in Excel 2010 with hidden columns. This problem is due to a JVM versions 1.7.0_21. To solve it, upgrade to a later JVM Version.

  • MDM-1386 - Fuzzy Matching Entities with a single attribute are not correctly handled by the integration process. These entities can be used for inheritance purposes.

New Features

  • MDM-1597 - Field Level Consolidation performance improved when using the Preferred Publisher (with Skip Null options), Largest or Smallest Value consolidation strategies.

  • MDM-1577 - Google Maps Plugin Enricher uses the system proxy configuration specified with -Dhttp.proxy and -Dhttp.port.

  • MDM-1553 - Matching performance improvement for the Assigned SDPK to integration table for detected duplicates task.

Bug Fixes

  • MDM-1617 - NullPointerException when using the Google Maps Enricher with empty parameters.

  • MDM-1595 - Upgrading no longer automatically activates the Skip Nulls option in Field Level Consolidators using the Preferred Publisher strategy.

  • MDM-1582 - Business object views selection wizard on data entry task wizard looses the existing business object views order.

  • MDM-1545 - Model validation fails after an upgrade if workflows have been removed between model editions.

  • MDM-1530 - Model validation fails after an upgrade to version 2.2 when an entity is refereced several times from the same workflow.

  • MDM-1491 - IllegalArgumentException: Argument cannot be null error appears when accessing the Dashboard. This error occurs when an integration batch has no attached job log.

Version 2.2.4

Known Issues

  • MDM-1463 - Geronimo 3.0.1 and WebSphere Liberty Profile 8.5 are not supported due to classloading incompatibility.

  • MDM-1393 - Data export (XLSX) opens in Excel 2010 with hidden columns. This problem is due to a JVM versions 1.7.0_21. To solve it, upgrade to a later JVM Version.

  • MDM-1386 - Fuzzy Matching Entities with a single attribute are not correctly handled by the integration process. These entities can be used for inheritance purposes.

Bug Fixes

  • MDM-1992 - Data Applications appears as a blank page since Firefox 29 upgrade.

Version 3.0.0

Known Issues

  • MDM-2272 - Web services do not start on Glassfish and Weblogic application servers.

  • MDM-2201 - In Google Chrome 35+, scrolling a form view that contains an embedded content attribute scrolls the attribute but not the form.

  • MDM-2293 - Clicking log out for the current user context menu has no effect until the user clicks in the frame.

  • MDM-1925 - DataAccessPermissionDeniedException when accessing a business object view with a root filter using a non-authorized attribute.

  • MDM-2284 - The application window does not resize if the browser was resized during the loading phase. User must refresh the page.

  • MDM-2295 - ClassCastException when accessing the All Tasks with a user having limited privileges.

  • MDM-2267 - Visual representation of attributes in the grid at design-time do not have the expected height. Runtime remains unaffected.

  • MDM-2109 - Data export in the applications do not download any file if Firefox is configured with `Always ask me where to save files'

  • MDM-2266 - Display attributes validation messages always mention `form attributes' even for table attributes.

  • MDM-2307 - Source Errors, Post Consolidation Errors, Master Integration and Golden Integration Records view fails.

New Features

  • MDM-1664 - Data Certification Queue and Tasks List now display timestamps as well as dates.

  • MDM-1665 - Incorrect date values entered in forms now appear as data validation errors.

  • MDM-2034 - New Collapse All action to collapse all nodes in the application Home Page.

  • MDM-1024 - Plugin and SemQL validations support referenced attributes.

  • MDM-1553 - Matching performance improved for Fuzzy Matching entities.

  • MDM-1578 - SMTP Properties is available in the Notification Server configuration.

  • MDM-1613 - Open Application screen is simplified.

  • MDM-1581 - New getDataEditionIdOpenedOnDate platform web service returns the data edition ID opened at a given date.

  • MDM-1533 - GetDataEditionInfos platform web service now returns the data edition creation and update date

  • MDM-1027 - Plugin and SemQL enrichers support referenced attributes.

  • MDM-994 - Purge job log now purges deprecated job definitions in a data location.

  • MDM-2125 - New log4j.logger.com.semarchy.platform.engine.PluginExecution logger to troubleshoot plugin execution.

  • MDM-2177 - New Formatted Address output for the Google Maps enricher returns a human readable address.

  • MDM-1556 - Checkout operation in the duplicate management workflows is optimized to handle large volumes.

  • MDM-1562 - Load ID and Activity ID are now displayed in the Data Certification Queue.

  • MDM-1550 - Duration is now displayed in the Data Certification Queue.

  • MDM-1040 - Business Object View transitions now support a default sort configuration defined at design-time.

  • MDM-1348 - Enrichers now support the :V_USERNAME built-in variable.

  • MDM-1290 - Reference Pickers now support filters on the selectable records.

  • MDM-1614 - Access to Applications’ features (entity, dashboard, lineage, certification queue) can be limited by role.

  • MDM-2182 - Google Maps enricher now supports Throttle Request to remain below rate quota.

  • MDM-1634 - Data Navigation view supports multi-column sort by clicking on the column header.

  • MDM-2056 - NDV algorithm supported for statistics gathering on Oracle versions 11g and above in the certification job.

  • MDM-1193 - Matching Expression is renamed to Matching Condition.

  • MDM-1355 - New action to suspend (kill) a job running in the Engine.

  • MDM-1519 - Update Purge Job action is moved from the root data branch node to the Update Model Edition wizard.

  • MDM-1939 - Form views are rewritten with a new design.

  • MDM-2038 - Embedded metrics dashboards are added to the application. Powered by Convergence Pulse.

  • MDM-2181 - Google Maps enricher now expose a response status output.

  • MDM-1805 - Business Object transition definition now include customized Plural Label in addition to the (Singular) Label.

  • MDM-1323 - Deleting a data location now allows deleting all the objects in the data location schema.

  • MDM-1384 - New model validation raises an error when the integration job specified in a workflow does not process all the entities managed in this workflow.

  • MDM-1808 - Field Level Consolidators using a Custom Ranking strategy now support a Skip Null option to skip null values and pick the highest-ranking not null value.

  • MDM-1858 - New Person Name enricher to extract the given name, surname and gender from a person’s full name.

  • MDM-1414 - New OpenStreetMap enricher plugin for address enrichment

  • MDM-1598 - Text enricher now supports double metaphone synonyms as a secondary text output.

  • MDM-2028 - Email Enricher’s Valid Domain and Valid Input Domain now return null instead of N/A for domains that are unchecked.

  • MDM-1926 - New Processing Mode for email enrichers to use an in-memory-only domain cache.

  • MDM-1857 - Phone Enricher supports better localization of phone numbers and detailed return codes and messages explaining phone processing. Support for time zones and carrier detection from phone numbers.

  • MDM-2235 - Autofill feature is made smarter to support acronyms

Bug Fixes

  • MDM-1508 - Upgrading from version 2.1 to version 2.2 generates incorrect validation configurations in data entry workflows.

  • MDM-2079 - UniqueKey validation raises SQL error when key includes a FK to a SDPK entity

  • MDM-1201 - Incorrect Mixed Content Warning error in IE8 with HTTPS configuration since 2.1 upgrade.

  • MDM-1242 - Unclear SQL error raised if data imported in a Decimal field does not fit in size.

  • MDM-1346 - DataAccess API: IDataRow.getValue() returns " for FDN_* view attributes when no foreign record exists.

  • MDM-2146 - Could not open the editor: Invalid SemQL Query Error while parsing expression MastersCount when using Masters Count to order data.

  • MDM-1985 - Task list editor does not take into account the Page Size configuration.

  • MDM-1787 - Missing Parenthesis error when filtering/searching in a Business Object View based on a Business object that has a root filter.

  • MDM-1788 - Entities with a display name containing a foreign attribute appear with the display name altered in forms for checked-out records.

  • MDM-1657 - Newly created editor master records not appearing when clicking refresh on the golden record editor, even after the certification job is complete.

  • MDM-1992 - Details panel goes blank with Firefox 29.

  • MDM-1828 - Enrichers triggered in workflows do not run in the same order as in the certification process.

  • MDM-1670 - An Invalid SemQL Query exception is raised when opening a duplicate management workflow if the user has full read privileges but limited export privileges.

  • MDM-1669 - Model variables are not really available in enrichers and validations.

  • MDM-1792 - An error is raised when using the :V_USERNAME built-in variable in a filter in a duplicate management workflow.

  • MDM-1491 - IllegalArgumentException: Argument cannot be null raised when accessing the Dashboard and an integration batch has related no related job.

  • MDM-1595 - Upgrade process incorrectly enables the Skip Null option on the preferred publisher field-level consolidator.

  • MDM-1597 - Field-level consolidation performance improvement when using Preferred Publisher with Skip Nulls, Largest or Smallest Value.

  • MDM-1616 - My Tasks list does not show the activity label.

  • MDM-1516 - Inherited entities should not raise a warning on Display name when their parent provides the display name.

  • MDM-1515 - Inherited entities should not raise attribute group warnings when their parent has an attribute group.

  • MDM-1521 - GetDataEditionInfos platform web service raises a metadata property name not found error when filtering by data location name.

  • MDM-1549 - Excessive memory consumption from data access web services

  • MDM-1497 - Documentation indicates non-existing Submit/Cancel Activity WS operations

  • MDM-2049 - Phone Enricher should return the original value if parsing fails

  • MDM-1617 - NullPointerException when using the Google Maps enricher with null parameters.

  • MDM-1558 - Child Records section in data browsing editor is too tall when the page size is large.

  • MDM-1561 - Columns selected in the Data Certification Queue are not saved in the user preferences.

  • MDM-1560 - Data page size should reflect immediately after a refresh.

  • MDM-1577 - Google Maps enricher does not correctly support proxies.

  • MDM-2105 - org.eclipse.swt.SWTException: Graphic is disposed error when opening a diagram in the workbench.

  • MDM-1798 - Google Maps enricher should keep HTTP connection to process several records and use HTTP keep-alive.

  • MDM-2157 - Google Maps enricher should define only Address Line as mandatory

  • MDM-2172 - NULL values should sort first or last

  • MDM-1559 - Child Records section does not move correctly when form sections above it are collapsed

  • MDM-1661 - PK_MTA_ENTITY violated error appears when saving a changed entity after an upgrade to version 2.1 or 2.2.

  • MDM-1797 - Data import reports missing privileges on attributes that are not mapped for the import.

  • MDM-2103 - Check box height in forms is inconsistent between viewing and editing mode.

  • MDM-2108 - Consolidation query fails with exception when involving LongText attributes in complex Type.

  • MDM-1582 - Business Object View order is lost when opening the business object view selection in a data entry task wizard.

  • MDM-1554 - Schema Update Fails on Indexes with NoSuchTableException when schema contains SYS_XXX index.

  • MDM-2139 - Mandatory attribute Error while editing a record that contains a value for the mandatory attribute.

  • MDM-793 - Database is queried twice when opening a table view in an MDM application.

  • MDM-733 - Inconsistent management of update date and updator between data entry workflows and integration jobs.

  • MDM-1530 - Model Validation fail with a Duplicate Key Value error after an upgrade to version 2.2.

  • MDM-1509 - HTTP 500 appears on the welcome page when the model is not valid.

  • MDM-1703 - When the data entry generated WSDL contains accents in attributes descriptions or labels, it cannot be parsed and raises a Malformed UTF-8 Character error.

  • MDM-2036 - Text enricher should provide explicit exceptions when the configuration is incorrect.

  • MDM-1977 - NullPointerException when using the Convergence Text enricher with null parameters.

  • MDM-1628 - Google Maps enricher does not return bounding box coordinates for US addresses.

  • MDM-1463 - Geronimo 3.0.1 and WebSphere Liberty Profile 8.5 are not supported due to classloading incompatibility.

  • MDM-1489 - SemQL functions updated to include Oracle 12c compatible functions.

  • MDM-1539 - WLS 11g is no longer supported by Convergence for MDM.

Version 3.0.1

Known Issues

  • MDM-1925 - DataAccessPermissionDeniedException when accessing a business object view with a root filter using a non-authorized attribute.

  • MDM-2109 - Data export in the applications do not download any file if Firefox is configured with `Always ask me where to save files'.

  • MDM-2201 - In Google Chrome 35+, scrolling a form view that contains an embedded content attribute scrolls the attribute but not the form.

  • MDM-2284 - The application window does not resize if the browser was resized during the loading phase. User must refresh the page.

  • MDM-2295 - ClassCastException when accessing the All Tasks with a user having limited privileges.

  • MDM-2311 - User is stuck on the login page after preferences import.

  • MDM-2323 - Create New button incorrectly inactivated when browsing the lineage records

  • MDM-2324 - Form filter value picker does not work in Data Entry Browsing

  • MDM-2334 - SMTP notification server issue after migrating from 2.2 to 3.0

  • MDM-2339 - Client Error when switching between Convergence for MDM versions on same server/same browser session

  • MDM-2366 - Attribute values picker does not work in data search if row level security uses model variables.

  • MDM-2365 - Data export action is available but export fails if the export is not allowed by security privileges.

  • MDM-2361 - Starting a data service on a data location pointing to an undefined datasource does not raise a clear error.

New Features

  • MDM-1959 - Task comments are displayed in the tasks/activities list.

  • MDM-1699 - Tomcat Role Mapper is now available in the release.

  • MDM-2288 - Full Text Search automatically adds % wildcards around the search term.

  • MDM-2321 - Embedded Pulse Dashboards now support horizontal bars

  • MDM-1090 - Support for Edit/Checkout actions while browsing Rejects/Errors (SE,GE)

  • MDM-2317 - Task Overview and History options added to the toolbar of My Tasks.

  • MDM-2237 - Complete and Unclaim button are merged in the toolbar of My Tasks.

  • MDM-1804 - Support for Mixed Authentication. The SingleSignOn parameter in the Context.xml file allows configuring this authentication.

Bug Fixes

  • MDM-2315 - ActivityService WS : StartActivity response does not comply with WSDL

  • MDM-2341 - Data Edition is unavailable error after a v3.0 upgrade. This issue is due to a silent validation that prevents the underlying model to be upgraded. To fix this issue, set the following system property on the server startup comment prior to the upgrade: -Dcom.semarchy.mdm.logical.boentity.includeUnreachableBOEntities=true.

  • MDM-2312 - Workbench crashes with the following error on a server launched in German: SCHWERWIEGEND: Servlet.service() for servlet [equinoxbridgeservlet] in context with path [/semarchy].

  • MDM-2293 - Clicking Log Out for the current user context menu has no effect until the user clicks in the frame.

  • MDM-2313 - Matcher on ID Matching entity raises exceptions when Binning uses Complex Types

  • MDM-1683 - Pulse Profiling should skip unsupported datatypes (rowid, lob, raw, xml, etc).

  • MDM-2316 - Popup dialog never display for a long text type in a table view.

  • MDM-2309 - Create actions are enabled even if user does not have the create privilege

  • MDM-2320 - java.lang.reflect.UndeclaredThrowableException error when selecting a referenced attribute in data entry.

  • MDM-2307 - Access to Source and Post Consolidation Errors view, Master and Golden Integration Records view fails

  • MDM-2325 - Unable to edit a Variable Value Provider configuration

  • MDM-2344 - Edit Action not available for record matching row level security filter

  • MDM-2266 - Display attribute validation messages always mention form attributes even for table attributes.

  • MDM-2267 - Visual representation of attributes in the grid at design-time do not have the expected height. Runtime remains unaffected.

  • MDM-2272 - Web services do not start on Glassfish and Weblogic application servers.

  • MDM-2277 - Data Navigation: Customized Sort is ignored unless user defined sort is disabled

  • MDM-2161 - When creating a child record, the reference is not automatically set to the parent.

  • MDM-2351 - Error when browsing a BOView that uses an abstract (used for inheritance only) ParentEntityEO as root

  • MDM-2354 - NoSuchViewAttributeException when defining a Reference Filter on a Reference FormAttribute containing trailing spaces

Version 3.0.2

Known Issues

  • MDM-2109 - Data export in the applications do not download any file if Firefox is configured with `Always ask me where to save files'.

  • MDM-2201 - In Google Chrome 35+, scrolling a form view that contains an embedded content attribute scrolls the attribute but not the form. This issue is due to Chrome Issue #401047

  • MDM-2284 - The application window does not resize if the browser was resized during the loading phase. User must refresh the page.

  • MDM-2295 - ClassCastException when accessing the All Tasks with a user having limited privileges.

  • MDM-2339 - Client Error when switching between Convergence for MDM versions on same server/same browser session

  • MDM-2361 - Starting a data service on a data location pointing to an undefined datasource does not raise a clear error.

  • MDM-2366 - Attribute values picker does not work in data search if row level security uses model variables.

New Features

  • MDM-1506 - Batches with no Job Logs have a nicer rendering in Certification queue

  • MDM-1633 - Sort indicator is now displayed on column headers in table views

  • MDM-1647 - Deleting, editing, multiple-selection and renaming is now supported for duplicate management workflows checkout filters.

  • MDM-1829 - Certification Queue display the user who submitted the load in a new Batch Creator column

  • MDM-1874 - Sibling navigation is now supported when viewing child records in tables

  • MDM-2024 - Better default names suggested when renaming quick filters

  • MDM-2025 - The first page of the duplicate management workflows checkout wizard is now merged in the second page (filter selection and definition).

  • MDM-2077 - Plug-in deployment: The session no longer need to restart and a Diagnose button is available to troubleshoot plug-in installation

  • MDM-2121 - The display of IDs while browsing and editing in Data Entry workflow is more consistent

  • MDM-2187 - The terminology for the privileges is simplified. Privileges types are re-named to None, Read and Read/Write.

  • MDM-2308 - Editor title now indicates the type of view when browsing non-golden records (Master, Source, etc.)

  • MDM-2386 - Specific icons and tooltips to differentiate next/previous page from next/previous record actions.

  • MDM-2392 - New application server certified: Jetty 9.x

  • MDM-2398 - Default configuration files (context.xml and semarchy.xml) include a Convergence Pulse datasource configuration example

  • MDM-872 - SemQL validators support more attributes when a validation is pre or post-consolidation only. This includes LoadID, FID_xxx, BatchID, PublisherID and SourceID.

Bug Fixes

  • MDM-1298 - 403 error page is not displayed when user is not authorized on WebLogic 12c

  • MDM-1514 - Preferred Source is renamed Preferred Publisher for terminology consistency

  • MDM-1607 - Clearer error message indicating privilege requirements for duplicate management workflows

  • MDM-1663 - Client Error Flashing on Logout

  • MDM-1711 - java.lang.IllegalStateException: HttpSession is invalid exception after logout with WebLogic 12c

  • MDM-1925 - Business object using in the root filter attributes with no read privilege are automatically masked to the user instead of having a Read Privilege on xxx is denied error.

  • MDM-2173 - Imprecise outputs from Google Maps (street_address, intersection, airport) are marked as deprecated in the plug-in. A new AddressTypes output list the address types returned by the service.

  • MDM-2311 - User is stuck at the login page after importing preference from another environment.

  • MDM-2323 - Create New button incorrectly inactivated when browsing the lineage records

  • MDM-2324 - Value pickers for filters By Form do not work in data entry workflows

  • MDM-2334 - SMTP notification server fails with mail.transport.protocol property is not set error after an upgrade from 2.2 to 3.0

  • MDM-2365 - Data export action is available but export fails if the export is not allowed by security privileges.

  • MDM-2370 - Record creation fails in data entry workflows with a Query returned 0 rows when 1 was expected error when row level security is used

  • MDM-2397 - Create new record button is available but raises a Data Edition is not in OPEN status error in a closed data edition

  • MDM-2400 - CSV Data Export now includes a validation for the date format pattern.

  • MDM-2402 - Duplicate management button is available but raises a Data Edition is not in OPEN status error in a closed data edition

  • MDM-2403 - SWTException: widget is disposed when selecting data from a reference picker

  • MDM-2404 - FIDs are no longer present in source error views

Version 3.0.3

Known Issues

  • MDM-2109 - Data export in the applications do not download any file if Firefox is configured with `Always ask me where to save files'.

  • MDM-2201 - In Google Chrome 35+, scrolling a form view that contains an embedded content attribute scrolls the attribute but not the form. This issue is due to Chrome Issue #401047

  • MDM-2284 - The application window does not resize if the browser was resized during the loading phase. User must refresh the page.

  • MDM-2295 - ClassCastException when accessing the All Tasks with a user having limited privileges.

  • MDM-2339 - Client Error when switching between Convergence for MDM versions on same server/same browser session

  • MDM-2361 - Starting a data service on a data location pointing to an undefined datasource does not raise a clear error.

  • MDM-2366 - Attribute values picker does not work in data search if row level security uses model variables.

  • MDM-2444 - Incorrect warning Malformed SemQL Attribute Qualified Name. …​ on an advanced search when no attribute is selected.

  • MDM-2480 - Form fields much too small in the Filter By Form dialog.

  • MDM-2515 - "ORA-22813: operand value exceeds system limits" error in the certification job when loading the hub with certain Oracle 11g versions configured with NLS_LENGTH_SEMANTICS = CHAR.

  • MDM-2516 - "Update On" timestamp is incorrectly set after an edit.

New Features

  • MDM-2531 - Reference picker dialog is now resizable and have maximize button.

Bug Fixes

  • MDM-2453 - When using a JDK 8, opening a business object view in an application causes a stack overflow exception.

  • MDM-2478 - Internal Error 500 when running the demonstration platform with a JDK 8: login page compilation fails.

  • MDM-2487 - Embedded Content display type is not available for Text datatypes.

  • MDM-2494 - Reference Form Attributes incorrectly wrap in form views.

  • MDM-2502 - Data export (XLSX) opens in Excel 2010 with certain columns hidden.

  • MDM-2507 - Form View used for data entry only display writable attributes.

  • MDM-2508 - NullPointerException when using SemQL search expression ANY (

  • MDM-2510 - In form views, enrichers using expressions not displayed in the form fail with property 'xxx' is not readable error.

  • MDM-2511 - Importing a tab-delimited file results in an exception.

  • MDM-2512 - HTTP 404 error appear when the browser lost the connection to the server. Lost connections are now redirected to the login page.

  • MDM-2530 - Inherited validators and enrichers do not appear in the workflow configuration.

  • MDM-2539 - CSV export results in "Illegal Pattern" error and empty export file when an incorrect data pattern is used.

  • MDM-2541 - Notify assignee is now disabled when claim task is checked. Claim Task and Notify assignee checkboxes are now hidden when the transition goes to submit or cancel.

  • MDM-2542 - Workflow Notifications notifies the user when claim task is checked instead of notifying when notify assignee is checked.

  • MDM-2543 - Multi-valued LOV selection dialog does not display code, label and description as expected.

  • MDM-2546 - The "Content Popup" display type used in a data entry form now displays a link to view the content in a popup as expected. The More button allows for editing the content.

  • MDM-2547 - Export does not respect the LOV format selected in the export dialog.

Version 3.0.4

Known Issues

  • MDM-2109 - Data export in the applications do not download any file if Firefox is configured with 'Always ask me where to save files'.

  • MDM-2284 - The application window does not resize if the browser was resized during the loading phase. User must refresh the page.

  • MDM-2295 - ClassCastException when accessing the "All Tasks" with a user having limited privileges.

  • MDM-2339 - Client Error when switching between Convergence for MDM versions on same server/same browser session

  • MDM-2361 - Starting a data service on a data location pointing to an undefined datasource does not raise a clear error.

  • MDM-2366 - Attribute values picker does not work in data search if row level security uses model variables.

  • MDM-2444 - Incorrect warning "Malformed SemQL Attribute Qualified Name. …​" on an advanced search when no attribute is selected.

  • MDM-2480 - Form fields much too small in the Filter By Form dialog.

  • MDM-2515 - "ORA-22813: operand value exceeds system limits" error in the certification job when loading the hub with certain Oracle 11g versions configured with NLS_LENGTH_SEMANTICS = CHAR.

  • MDM-2516 - "Update On" timestamp is incorrectly set after an edit.

Bug Fixes

  • MDM-2575 - IE8 crashes when clicking the Overview tab in the workbench

  • MDM-2624 - Person Name enricher is not present in packaged version 3.0.x.

  • MDM-2651 - Move to Existing Golden action does not limit the selectable golden to those in the current workflow.

  • MDM-2652 - Error when changing the page size in certain conditions?

  • MDM-2659 - CSV import with a client in French locale requires double file selection due to an incorrect date pattern.

  • MDM-2662 - Reference Picker does not display validation errors. It shown an empty field when an unresolved ID is typed in.

  • MDM-2664 - Reference Display Name containing a FDN unexpectedly displays the FID in data entry.

  • MDM-2666 - Number formatting is not used by navigation table for numbers with decimal places

  • MDM-2669 - Create New action in data entry workflows creates the record under the previously selected parent record if the parent record is not explicitly selected.

  • MDM-2671 - Form attribute Date display type behaves as Text display type

  • MDM-2672 - Form Field Help Popup should be shown on Mouse click not mouse up

  • MDM-2675 - Incorrect Encoding the Workflow Notification Email

Version 3.1.0

Known Issues

New Features

  • MDM-0259 - Engine now uses plug-in parameters' types.

  • MDM-0260 - Engine now takes into account plug-ins mandatory parameters, inputs and outputs.

  • MDM-1013 - Design-time object duplication for Form Views, Tables Views, Business Objects, Business Object Views and Workflows.

  • MDM-1018 - New display property to configure the display mode (code, label, both or user-defined) for list of values in form and table views.

  • MDM-1088 - Mass-update in data entry.

  • MDM-1077 - Plugins Parallel Processing

  • MDM-1382 - Design-time workflow duplication.

  • MDM-1520 - Integration web services for publishing data batches.

  • MDM-1590 - Web services MTOM can be disabled for the entire platform using the "com.semarchy.mdm.ws.mtomEnabled" Boolean system property.

  • MDM-1624 - The activity initiator or administrator can update the label, priority and startup comment of a running activity.

  • MDM-1658 - Record Checkout and Record Creation privileges are now separated.

  • MDM-1708 - Plug-in architecture for notifications sent upon batch terminations. Built-in plug-ins for JMS, File, HTTP and Email.

  • MDM-1709 - Pulse Metrics configuration and runtime is integrated in Convergence for MDM

  • MDM-1971 - Detailed repository information is available from the "About" dialog.

  • MDM-1972 - Repositories can be named with installing the repository. Repository name appears in the upgrade process and in the repository information dialog.

  • MDM-2126 - Error behavior for plug-ins can be configured with a number of retry and a behavior on error.

  • MDM-2200 - An optional role can be defined on business object views to define the privilege to see this business object view.

  • MDM-2216 - Tomcat version used for the evaluation environment is upgraded from version 7.0 to 8.0.

  • MDM-2250 - Mixing Golden and Master data filters in duplicate management.

  • MDM-2259 - A default record-level consolidator is created when creating a new entity. Switching from a record-level to a field-level consolidator and vice-versa is now possible.

  • MDM-2331 - List of activities and tasks support multiple selection and clickvertizing.

  • MDM-2332 - Recent activities with jobs completed in error or warning now appear on the home page.

  • MDM-2345 - Tomcat Role mapping is documented.

  • MDM-2346 - Advanced security documentation to configure role mapping, OpenID, mixed authentication and SSO.

  • MDM-2350 - Form and table view editors' title show the name of the entity.

  • MDM-2363 - The semarchyAdmin built-in role no longer has full access to models' data. A privilege grant must be created for this role.

  • MDM-2377 - Select Page and Select All options for selecting and managing large data sets.

  • MDM-2390 - Java 6 is no longer supported for the Convergence for MDM application.

  • MDM-2407 - Activity task comment can be modified while processing the task.

  • MDM-2427 - Filters can be toggled from the Search menu item.

  • MDM-2430 - Multithread support for the Convergence email enricher and validator

  • MDM-2431 - Multithread support for the Google Maps Enricher

  • MDM-2432 - Multithread support for the Convergence Person Name Enricher

  • MDM-2441 - Support multiple transitions from Task_A to Task_B

  • MDM-2460 - "Suggest Mappings" is automatically triggered when mapping imported file fields.

  • MDM-2461 - New "ShowURL" display property enables hiding the URL for attributes using the "Embedded URL" display type.

  • MDM-2470 - "About Menu" is reorganized in a more meaningful way.

  • MDM-2471 - Unclutter the Upgrade Window

  • MDM-2490 - New Read-Only option to make form attributes un-editable in data entry.

  • MDM-2495 - A progress bar now shows the data export progress.

  • MDM-2496 - Import and export wizards expose a better way to select the field separator.

  • MDM-2506 - New System Information dialog displays important environment and system information.

  • MDM-2517 - Data edition dialog sets the focus to the first editable field when opening a record for edition.

  • MDM-2525 - Reference picker dialog in data entry can be resized and maximized.

  • MDM-2552 - Multi-valued LOV editor automatically hides the "Description" column is no description exists for the list of values.

  • MDM-2562 - Getting started tutorial now includes Pulse Metrics

  • MDM-2592 - New NumberFormat display property to define a pattern for displaying numeric values.

  • MDM-2628 - Plug-in SDK supports a plug-in execution layer (rowTransformerExecutor, rovValidatorExecutor).

  • MDM-2628 - New CompactMode display properties enables removing the "Clear" end "…​" (More) buttons on attributes for more compact forms.

  • MDM-2646 - Platform upgrade: The System Requirements for Browsers are updated. Refer to the Convergence for MDM Installation Guide for more details.

  • MDM-2647 - PurgeDataBranch web service now raises an error is invoked with an invalid data location or branch instead of indicating "Zero Rows Deleted".

  • MDM-2655 - Google Maps enricher now supports defining the language for the output address.

  • MDM-2665 - Quick Search now automatically targets the currently opened business object view.

  • MDM-2680 - New activity lists and editors to easily track the status and progress of the data management workflows.

  • MDM-2682 - Data Paging is now supported for activity lists.

  • MDM-2683 - Customizable page size for activity lists.

  • MDM-2691 - Select and open multiple activities is supported.

  • MDM-2692 - Rich table for the activity lists.

  • MDM-2693 - Table attributes using the Text display type now support the Alignment display properties

  • MDM-2699 - Manage activities (claim, unclaim, complete) from the activity list.

  • MDM-2700 - Multi-value LOV dialog now shows selected values fist in the list.

  • MDM-2701 - Single-click support in the activity list.

  • MDM-2705 - Customizable definition of "Recent" for activities displayed on the Home Page.

  • MDM-2706 - SemQL now support function names with 2 qualifiers: <schema name>.<package name>.<function name>

  • MDM-2708 - Ability to open and view activities claimed by others.

  • MDM-2715 - New LovSortMode defines a list of values attribute sort order, by code or label.

  • MDM-2722 - New workflows: the first task is named after the workflow, the alignment of the graphical symbols is fixed and the first task name is configured to show the label only.

  • MDM-2723 - Search dialog now always displays a <Quick Search> entry.

  • MDM-2724 - Better user feedback when a filter is applied. Icon change and "Filtered" indication added on the record count.

  • MDM-2759 - Tooltips on the display type properties.

  • MDM-2766 - Reorganized packaging for Convergence for MDM.

  • MDM-2787 - Add Table/Form Attribute options disappear from the tree view context menu, as specific editors are used to create the Table and Form Views.

  • MDM-2797 - JBoss 6 is no longer supported.

  • MDM-2826 - The activity name is used in the title of the data entry activity startup dialog.

  • MDM-2856 - Error indicator now extend to the entire height of multi-line fields.

  • MDM-2862 - Activities are no longer visible when connecting to a closed data edition.

  • MDM-2875 - "Open Model Edition" dialog now shows models in alphabetical order.

  • MDM-2902 - Indicator in the activity list of the currently applied filter.

  • MDM-2926 - Better handling of activities attached to non-existing/renamed workflows or tasks.

  • MDM-2955 - Add the TRIM function to the SemQL vocabulary

Bug Fixes

  • MDM-2201 - Embedded Content becomes unreadable when scrolling with Chrome 35+ and Opera 22+. This issue if fixed in later versions of these browsers.

  • MDM-2295 - Unexpected error when a user opens a data entry task for which he has no entity read privilege grant.

  • MDM-2366 - Value pickers in the search "by form" or "Advanced" do not work when using row-level security with model variables.

  • MDM-2405 - An existing default filter is always applied in the navigation even when it is not active.

  • MDM-2410 - A single-click on a filter name makes its name editable.

  • MDM-2424 - Enrichment of an attribute that is not visible on the data entry form fails with a "property xxx is not readable" error.

  • MDM-2425 - Clicking the "Previous" button after using "Save and Create Next" moves to two records back.

  • MDM-2438 - NullPointerException when using "ANY (" in a SemQL search expression.

  • MDM-2444 - Cryptic error message when no attribute is selected in the "Advanced" search

  • MDM-2448 - Trying to edit a record in the source error view of a fuzzy matching entity causes a "Failed argument condition: view parameter must have a Golden Id" error.

  • MDM-2450 - Opening a business object view in an application raises a "java.lang.StackOverflowError" if Convergence for MDM is deployed with a JDK 8.

  • MDM-2455 - CSV export results in an "Illegal Pattern Character" exception and an empty export file if the date format pattern is incorrect.

  • MDM-2468 - Data entry form view only displays writable attributes.

  • MDM-2483 - The "Embedded Content" display type is not available for the "Text" and "Long Text" datatypes.

  • MDM-2486 - "Embedded Content Popup" display type should display a "View Content" link instead of the content in editable mode.

  • MDM-2492 - HTTP-404 error when the browser lost the connection to the application server.

  • MDM-2493 - Importing a tab delimited file fails with a NullPointerException.

  • MDM-2515 - SEM_F_SPLIT function calls fail with ORA-22813 on some oracle 11g instances with CHAR semantics.

  • MDM-2518 - Editing multi-valued LOV does not support displaying code and label.

  • MDM-2519 - Records export do not respect the format selected for list of values.

  • MDM-2520 - Workflow notification notify assignee when the "Claim Task" option is checked.

  • MDM-2521 - "Complete Tasks" dialog: "Notify Assignee" is unchecked when "Claim Task" is checked, and "Claim Task" as well as "Notify Assignee" are hidden when submitting or canceling.

  • MDM-2524 - Inherited validators/enrichers do not appear in the workflow tasks/transition configuration.

  • MDM-2568 - "Create New" creates the child record attached to the previously selected parent record.

  • MDM-2573 - Deploying a column size change fails when increasing number of decimals

  • MDM-2579 - The display name for a reference unexpectedly displays the Foreign ID in data entry.

  • MDM-2593 - Formatting for numbers with decimal places in table views is not consistent with formatting in form views.

  • MDM-2594 - Form attributes with a "Date" display type appear as "Text" display type.

  • MDM-2602 - Workflow Validation should prevent two transitions from the same task with the same name.

  • MDM-2619 - "Move to Existing Golden" shows target golden records from previous transactions.

  • MDM-2642 - Reference picker in data entry does not show the error indicator when an incorrect reference ID is typed in.

  • MDM-2643 - CSV Import with a client in French locale raises a date pattern exception and forces the user to select twice the file.

  • MDM-2648 - PurgeDataBranch web service no longer works after an engine restart.

  • MDM-2650 - In certain conditions, changing the page size causes an "Error Notifying a Preference Change Logger: Widget is disposed" message.

  • MDM-2657 - Form attribute help popup should appear when clicking and not when releasing the mouse button.

  • MDM-2670 - Random "Widget is disposed" exception when canceling or closing the "Start Workflow" dialog.

  • MDM-2681 - Built-in attribute localization should follow the client locale and not the model translation.

  • MDM-2685 - The Microsoft Bing enricher returns empty results for known addresses when rate limit is reached.

  • MDM-2695 - "Duplicate Key <enricher name>"" error when deploying a model with a workflow that uses a parent and a child entity with homonymous enrichers.

  • MDM-2697 - SemQL editor for Reference Picker filter on business object views should not display FDN and FID attributes related to the reference being customized.

  • MDM-2704 - Pulse Dashbnoard fails to display on Internet Explorer 9 with a "Client Error".

  • MDM-2768 - User-defined sort is not saved if it uses a table attribute consisting of a SemQL expression using commas.

  • MDM-2770 - Inaccurate message for un-displayable Binary Content in data entry.

  • MDM-2773 - An incorrect files uploaded in data entry for the "Image" display type causes an exception.

  • MDM-2781 - Grid layout editor shows performance issues for large forms.

  • MDM-2789 - When a potential duplicate is detected for an ID matching entity, the "Check out and Edit" option re-opens the current record and not the selected duplicate.

  • MDM-2808 - Reference ID input field do not take the focus correctly on first click with Internet Explorer 11.

  • MDM-2845 - ArithmeticException: Overflow while deploying a new model edition with large sequence values.

  • MDM-2855 - Deployed Model Edition partially created if data location contains function based index.

  • MDM-2906 - Random session crash when editing data in the applications.

  • MDM-2960 - Items in the administration console are ordered alphabetically.

  • MDM-2973 - Data Entry Form Views ignore the Reference Browsing options.

  • MDM-2974 - Phone & Email plugin validators should not consider null phones/emails as invalid.

  • MDM-2978 - When refreshing editor in data entry, the treeview collapses.

  • MDM-2979 - Unable to import a model export bigger than 10Mb. The new import limit is 20Mb. A com.semarchy.mdm.maxImportSize system property enables users to set this limit.

Version 3.1.1

Known Issues

  • MDM-3054 - The Batch Poller does not start with a newly created repository.

  • MDM-3069 - Impossible to open a model edition when a model has several branch.

Bug Fixes

  • MDM-2998 - Opening a data application on an open model edition takes too long

  • MDM-3018 - Customizing FDN Display name in a Form View generates a "property XXX is not readable" at runtime

  • MDM-3030 - Web services configured in auto-restart do not restart when the application server restarts

Version 3.1.2

Bug Fixes

  • MDM-3054 - The Batch Poller does not start with a newly created repository.

  • MDM-3069 - Impossible to open a model edition when a model has several branch.

Version 3.1.3

Bug Fixes

  • MDM-2948 - Java.lang.IllegalArgumentException when testing a Notification configuration.

  • MDM-3072 - StackOverflow when enabling a quick filter after browsing through a reference.

  • MDM-3082 - Workflow notifications fail.

  • MDM-3084 - ConcurrentModificationException error when the engine sends notifications.

  • MDM-3112 - The Thread Pool Size defined for the plugins enrichers and validators is ignored by the jobs running in the engine.

  • MDM-3151 - SemQL parsing fails with "Unexpected error while rewriting AST" when using a CASE WHEN syntax.

  • MDM-3168 - The log4j JMS Appender fails with a javax.naming.NoInitialContextException exception.

Version 3.1.4

Bug Fixes

  • MDM-3328 - Closed model editions containing form views with an empty grid layout become invalid after an upgrade to version 3.1.

  • MDM-3327 - Field size is not checked correctly for Primary Keys of type String. This may cause unhandled event loop exceptions when editing the field.

  • MDM-3325 - Keyboard tab order seems random in grid layout form views.

  • MDM-3324 - Element defaultPublisherId is incorrectly specified with data type long in the DataEditionIntegrationService WSDL.

  • MDM-3322 - SemQL and plugin post-consolidation validations validate all records and not only those of the current batch, causing performance issues.

Version 3.2.0

Known Issues

  • MDM-3645 - Convergence for MDM application does not start on Weblogic Application Server 12C. This issue is due to a Weblogic bug.

New Features

  • MDM-1087 - Multiple Match Rules with Automatic Validation and Scoring

  • MDM-1328 - The Claim Task option is checked by default in activities transitions

  • MDM-1688 - Pulse schemas upgrade like data locations and repository

  • MDM-1791 - Configurable match condition to rematch on previous group

  • MDM-1947 - Use a non-blocking dialog when deploying a model edition to a data location

  • MDM-1960 - Support MastersCount in the Duplicate management workflows forms, tables, and filters

  • MDM-1961 - Support "Remove" action with select all in data entry workflows

  • MDM-1963 - Identify group change in duplicate management workflows

  • MDM-1966 - Support attributes from referenced entities in duplicate management workflow tables

  • MDM-1980 - Support lineage relationship in SemQL Expressions and Conditions

  • MDM-2067 - Use literal values instead of SQL binding for some variables of the integration job

  • MDM-2138 - Browse duplicate management workflow content grouped by Current Golden

  • MDM-2159 - Dashboard should support properly measure with zero metrics

  • MDM-2199 - Port the Pulse "Workflow - Duration" dashboard in the MDM Application

  • MDM-2020 - Add filtering and Select All option in duplicate management workflows

  • MDM-2248 - Support duplicate management actions with "Select All"

  • MDM-2306 - Add the golden records' Confirmation Status metric to Pulse

  • MDM-2379 - Localization of the pivot field and measures in Pulse

  • MDM-2399 - Document the configuration of Jetty 9 application server

  • MDM-2406 - Actions in duplicate management workflows should not shuffle records

  • MDM-2408 - Reorganized Duplicate Statistics in duplicate management workflows

  • MDM-2465 - Support user defined PL/SQL functions to prevent SemQL warnings

  • MDM-2497 - Improvements to the "Suggest Mappings" feature in data import to handle references

  • MDM-2649 - Preserve table columns width in applications as part of the user preferences

  • MDM-2769 - Limit embedded Pulse Dashboards content to the content related to application

  • MDM-2771 - New "Download Hyperlink" display type for binary attributes

  • MDM-2815 - OpenID Connect 1.0 connector for Tomcat

  • MDM-2860 - Pulse dashboard axis should not display the decimal places when a metric is an integer value

  • MDM-2866 - Navigation Link to the golden record when golden ID is used in master data forms

  • MDM-2873 - Configurable auto-refresh for activities lists and business object views

  • MDM-2980 - Support "Remove All" action in duplicate management workflows

  • MDM-3000 - Customized search forms for business users

  • MDM-3019 - Configure the search types available for each node of a business object view

  • MDM-3031 - Localization of the values in Pulse

  • MDM-3063 - Activity overview and list should display workflow submit/cancel date & time for completed task

  • MDM-3102 - Show Information and Tooltip on Pulse Dashboards

  • MDM-3138 - Notify assignee is checked by default when notification is possible

  • MDM-3162 - Support design time ordering of folders and business object views in applications

  • MDM-3181 - Browse duplicate management workflow content using a flat view

  • MDM-3184 - Support sorting when in duplicate management workflows

  • MDM-3204 - Complete a task from the data editing dialog and make the task completion dialog optional

  • MDM-3205 - Hide "Validate" and "Enrich" buttons if no validations or enrichments are defined for the task

  • MDM-3245 - "Demo Applications" in the Getting Started renamed "Sample Source Data"

  • MDM-3253 - OpenID Connect Connector should support web services authentication

  • MDM-3331 - Numeric form fields should raise warnings for invalid numbers and datatypes errors

  • MDM-3343 - Post-consolidation enrichers

  • MDM-3355 - Select the table view used in duplicate management workflow at design time

  • MDM-3367 - Browse duplicates management workflow content grouped by Original Golden, Latest Confirmed Golden and Suggested Group

  • MDM-3394 - SemQL supports :V_BATCHID in enrichers and validators running only in integration job

  • MDM-3401 - Predictable colors scheme in Pulse Dashboards

  • MDM-3433 - Remove in duplicate management workflows

  • MDM-3514 - New SuggestedMergeConfidenceScore, SuggestedMergeMastersCount attributes computed by the matching process

Bug Fixes

  • MDM-229 - Installing and Updating a Model Edition containing SemQL errors updates the DDL before failing during Integration Job creation

  • MDM-1687 - Column D_BATCH.JOB_DEPRECTAED should be D_BATCH.JOB_DEPRECATED

  • MDM-1984 - Failed Model Deployment keeps the model marked as deployed

  • MDM-2109 - Null file when exporting (XLS, XLSX, CSV) data from a business object view using Firefox

  • MDM-2284 - User interface main window does not always resize to browser’s window size

  • MDM-2790 - Convergence AddressEnricher OnDemand does not raise an error if the on demand server is down

  • MDM-2950 - Single-click on an editor tab has no effect in Internet Explorer 11. A double-click is required

  • MDM-2994 - Keyboard tab order in Grid Layout does not work properly

  • MDM-3055 - Duration computed by Pulse Load Job are wrong

  • MDM-3062 - Invalid assigned date in Activity List

  • MDM-3065 - Scrollbars do not scroll as expected when clicking the track

  • MDM-3072 - StackOverflow error when enabling a quick filter after browsing a reference

  • MDM-3079 - Form attribute type is not re-evaluated after modifying the SemQL expression

  • MDM-3082 - Workflow notification fails with a "No recipient" error even when emails are configured for the roles

  • MDM-3083 - Error on one notification prevents the execution of subsequent notifications

  • MDM-3084 - ConcurrentModificationException while engine sends notifications

  • MDM-3089 - Pulse slicer labels should be shorter

  • MDM-3093 - Handling of acronyms in physical names generation should follow what is done for labels generation

  • MDM-3101 - Incorrect exception logged in console when using LovSortMode = LABEL

  • MDM-3104 - Random http 500 crash when browser zoom is activated

  • MDM-3105 - Editing a record disables the filter currently activated

  • MDM-3110 - Thread Pool Size defined in enrichers and validators is ignored at execution time

  • MDM-3134 - Model name is unexpectedly altered during model import

  • MDM-3148 - The Checkout wizard for data entry workflows does not list user filters

  • MDM-3150 - SemQL parsing fails with "Unexpected error while rewriting AST" when using a case when (case x when y syntax)

  • MDM-3154 - The workflows' "Allow Properties Edition" property renamed to "Editable Properties"

  • MDM-3158 - Opening an existing purge schedule takes the current time instead of the configured time

  • MDM-3159 - New sections in a flow layout are added above instead of below the selected section

  • MDM-3168 - Logging using the log4j JMS appender fails with a javax.naming.NoInitialContextException

  • MDM-3201 - Duplicate Search Menu when enabling quick filter created by reference browsing

  • MDM-3208 - Default values in Pulse Cron schedule should reflect the current schedule

  • MDM-3256 - Excel export renders the attributes' SemQL expressions instead of the names

  • MDM-3257 - Incorrect field size check for string primary keys causes unhandled event loop exception in data entry

  • MDM-3261 - Columns are not properly sized after changing displayed columns when autofit is on

  • MDM-3273 - ID Matching entity with a manual ID should not allow editing of ID after initial record creation

  • MDM-3314 - Missing Consolidation Strategy button when switching consolidator from row-level to field-level

  • MDM-3323 - ".ForeignPublisherID" reference name suffix renamed to ".PublisherID" for consistency in data export

  • MDM-3333 - Guess Mapping button should be enabled only if "1st Line as Header" is checked

  • MDM-3337 - Integer Field using a number format allows entering overflowing values

  • MDM-3340 - Unable to order in descending mode in the form search value picker

  • MDM-3345 - "Master duplicates within a publisher" metric does not appear in Pulse dashboards

  • MDM-3375 - A whitespace at the end of a form attribute’s SemQL expression prevents data import in the attribute

  • MDM-3378 - Google Maps Enricher does not support Proxy authentication. The http.proxyUser and http.proxyPassword system properties are now supported

  • MDM-3393 - Export takes all table view attributes and ignores the "Export Displayed Table Columns" option

  • MDM-3404 - Inaccurate privileges error message when submitting data with an invalid payload to the web services

  • MDM-3416 - The person name enricher data file contains incorrect names, which leads to incorrect name detection

  • MDM-3481 - System information dialog crashes with permanent license Keys (License key without expiration date)

  • MDM-3500 - Model Privilege Grants missing "Allow Checkout"

  • MDM-3576 - Purge jobs are not updated on deployment data locations

  • MDM-3593 - "Unhandled Event Loop Exception" Error on import when the imported file size is greater than 2Mb.

  • MDM-3601 - Right-aligned label incorrectly aligns to the left when wrapping due to its length.

  • MDM-3595 - "Unhandled Event Loop Exception" Error displayed for a plugin when an input or output field name is longer than 30 characters.

  • MDM-3600 - Email enricher returns addresses containing apostrophe’s (single quotes and other special characters) as invalid. The enricher now adheres more strictly to RFC5322: It allows authorized special characters and supports quoted strings.

Version 3.2.1

Known Issues

  • MDM-3857 - The PARAM_ANALYZE_STATS switches to 1 in all jobs after an upgrade to this version. As a workaround, customers should edit their jobs and set the PARAM_ANALYZE_STATS parameter value to 0.

  • MDM-3872 - Email enricher causes load job to fail with javax.naming.NameNotFoundException: Name [null] is not bound in this Context. Unable to find [null] error after an upgrade to 3.2.1. This appears when the Datasource parameter is left empty in the job definition. As a workaround customer should remove the empty parameter from the enricher and redeploy their jobs.

New Features

  • The default schema name for Convergence Pulse Metrics is now SEMARCHY_DEMO_PULSE.

  • MDM-3671 - Logout page made more user-friendly.

Bug Fixes

  • MDM-3621 - Confusing validation message reported by data entry for an incorrect data type attribute value

  • MDM-3645 - Convergence for MDM application does not start on Oracle WebLogic Application Server 12C. This issue is due to a WebLogic bug.

  • MDM-3678 - Convergence for MDM does now work with the Microsoft Edge Browser.

  • MDM-3683 - Using "any Children" in a business object filter or a privilege grant condition on fuzzy matching entities causes a validation error

  • MDM-3684 - Data location upgrade fails when entities have been converted from fuzzy to exact matching in previous model editions

  • MDM-3688 - A display name containing a '&' character is not consistent between hierarchy and form view

  • MDM-3690 - Invalid thread access error when uploading plug-in in the administration view

  • MDM-3701 - HTTP headers are incorrectly set in HTTP notification servers

  • MDM-3707 - Unhandled event loop exception appears when re-opening the search view in a workflow.

  • MDM-3712 - The type of the ID attribute of an UDPK entity is automatically changed to string(128) after an 'Alter Entity' action when opening the ID column, even if the action is not saved.

  • MDM-3751 - Generated SQL diverge due to lax SemQL validation (many path expressions inside any/all)

  • MDM-3752 - NullPointerException when opening a Business Object View with a filter created "By Form" saved in the user preferences

Version 3.2.2

Known Issues

  • MDM-3883 - Error when discarding a record when creating more than one record in a data entry workflow

Bug Fixes

  • MDM-2480 - Form fields are too small in a Filter by Form.

  • MDM-3857 - The PARAM_ANALYZE_STATS in existing jobs switches to 1 in all jobs after an upgrade.

  • MDM-3871 - "Select all" ignores the Business Object root filter when checking out records for duplicates management.

  • MDM-3872 - Email enricher causes load job to fail with javax.naming.NameNotFoundException: Name [null] is not bound in this Context. Unable to find [null] error after an upgrade to 3.2.1. This appears when the Datasource parameter is left empty in the job definition.

  • MDM-3876 - On an application, if you use required role for an entity view, the semadmin user is no longer be able to see the entity.

  • MDM-3878 - Workflow notification email inverts the Application and Workflow names, and provides obsolete steps to claim a task.

  • MDM-3881 - Chart are not displayed and the UI freeze when opening Pulse Dashboards with Internet Explorer, Chrome versions prior to 39 and Firefox versions prior to 34.

  • MDM-3901 - A "None" Privilege Grant causes Data Entry or import to fail with a com.semarchy.mdm.runtime.data.DataAccessPermissionDeniedException even if the secured attributes are not used in import or data entry.

  • MDM-3903 - Cannot start engine after upgrade to 3.2.1 due to integration batches pending without job instances.

  • MDM-3904 - A Search Form with a large number of parameter does not appear with a scrollbar.

  • MDM-3913 - Browser shows a cryptic {"head":{},"operations":[]} error message after logging in.

Version 3.2.3

Bug Fixes

  • MDM-3955: Data edition on LongText fields fails with a No trespass RuntimeException

  • MDM-3935: The SemQL editor button on the Input Email Address field of the Email Validator Plugin pops up a blocking error

  • MDM-3957: NullPointerException (fitScrollableSizeToForm) issued when opening a Custom Search Form when other search methods are available.

  • MDM-3952: The integration load specific web service persists incorrect values when multiple complex attributes have definition attributes with the same name

New Features

  • MDM-3931: Golden integration records are navigable from the post integration (golden error) records in SemQL.

  • MDM-3945: Additional information provided in the upgrade guide for users having defined attributes with reserved physical names (starting with B_).

Version 3.2.4

Bug Fixes

  • MDM-4054: Singleton are not matched after an upgrade to 3.2.

This version only fixes the upgrade process from 3.1 to 3.2. Customers who have already upgraded to version 3.2 should refer to the Knowledge Base Article that explains how to fix an existing upgrade.