Chat now with support
Chat with Support

erwin Data Transformation 9.2.1 - Release Notes

Major Release - v8.1

Major Release - v8.1

This release improves several areas of the product areas, including:

A new name for Collector.... erwin Data Transformation, or erwin DT for short.

erwin Licensing now governs the product, replacing the 2 step licensing used by Casewise.
This means that you will need to contact support to receive a new licensing code.
The erwin licensing system does now require the software to have access to the internet, in order to authenticate your license, each time the product is used. Note, if there is no connection available for a short period of time (1 to 3 days).
The software will continue to function, but will eventually request internet access to continue.

Simpler usage - now no need to logon to erwin EA/BP.
The next thing you will notice, after a new name and upgraded licensing, is the fact that you don't need to login anymore.
Since erwin DT is becoming more central to the ETL landscape of erwin EDGE, and EA or BP are not always part of the workflow, the login to erwin EA/BP no longer made sense. This makes for simpler experience when using erwin DT, only requiring login to EA/BP when an input or output adapter to those products will actually be required.

We now package the latest Java Runtime release for Java 8 (JRE 8u201). In future releases we intend to upgrade furtherto Java 11, but 8 seems to remain popular with customers, and this release includes all the latest security patches.

                    

New Adapter Support. We've been busy providing integrations to more products and platforms. So, we can now talk; Veracode, Zendesk, CloudHealth, Open Group File Format, SQL Database schema, and also have improved integration with erwin EA agile and DGc.

Database Adapters:

oDatabase Metadata adapter (for JDBC databases)

oRead meta data (schema) from your favourite JDBC compatible databases. This allows a simple "Reverse Data Engineering" facility directly in Collector, so you can see your schema in other products, including erwin DGc.

REST/API Adapters:

oVeracode adapter - read status information about your Applications into your erwin products, to ensure your Enterprise Architecture is telling you the most up to date information.

oZendesk adapter - If you use Zendesk for tickets, it is now possible to read a whole host of information directly into your erwin products. Track tickets against Applications and provide updates inside your erwin product, and feed that back to the ticket in Zendesk. Even create new tickets against your EA, BP or DG project right inside erwin, and have your support team handle them as usual.

          
 

oCloudHealth adapter - Being able to know the state of your cloud applications from inside your Enterprise Architecture is critical to knowing the health of your EA as a whole. Now you can bring this information into your erwin products, and include this in your dashboards.

oBasic Generic JSON Adapter - Have an API you wish to talk to that we don't support. We can now handle simple JSON requests without a bespoke adapter. But as always, if you have something you'd really like to talk to, let us know and we'll see how we can help.

Transformations:

oAdded transformation to allow the export of elements and their relationships and properties into the Open Group File
Format (OGFF). Allowing simple export of your EA assets for consumption by other OGFF compatible products.

oAdded transformation to allow the import of OGFF elements and then their relationships into erwin products. Bring data
in from your other OGFF compatible products.

erwin Workspace and Model Adapters:

oApplication connections and workspace/model adapters for EA Agile, DGC, or EA can be created from within the client.

Other Improvements:

oFor those who have REALLY complex workflows, you can now use more than 8 adapters in a single workflow

oAn external identifier stored as a property of an erwin EA/BP object can now be used when importing a dataset in EA Agile or DGC. This allows strong binding between objects in the two separate tools. Allowing updates to be more accurate, including the ability to rename in one tool, and see this in the other.

oWorkflows for any workspace/model adapter can be created and run without a separate logon

oLots of other little tweaks and fixes!

 

Resolved Issues and Enhancements

Resolved Issues and Enhancements

The following issues were resolved in this release:

RFA

Description

8.4.1.2

Bug Fix

Fixed an issue with empty cells in the Excel Adapter

8.4.1.1

Bug Fix

Fixed an issue with the start row/column in the Excel Adapter

Bug Fix

Fixed minor issues with install and configuration

8.4.1.0

Enhancements

Added support for containment hierarchies in EA agile v3

Added support for encrypting the workflow configuration in the database

Introduce DG BGM adapter to support Business Term transfer

Now able to use a different DG sitename, than default

Bug Fix

Fixed Date/Time range writing to EA agile v3

Performance

Reduced memory consumption and improved the speed of XSLX file processing

Security Fix

Fixed insecure randomness concern

Bug Fix

Improved startup stability for services

Security Fix

Removed Trustmanager acceptance of specific certificates

Changed

Switched AdoptOpenJDK Java to Hotspot, from J9

Security Fix

Command Injection vulnerability improvements

Bug Fix

Numerical chars from Adapter name are omitted when selecting Adapter during WF creation

Changed

Renamed DG to EA Agile V3 - in line with new marketing

8.3.0.0

Enhancements

erwin Licensing now supports offline licensing.

Added support for AdoptOpenJDK

Packaged AdoptOpenJDK 8 installer rather than Oracle JDK 8 installer

Added the ability to extract "Created At" and "Updated At" fields from EA Agile

Bug Fix

EA Agile Adapter: Fixed issue with mapping to EA Agile by a value other than the name.

Bug Fix

JDBC SQL Adapter: Increased the maximum character length for SQL queries; linting on save was added in an earlier version of Collector (7.5), which meant that those migrating from 7.0 were unable to migrate, as they were unable to edit their SQL queries without hitting the character limit.

Bug Fix

CloudHealth Adapter: Bug Fix for CloudHealth GCP Project rules support.

Bug Fix

EA Agile Adapter: Fixed bug with posting single array values to EA Agile.

Security Fix

Password Management: Use of a hardcoded password in a part of the tool removed.

Security Fix

Password Management: Use of a hardcoded password in a comment removed.

Security Fix

Password Management: All passwords stored in the database are now encrypted appropriately.

8.1.0.1

Enhancement

CloudHealth can now manage objects:
Renaming: the target system identifier – ref_id – can be (optionally) used as operation key.
Deletion: the synchronization – i.e. delete an object in CloudHealth if not included in source data – is possible with the use of a parameter for the PUT operation (from official API documentation):
allow_group_delete
Boolean that defines whether an existing Group should be deleted if the posted schema does not contain at least one rule that applies to that Group. set to “true” by default.
This should effectively synchronize the target system, based on the fact that the entire object set is provided in the PUT, as previously agreed. Unfortunately, CloudHealth have confirmed that this is currently affected by a bug, but as soon as it is fixed, it should work with no additional changes to DT.

Upgraded

Updated packaged jdk from jdk-8u191 to jdk-8u201

Bug Fix

Fixed bug relating to the use of an alternative identifier as key for POSTs to EA Agile/DGC where the key contained a space it its name.

Modified Behaviour

In DGC object export, a relationship involving two objects of the same type that have the same relationship name in both directions and are not compositions will be considered as being non-directional, and the related object should therefore appear for both the source and the target of the relationship.

Bug Fix

Fixed defect relating to object deletion from erwin EA

Bug Fix

Fixed defect where workflows involving an EA/BP adapter for a remote connection, as the source, were not showing up in the scheduler.

Bug Fix

Fixed defect where the scheduler UI was taking too long to load, making DT appear to be frozen.

Bug Fix

Fixed defect where the wrong username could be saved for an EA/BP model adapter.

Bug Fix

Installer: Fixed bug where the latest user manual was not updated if a previous version of the user manual was left over from a previous install.

8.0.0.2 - Beta (RC3)

Enhancement

Licensing: Added support for Proxy Servers when using the new licensing

Bug Fix

Remote batch jobs: Fixed an issue where remote batch jobs (PSExec) would not run

Bug Fix

Transform: Fixed a bug where newly added transforms did not have the file extension set correctly

Documentation

Help: Updated documentation details Proxy support, and better describes the use of the Open Group File Format Adapter

8.0.0.1 - Beta (RC2)

Bug Fix

Adapter: Fixed bug where Exchange connections would not appear for selection in the model configuration

Bug Fix

Transform: Fixed bug in "Sum Values in Column" transformation

Bug Fix

Compatibility: Fixed bug that prevented model backup (user will need to re-save the model adapter if created in an earlier version of DT/Collector)

Enhancement

Compatibility: Added support for SQL Server 2016. We now support SQL Server 2012r2, 2014 and 2016.

Support Change

Compatibility: Dropped support for SQL Server 2005 and SQL Server 2008

Enhancement

Added support for proxy servers

Enhancement

Added an "Integrated Security" checkbox for configuring database adapters when using SQL Server:
- Note: When running the workflow, the service execution user will be used. However, when setting up the adapter, the user that DT was run under will be used. These may be different users, and if the user that the services are run under, doesn't have access to the database, the workflow will fail.

8.0.0 - Beta (RC1)

Bug Fix

Scheduler: Fixed bug where email configuration used for email notification on job sequences could not be edited

Bug Fix

Fixed a bug where some fields would disappear from the filters list when modifying an existing workflow that used an EA Agile or DGC export adapter as a source

Bug Fix

 Fixed bug where an FTP PUT adapter could not be configured and run correctly when using folders other than "/"

Bug Fix

When configuring an FTP adapter, the correct error message will now be displayed

Bug Fix

Fixed bug that could result in persistant wait cursor when the user cancels the deletion of a workspace/model adapter

Product Licensing

Product Licensing

 

During first erwin Data Transformation log on, users will be prompted to enter an activation code. The activation code will be released by ServiceDesk. For further details on licensing, consult the erwin Data Transformation User Manual.

About Us

          About Us

Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit www.quest.com.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

Submit and manage a Service Request

View Knowledge Base articles

Sign up for product notifications

Download software and technical documentation

View how-to-videos

Engage in community discussions

Chat with support engineers online

View services to assist you with your product.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating