What is new in the erwin Data Modeler 12.5 release ?

erwin Data Modeler 12.5 (client)

Version 12.5 brings new features, target database updates and productivity enhancements to the Data Modeler client.

Project Explorer

Now, thanks to this new functionality, you can organize all database models in a single project within erwin DM. This way, you can save projects as folders in the location of your choice and access them easily, either from there or directly from erwin DM. On the other hand, the new Project Explorer and its toolbar facilitate and simplify the complete management of your models.

Denormalization Support for NoSQL Models

Advanced denormalisation is now available for all NoSQL database models.

Bitbucket Support

Support for Bitbucket as a Git repository has been added.

Database Version Support

1. Teradata supports version 17.x as target database.
2. MongoDB supports version 5.x and 6.x as target database.
3. AlloyDB supports version 1.1 as target database.
4. Neo4j has been certified to work with version 4.4.x.
5. Databricks Partner Connect is now available for erwin DM. In addition, Databricks supports Unity Catalog as target database.

Existing Database Support Updates

 

ArangoDB:

• Views tab: ArangoDB’s reverse engineering wizard now includes a dedicated Views tab, allowing for more streamlined management.

Avro:

• Precision and Scale properties: The Avro field editor has started to support Precision and Scale properties, which apply to the BYTES data type.

Google BigQuery:

• Support for Table Lookup Index: Support for Table Lookup Index has been added.
• Views and Materialised Views tabs: Improved Google BigQuery Reverse Engineering Wizard by adding separate tabs for Views and Materialised Views.
• Improved ER Diagrams: ER diagrams now show the column ownership mode (NULL, NOT NULL, REPEATED/ARRAY) when the ‘Show Null Column’ option is selected in the ER Diagram Editor.
• Increased Physical Table and Column Names: It is now possible to set physical table names up to 1024 characters and physical column names up to 300 characters.
• Default Collation Property: The ‘Default Collation’ property has been added to the Google BigQuery Dataset Editor and Table Editor.
• Default Collation and Expression properties: The ‘Default Collation’ and ‘Default Expression’ properties are now available in the Google BigQuery Table Column Editor.
• Improved Partitioning Options: The Partition Options properties have been moved to the ‘Partitions’ tab of the Google BigQuery Table Editor.
• Partition Expression Update: The Partition Expression section no longer displays in the Partitions tab of the Google BigQuery Table Editor and Materialized View Editor. Instead, it is now displayed in the NoSQL tab of the Google BigQuery Table Editor and Materialized View Editor.
• Automatic Reset of Partition Expression Options: From now on, Partition Expression Options values will be automatically reset when a column of a different physical data type is selected in the Partition Columns section of the Google BigQuery Table Editor and Materialized Views Editor.
• Wizard Updates: The Options Selection tab of the Google BigQuery Advanced Engineering Schema Generation Wizard has been updated. In addition, a new tab called Owner Override has been added.

Cassandra:

• Materialised Views tab has been added to Cassandra’s Reverse Engineering Wizard, making it easier to visualise and analyse data.

Couchbase:

• The erwin Data Modeler (erwin DM) now supports the use of Couchbase with the Python SDK, replacing the previous support for the C SDK. This allows for a more flexible and efficient integration with Python.

DynamoDB:

• The character limit for physical table names and indexes has been increased, allowing up to 255 characters to be set. In addition, session token authentication has been added, improving the security of connections to DynamoDB.

Redshift:

• Redshift Encoding AZ64: Support for Redshift Encoding AZ64 has been added.

MongoDB:

• Improved schema validation options: Schema validation options have now been optimised to facilitate forward engineering of a model.
• Display Field is Required Option: The Display Field Null Option property of the MongoDB ER Diagram Editor has been replaced by the new Display Field is Required Option property.

JSON:

• Display Field is Required Option: The Display Field Null Option property of the JSON ER Diagram Editor has now been replaced by Display Field is Required Option.
• JSON Array Element Option: The JSON Reverse Engineering Wizard now includes a JSON Array Element option, which allows you to specify whether to process the entire contents of the JSON array or just the first element during reverse engineering.
• Improved Viewer tab: The Viewer tab of the JSON Reverse Engineering Schema Generation Wizard has recently been improved. It now displays both the names of JSON objects and arrays and the number of child elements they contain.

Productivity and UI Enhancements

Several additions and enhancements have been implemented to improve erwin DM’s productivity and usage experience. These enhancements are:

• Copy Family: You can now create new ER diagrams using whole or part of model object families from existing diagrams.
• Recent Files: The Recent Files list in the erwin DM Welcome screen now displays the latest version of the Mart models instead of the version that was last accessed.
• Demand Loading: To improve project loading time, Demand Loading option for projects has been added to erwin DM Options.
• Scheduler: Support for projects has been added to erwin DM Scheduler. You can now schedule reverse engineering jobs for all the required models in a project using erwin DM Scheduler.
• Project Explorer: erwin DM now displays models with configured connection parameters for reverse engineering in the Project Explorer with a green check mark.
• Custon Option Set: You can now create and use custom option sets for Complete Compare in erwin DM Scheduler.
• Exclude UDP: You can now choose to exclude User Defined Properties (UDP) during Complete Compare to accelerate the process.
• SDI Indication on Model Diagram: For columns or attributes labelled SDI, you can now choose to display an SDI indication on the model diagram via diagram properties.
• Column Sort Order: NoSQL databases now support column sort order function in addition to SQL databases.

erwin Mart Server 12.5

Erwin Mart Server serves as the primary engine for storing and accessing erwin Data Modeler Workgroup Edition repositories. This engine is available both as user-deployable software and as a service (SaaS). In version 12.5, a number of new features and enhancements have been incorporated, including the following:

– erwin ER360

erwin ER360 optionally complements the erwin Mart server, both on premises and in the cloud (SaaS). It facilitates managed self-service access to detailed metadata and data model visualisations via a web browser. In this way, it fosters collaboration between business teams, governance teams and other stakeholders, improving data literacy.

– erwin Mart Portal (formerly erwin Mart Administrator)

erwin Mart Portal now allows viewing permissions to be set on libraries, ensuring that users only access those libraries they are authorised to view. In addition, the Catalogue Manager highlights models containing Personally Identifiable Information (PII) with a ‘PII’ label.

– Enterprise Modelling Compliance

To ensure data quality, Enterprise Modelling Compliance (EMC) is now part of the erwin Mart Portal. With this tool, users define custom policies and rules to ensure data compliance in database models stored in Mart. They can also create custom jobs to enforce these policies. This generates detailed reports that include statistics on passes, errors and warnings.

– Enterprise Glossary

With Enterprise Glossary, you can assign business terms to objects in your data models. These business terms, which represent vocabularies used in projects, departments or functions within your organization, are grouped together in the glossary. In addition, you have the ability to associate these glossaries to the model, which allows you to map the business terms to the corresponding objects. As a result of these mappings and associations, it is possible to generate reports showing the relationships between the model name and the number of unmapped objects. Such reports include details such as model name, object type, object name and mapped term.

– DM Connect for DI Support

DM Connect for DI makes it easy for Mart administrators to export model metadata to erwin Data Intelligence (DI). This tool now includes support for the following features:

• Business entity types: When exporting the model, the system saves the business entity type (i.e., the system environment type) within the environment details in erwin DI.
• Validation rules: In addition, on each export, the system records the validation rules as extended properties in erwin DI.

– Git Support
You can now view the DDL of one version of the model and compare it with another directly from the Catalogues panel.

 

Are you ready to discover the new and exciting features of erwin Data Modeler (erwin DM)?

Schedule a live demo with our software experts and discover how erwin DM can transform your modelling and data management practices. To book your demo or for more information, please contact our dedicated team at info@sandhillconsultants.com

Don’t miss the opportunity to try erwin DM with a free trial version. Sign up now and tap into the potential of seamless data modelling and superior productivity.