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
  • Overall modeler productivity has been enhanced via new product functionality and workflows: A “quick” compare option set and “speed” option
    Supertype-Subtype transformation updated to retain separate logical and physical constructs for Identity and Roll-Up option selections
    Deletion of a relationship offers modeler the option of converting migrated FK attribute(s)/column(s) into child entity/table owned attribute(s)/column(s)
    Mart OPEN dialog now displays number of entities, attributes and relationships
    Mart and mart report performance has been significantly improved
    Database “Target server” dialog can be accessed by clicking the database name displayed on the physical model status bar
  • Naming Standards enhanced to fully support physical-to-logical name mapping
  • 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 SCAPI has been extended to support the application of naming standards.
  • Erwin Data Modeler provides “native” support for Hadoop Hive as a database target – including AVRO files!
  • Licensing improvements include: Silent Install
    Option to “hide” Licensing dialog
    Support for proxy connections to the License/Activation server
    Optional network domain name and subnet IP-based usage restrictions
    erwin Data Modeler “edition”-based licensing
    The ability to “borrow” (Long Term Check Out) cloud-based concurrent licenses
  • 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
  • User enhancements and modeling improvements include: A new option has been added to allow modelers to enforce Relationship Nullability Rules
    A new option has been added to allow modelers to enforce Supertype-Subtype relationship rules
    Oracle 12c support for 128 character TABLE and COLUMN Names and PostgreSQL support for 63 character TABLE and COLUMN names
    New support added for relationship cardinality ranges (for example, 1..5)
    New “Forward Engineering” wizard
    Ability to tag ATTRIBUTES/COLUMNS as PII
    Support for Hive VIEW Partitions
  • 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).

Leave a Reply

Your email address will not be published. Required fields are marked *