EDM v17.1.141.1 is now available

EDM v17.1.141.1 is now available.

The fixes in this release affect the Data Generator component.

For a complete list of the resolved issues, please refer to the release notes.

EDM v18.1.37.187 is now available

EDM v18.1.37.187 is now available.

The fixes in this release affect the Data Generator and Database Upgrade Wizard component.

For a complete list of the resolved issues, please refer to the release notes.

EDM v19.1 Release Notification

IHS Markit is pleased to announce the v19.1 release of our Enterprise Data Management (EDM) software which is now generally available.

The highlights of this release are:

Import/Export Configuration

• Ability to export the EDM configuration and integrate it with any preferred third-party version control provider to create branches and resolve conflicts during merges.
• Configuration can be imported back into EDM, allowing users to easily promote code or work across multiple branches of EDM.
• To enable merging, XML definition files produced by EDM have been simplified and the hash validation removed, allowing for modification outside of EDM.
• Import/export can be done either via the command line or via a new Import Export Configuration wizard which guides the user through the process.

 For more details, read the Import/Export Configuration guide.

Add Attribute Wizard

• Add Attribute Wizard has been completely redesigned and enhanced to make the process of adding attributes much quicker and simpler. 
• New wizard allows EDM users to add attributes to any group of tables within the EDM database, either from a Data Constructor (current method) or from tables manually selected by the user.
• All component dependencies are followed, and rules and validation tests can be cloned for the new attributes.
• SQL statements that include the adjusted tables can be viewed and customized where needed.
• Ability to skip or correct component configuration to ensure successful completion.
• Minimal manual configuration post completion and ability to roll back and fix issues if necessary. 

 For more details, read the Add Attribute Wizard user guide.

Map UI Element

• New Map UI element allows users to display a map in the EDM web UI, overlaid with user-defined points and features.
• Configurable in the EDM thick client, feeding data from any database tables, as well as GeoJSON files.
• Map elements can be placed into pages and workflows for web UI display, and then exported as image files from the web UI.
• Data points display individually and in clusters, as well as within selected objects on the map.
• Complements the Blue Marble coordinate conversion work allowing users to see the spatial relationships of data stored within EDM.

 For more details, read the Map UI Element user guide.

Core Matcher

• Default condition of match attributes displays in the Match Conditions tab of the Core Matcher thick-client configuration, as well as in the Show Match Conditions tab of the Configuration UI element.
• The match, core record and results details grids in the Core Matcher web UI can be exported to Excel.
• Ability to show/hide, reorder, sort, filter and lock/unlock columns in the Source and Core Record History Detail modals.
• New Bulk Realign tool in the Match Results Details, Core Record Details and Results Details grids allows users to realign source records to core records in bulk.
• Improvements to internal memory management reduce the chance of out-of-memory exceptions, and optimized scoring processing leads to shorter execution times.

 For more details, read the Core Matcher user guide.

Page Designer

• Visual improvements to the page designer in the EDM thick client provide a more intuitive user experience:
  • New horizontal and vertical grid lines in a different color
  • Horizontal and vertical page ruler
  • Tooltip displaying an element's dimensions and updating when the element is resized.

 For more details, read the UI Page user guide.

Data Generator

• New Clear Filters option in the web UI Data Generator Inbox grid toolbar. 
• Ability to apply filters to a web UI Data Generator Inbox and display value distribution results based on the filtered data set.
• Position of adding new rows to the Data Generator Inbox has been updated to now appear at the bottom of the grid.

 For more details, read the Data Generator user guide.

Workflow Debug Modal

• Workflow Debug modal in the web UI has been updated to also show any variables in use that are held within nested workflow elements. Previously, only variables of the parent workflow were shown.

Dynamic Element

• When creating a new dynamic element in the EDM thick client and adding underlying elements or pages that contain multiple elements, the parameters that have been enabled on the underlying child elements are automatically enabled in the parent dynamic element.

Table Builder/Designer

• Table Builder and Table Designer have been redesigned to allow users to quickly add new rows without prompting the New Field Specification dialog, as well as add rows in bulk.
• Tables and data are no longer deleted from the database in case of errors during promotion of changes to Table Builders.

Data Flow Sequence

• One or more steps in a Data Flow Sequence can now be disabled via a new Disable Step option, allowing the Data Flow to bypass them at run time.

Verify and Create Wizard

• Verify and Create Wizard notifications have been updated so users are prompted to manually save changes to any open processes before the wizard starts running and automatically closes all open components. 

Other Changes

• Data Porter and Data Flow components can read from and write to an Oracle table that contains a Geometry spatial data type. 
• Expanded segments in a pie/doughnut chart can be closed and the associated output parameters automatically cleared.
• Data type selection list now displays in alphabetical order.
• Any HTML/data templates added to the EDM Document Object Model (DOM) tree will be removed when switching to another workflow or logging out from EDM to ensure performance is not degraded in time.

Deprecations

• Old binary code has been removed from EDM, so any clients on a EDM version earlier than v7.5 will not be able to upgrade directly to v19.1, but will have to upgrade to an earlier version first. 
• The parameter to enable legacy grids has been removed in EDM v19.1, so all customers on v19.1 will need to use the HTML5 grids.
• From v19.1 onwards, EDM users attempting to log into the EDM web UI via Internet Explorer 11 will be prompted to use an alternative web browser.
• With the introduction of the Import/Export Configuration capability in EDM v19.1, all integrated Version Control options apart from Database are now deprecated. These include: File System, Source Safe 2005, Subversion 1.7 and 1.8, Team Foundation Server 2010, 2013 and 2015.

For additional information about this release, please see the EDM v19.1.19.53 release notes and the EDM v19.1 version note.

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

EDM v18.2.21.31 is now available

EDM v18.2.21.31 is now available.

The issues resolved in this release affect the following components:

• Core Matcher
• UI Workflow
• UI Element
• Rule Builder
• Solutions

For a complete list of the resolved issues, please refer to the release notes.

EDM v19.1 (Beta) Release Notification

IHS Markit is pleased to announce the v19.1 (Beta) release of our Enterprise Data Management (EDM) software.

The highlights of this release are:

Import/Export Configuration

• Ability to export the EDM configuration and integrate it with any preferred third party version control provider to create branches and resolve conflicts during merges.
• A new 'AllConfiguration' parameter in the CADISImportExport.exe command line utility allows EDM users to export the configuration to, or import the configuration from a designated file path.
• Configuration can be imported back into EDM, allowing users to easily promote code or work across multiple branches of EDM.

Add Attribute Wizard

• New more user-friendly Add Attribute Wizard is replacing the current Add Master Attribute Wizard. The new wizard will allow EDM users to add or remove attributes to and from EDM database tables, either from a Data Constructor (current method) or a list of tables as a starting point.
• Minimal manual configuration post completion and ability to roll back and fix issues if necessary.
• The new wizard will be fully available for the EDM 19.1 General Availability release.

Map UI Element

• New Map UI element configurable in the EDM thick client, feeding data from any database tables, as well as GeoJSON files.
• Map elements can be placed into pages and workflows for web UI display, and then exported as image files from the web UI.
• Ability to display data points individually and in clusters, as well as within selected objects on the map.
• Complements the coordinate conversion work allowing users to see the spatial relationships of data stored within EDM.

Core Matcher

• Default condition of match attributes displays in the Match Conditions tab of the Core Matcher thick-client configuration, as well as in the Show Match Conditions tab of the Configuration UI element.
• The match, core record and results details grids in the Core Matcher web UI can be exported to Excel.
• Ability to show/hide, reorder, sort, filter and lock/unlock columns in the Source and Core Record History Detail modals. Additionally, the column width is automatically updated based on the user's screen resolution and rows can be copied into Excel.
• New Bulk Realign tool in the Match Results Details, Core Record Details and Results Details grids allowing users to realign source records to core records in bulk.

Page Designer

Visual improvements to the page designer in the EDM thick client to provide a more intuitive user experience:

• New horizontal and vertical grid lines in a different color
• Horizontal and vertical page ruler
• Tooltip displaying an element's dimensions and updating when the element is resized.

Data Generator

• New Clear Filters option in the web UI Data Generator Inbox grid toolbar.
• Ability to apply filters to a web UI Data Generator Inbox and display value distribution results based on the filtered data set.
• Position of adding new rows to the Data Generator Inbox has been updated to now appear at the bottom of the grid.

Workflow Debug Modal

• Workflow Debug modal in the web UI has been updated to also show any variables in use that are held within nested workflow elements. Previously, only variables of the parent workflow were shown.

Dynamic Element

• When creating a new dynamic element in EDM thick client and adding underlying elements or pages that contain multiple elements, the parameters that have been enabled on the underlying child elements are automatically enabled in the parent dynamic element.

Table Builder/Designer

• Table Builder and Table Designer have been redesigned to allow users to quickly add new rows without prompting the New Field Specification dialog, as well as add rows in bulk.

Data Flow Sequence

• One or more steps in a Data Flow Sequence can now be disabled via a new Disable Step option, allowing the Data Flow to bypass them at run time.

Verify and Create Wizard Improvements

• Verify and Create Wizard notifications have been updated so users are prompted to manually save changes to any open processes before the wizard starts running and automatically closes all open components.

Other Changes

• Data Porter and Data Flow components can read from and write to an Oracle table that contains a Geometry spatial data type.
• Expanded segments in a pie/doughnut chart can be closed and the associated output parameters automatically cleared.
• Data type selection list now displays in alphabetical order.
• Any HTML/data templates added to the EDM Document Object Model (DOM) tree will be removed when switching to another workflow or logging out from EDM to ensure performance is not degraded in time.
• Old binary code has been removed from EDM, so any clients on a EDM version earlier than v7.5 will not be able to upgrade directly to v19.1, but will have to upgrade to an earlier version first.
• Legacy canvas grids are no longer supported from EDM v19.1 onwards.

For additional information about this release, please see the EDM v19.1.19.17 Beta release notes and the EDM v19.1 version note.

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

EDM Warehouse v18.2 Release Notification

IHS Markit is pleased to announce the v18.2 release of our Enterprise Data Management Warehouse (EDM Warehouse) software which is now generally available. 

The highlights of this release are:

Dashboards

The following new features and enhancements are available in EDM Warehouse Dashboards from this release:

• User-Defined Dashboards: You can now create customized dashboards to meet your daily business needs. You can access the data that you need and view it either in grid or chart format.
• Data Drill Down: Dashboards present a view of data that is a point-in-time snapshot. You can drill down from a grid or chart summary overview to a more detailed view of the data. 
• Responsive Design: A new palette supports independent sizing and placement of underlying components. Dashboards can also be deployed across a wide range of devices. 
• Easy to Create: Simplified way of adding widgets to dashboards.
• Modern Grids and Charts: Kendo UI integration in EDM Warehouse Dashboards brings features such as Grid Sort, Grid Expand and Column Summaries.
• Cross Platform UI Design Integration: From this release, EDM and EDM Warehouse follow the same UI design for dashboards.
• Template Integration: EDM Warehouse Dashboards are now compatible with Position and Transaction Summary templates. 

Charts

Kendo UI integration with EDM Warehouse brings a fresh look to the v18.2 release:

• New Chart Type: Donut
• Chart Resizing: Users can now resize the charts based on the size of the data to get a better view. 
• Pie Charts: You can plot pie charts based on absolute values, so negative components are included in the analysis.
• Data Drill Down: You can drill down from the charts summary overview to a more detailed view of the data.
• Feature and Template Integration: Integrated with PDF Downloads, EDM Warehouse Scheduler, as well as with Position and Transaction Summary templates. 
• Other Features: Tool tips, hide/un-hide series values using legends.

Data Model Enhancements

• Four new fields have been added to the Fund Share Class Performance Table (Gp_Fund_ShareClass_PerfDg)
• A user-defined text field has been added to the Customer Table (Cust)
• The field length has been increased for description fields in the Transaction Table (Tranevent_Dg)
• A new transfer method for processing and loading Instrument Index Constituents Statistics (Iss_Indx_Cnstnt_Stats) has been added.

Platform Certification

• Certified with Microsoft Windows Server 2016
• Certified with SQL Server 2014 and 2016 Enterprise Edition
• Certified with Crystal Run time Release 13_0_23 (64 Bit)
• Certified browsers 
  • Chrome: version 71.0.3578.98
  • IE 11 with compatibility mode off
• Certified with EDM v18.2.12.1 and v18.1.29.4
• IIS 10
• Microsoft .Net Framework 4.7.2

Integration

• Single Sign On with Active Directory Federation Services (ADFS) or Cloud authentication providers such as OKTA.

For additional information about this release, please see the EDM Warehouse v18.2.0.98 release note.

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

Advisory Note on EDM Version Control Integration - December 2018

IHS Markit would like to inform you that we do not plan to offer further improvements around direct integration between EDM and external version control systems, such as TFS or SVN.

In 2019, we intend to move towards a standard that will better serve our customers. This will involve EDM exporting and storing component definitions in the file system, whereby any external source control provider can access them, enabling branching and merging capabilities outside of EDM. An import process would be created to import and synchronize the definitions back into the EDM database when needed from the file system.

While we will continue to support existing functionality that is already available in the EDM thick-client application, such as direct integration with TFS 2015 or SVN 1.8, there are no plans to add support for additional versions such as TFS 2018 or SVN 1.9.

Going forward, we are encouraging our customers to use our internal database version control system which provides maximum flexibility and control over version control integration. As of version 19.1, EDM's native database version control will still be leveraged to store individual historical version changes per component via the thick client even. Further database version control improvements have been made in the latest versions of EDM v11.5 (11.5.48.0+) and EDM v17.1 (17.1.123.2+) which can be reviewed in the release notes.