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.
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).
