EDM v18.1 (Beta) Release Notification

April 30^th 2018

IHS Markit is pleased to announce the v18.1 (Beta) release of our Enterprise Data Management (EDM) software. The highlights of this release are as follows:

Data Manager - HTML5

• Data Manager Inbox Grid UI element upgraded to HTML5.
• All toolbar options now consolidated into the "Enable Editing" link.
• Legacy Data Manager Inbox can be enabled via a database configuration.
• Further improvements are planned during the beta phase and will be added in future releases of 18.1.

Web Admin - Users & Groups

• Ability to manage Users & Groups via the web admin console.
• Restricted to users that belong to Web Administrator user group.

Chart Enhancements

• Inverted Y-Axis option has been added to chart configuration. The option inverts the Y-Axis to display positive values down the Y-Axis.
• Ability to sort stacked bar chart by total series value.
• Ability to display total series value within the doughnut chart.

Gauge KPI

• Improved HTML5 rendering of "Gauge" UI element. 
• No additional configuration required on upgrade.
• Improves the legacy Gauge component with additional features: two styles (half or full), label positioning (inside or outside), and export-to-image.

Number KPI

• A new "Number KPI" UI element within the Key Performance Indicator category.
• Simple intuitive display of information to highlight important information (e.g. Exceptions).

Combo KPI

• New "Combo KPI" UI element within the Key Performance Indicator category.
• Allows users to add 2-3 KPIs in a single element.
• Based on the Number KPI element, with additional visualization settings for Number KPI, Sparklines, Gauge, and Doughnut.

Spatial Data

• EDM now supports SQL Server data types Geometry and Geography.

Form Improvements

• Support for new features such as adding new records, controlling label positioning, and hiding field groups.
• Reworked toolbar for Data Generator Form View and Data Manager Form View.

Workflow Debug Window

• HTML5 grid rendering to improve performance compared with legacy grids.
• Start-up performance is improved by significantly reducing the app bundle size because legacy grids are lazy-loaded.
• Improved usability user can now interact with workflow and dynamically see the debug window update.
• Ability to search and filter workflow variables.

Favorites Element

• Redesigns the existing element which allows users to organize and display links to other workflows.

Last Constructed Redesign

• Redesigns the existing feature which shows the business logic used to derive the value for the selected row / column.

Core Matcher - Record Specific View

• A new element has been added to display core matcher details for a specific match.

Message Queues

• Support for Apache Kafka has been added to the thick client.
• Support for Amazon SQS has been added to the thick client.

For additional information about this release please see the EDM v18.1.125.1 Beta release notes

Please contact your client manager if you are interested in participating in the EDM 18.1 Beta release.

Changes to the Bloomberg Per Security Web Service

On June 2, 2018, Bloomberg will no longer support TLS1.1 and will only support TLS1.2 connection for their products - Bloomberg CANS (Corporate Action Notification Service) Per Security, Data License.

Consequently the EDM's Data Porter plug-in: Bloomberg Per-Security Web Service Plug-in will not be able to connect to the Bloomberg endpoint for Plug-ins of EDM versions 10.5 and lower.

EDM version 11.0 and above uses the 4.6.1 .NET framework as noted in our Compatibility page in EDM Confluence.  The plug-in for these versions will be able to connect with TLS1.2 protocol as .NET 4.6 and later is compatible with TLS 1.2 by default.

The Markit EDM team is enhancing this plug-in to ensure successful connection to the TLS1.2 supported Bloomberg endpoint that takes effect on June 02, 2018 for EDM versions of 10.5 and below that use an older .NET framework version.

Additionally, the Markit EDM team is introducing a parameter to change the Bloomberg webservice URL for all EDM versions of the plug-in. The default webservice URL will be the true Bloomberg endpoint - https://dlws.bloomberg.com/dlps. This plug-in parameter can be changed so clients can test with Bloomberg's UAT environment (e.g. https://dlws-uat.bloomberg.com/dlps). This enhancement can be used for testing with Bloomberg's UAT environment should there be future changes from Bloomberg.

If you do not use the Markit Bloomberg Per-Security Web Service Plugin, no further action is needed.  However, if you do use the plugin then please contact the Markit EDM Support team as soon as possible confirming which version(s) of EDM are affected and we will provide you with the updated plugin  

EDM File Transfer Enhancement

EDM Support are pleased to advise that we are now able to offer additional File Transfer services 

Protocols available are FTP, FTPS, SFTP, HTTP and HTTPS

Current usernames and passwords have been preserved however, the host will change to files-eu.markit.com and port from 21 to 22.  Please update your login credentials accordingly

Please do not hesitate to contact EDM support should you have any questions at medm-support@markit.com

Technical Brief: Impact Assessment of Spectre and Meltdown Processor Bug Patches on EDM

In response to the recent news of the Meltdown and Spectre computer chip bugs which could potentially allow attackers to access sensitive data, microprocessor manufacturers and operating system vendors have been busy devising patches to protect against the perceived security risks. While these rapidly-introduced patches are intended to address the security vulnerabilities, they may incur some performance penalties on the underlying systems.

We will strive to provide our clients with early warning of any adverse impact resulting from the applied processor patches. Currently the EDM team is actively monitoring the performance results of our continuous integration and performance tests to assess any potential performance degradation for our managed services and client-installed implementations.

In this fluid situation where the impact can vary significantly depending on usage and complexity of operating environments, we encourage our customers also to monitor their own EDM installations where applicable.

Any clients who do notice any performance degradation of EDM once their systems have been patched are encouraged to notify EDM Support.

EDM end of software version support

IHS Markit EDM is providing 6 months' notice of EDM versions which will be out of support in 2018 as detailed in EDM Confluence

Version	Release  Date	Full Support 2 years from Release Date	Partial Support further 1 year	Unsupported
v17.1	Nov-17	X
v11.5	Mar-17	X
v11.0	Sep-16	X
v10.5	Jan-16	X until Jun-18	X
v10.2	Apr-15	X until Jun-18	X
v10.0	Dec-14			X
v9.5	Dec-13			X
v9.0	May-13			X
v8.5	Nov-12			X
v8.1	Aug-11			X
v8.0	Apr-11			X
v7.6	Oct-10			X
v7.5	Apr-10			X
v7.0	Jul-09			X

Software reaches end of life support for a number of reasons such as technology innovation and development driven changes to the product, or the software matures over time and is replaced by functionally richer technology. 

Access to Full EDM software support will be available for a period of 2 YEARS from the date of release of a Major EDM version.  

Full Support 

Comprises investigation and replication where possible and workarounds identified within local support environments. 

• Software issues will be addressed in upgraded releases within the major EDM version.

Partial Support

Comprises investigation and replication where possible, for a FURTHER 1 YEAR from the date of end of full support.  However, we cannot guarantee to have a local support environment available and support may be limited to webEx sessions, enterprise software jira, telephone and e-mail support.   

• IHS Markit EDM will no longer develop or address issues in the software for partially supported EDM versions.

Unsupported

Unsupported version support will be limited to webEx sessions, enterprise software jira, telephone and e-mail support only.  EDM support will not have local environments available to enable investigation or replication of issues. 

• IHS Markit EDM will no longer develop or address issues in the software for unsupported EDM versions.

EDM Warehouse v17.1 Release Notification

December 18th 2017

IHS Markit is pleased to announce the v17.1 release of our EDM Warehouse software which is compatible with EDM v17.1. The highlights of this release are as follows:

User-Defined Account Groups Maintenance

• Enhanced features to maintain user-defined account groups.
• Define group start date and base currency.
• Search and assign eligible participants by Account ID and Name.
• State period of a participant in a group; i.e. start and end date.
• View participant lineage in the user-defined account group.

Reporting Currency 

• Allow administrators to select exchange rates based on price types, exchanges, and sources.
• Flexibility on viewing and reporting data in alternate currencies.
• User-Defined Inquiries automatically inherit configuration from the parent unless specified. 
• Define price type, price exchange, price source and price validity at the application level, if there is only one source of FX data. 
• Define price type, price exchange, price source and price validity at the inquiry level if there is more than one source of FX data; e.g. FX Rates from Internal System versus Software Vendor. 

Auto-Permission New Accounts

• A new rule-based feature which allows administrators to auto-permission new accounts to one or more user groups.
• Full revision history of changes in rules is maintained for audit and compliance purposes.
• Can be integrated and invoked via EDM after completion of Portfolio / Account Master load to EDM Warehouse.
• Positive or negative permissions: all permissions to User Group A where Book ID is Private Equity; all permissions to User Group A where Book ID is not Private Equity.

New Inquiries

Fund Performance Inquiry

• View performance data for a period or period range including returns, fees and expenses for funds or share classes.
• Compare performance data with linked benchmarks.
• Refine performance results by using available selections; e.g. Benchmark Type, Benchmark Purpose.

Extended Security Classification Position List

A new position data inquiry template that supports the use case of security level classification:

• Dynamic update to field business names based on the selection of security characteristics set.
• Removes the overhead of creating position-level classifications out of security-level classification as found in EDM Warehouse v9.0 and below.

Security Updates 

• SQL injection and ethical hack issues were updated for Nam and Account totals inquiries.
• Column names and other secure information are not shown on capture in HTTP and HTTPS traffic and logs.
• Inline SQL code and query formations were removed and are done server-side which makes the system more robust and secure.

Table and Loader Updates

• Market Data tables have been enhanced to ease data uploads and remove the dependency on other market data table content.
• Benchmark tables have been added to allow clients flexibility in linking Indices or Benchmarks to Funds and Accounts.

 

For additional information about this release please see the EDM Warehouse v17.1 release note.

Please contact your client manager if you are interested in upgrading to this release.

EDM v17.1 Release Notification

November 27th 2017

IHS Markit is pleased to announce the v17.1 release of our Enterprise Data Management (EDM) software which is now generally available. The highlights of this release are as follows:

Dashboards

• Display multiple visual elements representing data sets, charts, functions and reports.
• Summarize key metrics and trends for data in your EDM implementation.
• Use the same reports or elements in multiple zones on a single dashboard.
• Visualize the same report data (for example) as both a bar chart and a pie chart.
• Share dashboards and access shared dashboards.
• Allow specified 'collaborators' to edit shared dashboards.
• Lock dashboards to prevent concurrent editing.
• Resize the browser window to see 'responsive' elements adapt accordingly.
• Allow dashboard elements to communicate via 'channels'.
• Users can edit the default element name when adding to a dashboard.

Chart Export

• Save charts for sharing or inclusion in documents.
• Export as an image.
• Export in Scalable Vector Graphics (SVG) format.

EDM Groups

• New EDM Groups tab within Console Grouping and Security allows custom groups of EDM users to be created.
• Users can be added to EDM Groups from other EDM Groups or from Active Directory.
• Groups of users can be assigned permissions in a way that is less cumbersome than creating Active Directory groups for this purpose.

Favourites

• Add pages to your list of favourite pages via one click on the Page Toolbar.
• Access your list of favourite pages via a link in the Side Menu.

Doughnut KPI Chart

• New 'Doughnut KPI' UI element within the Key Performance Indicator category.
• Displays value as a percentage towards a target.

Client-Facing RESTful API

• Exposes core EDM functionality; specifically the EDM Data Generator Service.
• Includes an EDM Token Service for authorization via a JSON Web Token (JWT).

Page Layout for Workflows

• Layout for workflows now based on a fixed 24 column grid, with rows fixed at 30 pixel height.
• Database Upgrade Wizard converts workflows to the new layout.
• Row count for conversion defaults to 24, but can be changed.

Data Generators - HTML5

• Generator Inbox Grid UI element upgraded to HTML5.
• Powerful facilities for paging, sorting and filtering items.
• All editing options now consolidated into the "Enable Editing" link.
• Default paging set to 50 rows per page on upgrade.

New UI System

• Side Menu with links to pages, dashboards and favourites.
• Administration Toolbar with a link to the 'about' page and (in future) an administration section.
• Page Toolbar facilitating access to page-level functions such as editing, sharing and adding pages to favourites.

Published Elements

• Organise elements into categories, and tag with keywords.
• Provide a business-friendly name and description for end users.
• Set input / output mapping for components to communicate within the dashboard.
• Create an inventory of elements to be used when building dashboards.

Doughnut Charts

• HTML5-based.
• Same features as the pie chart.
• Easy to configure and migrate to the doughnut style.

Version Control

• Checked-out Components View now allows sorting by "Type", "Name", "Check Out To" or "Check Out Date".
• Version Control labels can now be chosen from a drop-down list on check-in. 
• Package Export Wizard now allows exporting of components for a specific label or multiple labels.

Data Porter 'BulkCopy' Default

• DPTransferSystem in CADIS_SYS.CO_DBPARM now specifies the default transfer method for all Data Porters.
• The default 'BulkCopy' database transfer method can be changed, and individual Data Porters can be overridden using the drop-down at each step.

Other Changes

• Visual and architectural changes to the look, feel and performance of the thin-client Web UI by introducing Angular 2 and streamlining CSS.
• Ability to hide or show location of environment, and new location of environment description.
• Read-only mode introduced for Core Matcher UI.
• To improve efficiency when wiring up elements in a workflow, default settings for input / output parameters of newly created UI elements now set to fixed values: "null" for inputs, and "not visible" for outputs.
  

For additional information about this release please see the EDM v17.1.110.11 release note, and for the version documentation please see the EDM v17.1 version note.

Please contact your client manager if you are interested in upgrading to this release.