Categories: Data Modeling Tools

New Features in Erwin Release 2020 R1

Use ‘Active’ Model Templates to facilitate reusable modeling metadata and to implement/enforce enterprise standards

Erwin Data Modeler is now certified to work with: Db2 z/OS v12
SQL Server 2019
PostgreSQL v9.6.15, v10.10 and v11.5
Oracle 18c (18.3)

Erwin Data Modeler now supports the new features and capabilities offered in Db2 LUW 11.1 like: Storage Group object support has been added.
Table properties for all three types (Permanent, Global Temporary, and Nickname) have been updated. Also, Index and XML Index support has been enhanced.
Tablespace properties have been updated to support Storage Space Name and Data Tag.
Materialized query table properties have been enhanced.

Erwin DM Scheduler: Enables users to define and schedule database reverse engineering (REDB) tasks in advance
Minimizes workstation contention by allowing modelers to plan for and run REDB tasks when resources are available

Users defined in Azure Active Directory can now connect to the Mart from erwin Data Modeler.

Enhanced product security measures include: Third-party components upgraded:
Tomcat v9.0.27
OpenSSL 1.1.1c
AdoptOpenJDK (build 11.0.3+7)

Erwin Data Modeler now offers an automation option for Reverse Engineering and Forward Engineering through the Erwin API.

Erwin Data Modeler includes flexible extended notes on all object types that can be: compared, searched, and edited using the Bulk Editor
reported via the Report Designer
managed using the erwin API

Erwin Data Modeler provides “native” support for Hadoop Hive as a database target – including AVRO files!

Collaboratively administer the Workgroup Edition mart using our web-based Mart Administration utility Session (Offline/Disconnect) Management
Security (User/Role) Management
AD Authentication (via LDAP)
Permission/Authorization Management
Model Locking
Collaboratively administer the Workgroup Edition mart using our web-based Mart Administration utility Session (Offline/Disconnect) Management
Security (User/Role) Management
AD Authentication (via LDAP)
Permission/Authorization Management
Model Locking

Erwin Data Modeler supports a wide variety of reports from a mart, including: administrative
cross-model
model object count reports

The erwin Data Modeler (DM) User Interface has been revamped to include the following: A Microsoft “Office-like” ribbon-based appearance
UI themes, font sizes, and component direction settings
Tabbed and “side-by-side” diagram window arrangement option
A “Quick Access” toolbar
Erwin Data Modeler supports both online and local product documentation and help.

Erwin Data Modeler has added “native” support for Redshift as a database target.
Report Designer includes the ability to create customized report filters and properties using erwin Data Modeler’s TLX scripting language

Erwin Data Modeler supports new features and capabilities offered in SQL Server like: Always Encrypted columns
Dynamic Data Masking
Temporal tables
Memory Optimized Table
Natively compiled Stored Procedures

Erwin Data Modeler supports new features and capabilities offered in SQL Server like: Always Encrypted columns
Dynamic Data Masking
Temporal tables
Memory Optimized Table
Natively compiled Stored Procedures

Erwin Data Modeler is offered as a native 64-bit application with access to sufficient memory to complete operations on large models (A 32-bit option is still available).

learndmdwbi