Previous Topic: Release Numbering Scheme in erwin Data ModelerNext Topic: Academic Edition


What's New

This section includes the new features and enhancements for erwin Data Modeler Release 9.8. The list includes a brief description and wherever relevant, a reference to more information about each feature.

Microsoft SQL Server Support

erwin Data Modeler now supports several features of SQL Server versions 2012, 2014, and 2016, as follows:

PostgreSQL Support

erwin Data Modeler now supports PostgreSQL 9.6.2 and is certified to work with PostgreSQL 9.6.5.

Note: Reverse Engineering from Script (RES) is not supported.

Hadoop Hive Support

erwin Data Modeler has added native support for Hadoop Hive 2.1.x as a target database. This implementation supports both, MySQL and PostgreSQL metastores.

Note: For FE or Alter Script process, on the Hive Connection dialog, always set the Metastore Database to Default and the ODBC Data Source to relevant Hive connection driver.

Cloud-based Licensing Service

erwin now uses a cloud-based software licensing service to cater to licenses for all the erwin Data Modeler (DM) editions. For more information, refer to the Licensing topic in the erwin Installation Guide.

Report Designer

The Report Designer now lets you customize the colors for PDF reports.

erwin DM NoSQL Support

erwin Data Modeler supports connection to erwin DM NoSQL the File menu, where you can model and manage your unstructured cloud data.

IIS Port Number Configuration

erwin Data Modeler and Mart Server now let you configure Mart on a port other than the default port, 80.

Teradata Support

erwin Data Modeler is now certified to work with Teradata v16.10.

SAP ASE Support

erwin Data Modeler is now certified to work with SAP ASE 16 SP02.

Oracle Support

erwin Data Modeler is now certified to work with Oracle 12c R2.

Productivity Enhancements

The overall productivity of erwin Data Modeler has been enhanced with the following functionalities and workflows:

Metadata Integration Bridges Updates

erwin Data Modeler has been updated to support several new import Metadata Integration Bridges as follows:

  1. Alteryx - Beta Bridge
  2. Alteryx Repository - Beta Bridge
  3. Amazon S3 - Beta Bridge
  4. Apache Hadoop Hive Database (Hive Metastore via JDBC) - Beta Bridge
  5. Apache Avro Database Files (JSON)
  6. Apache CouchDb Database (JSON)
  7. Microsoft SQL Server Database SQL DDL - Beta Bridge
  8. Teradata Database SQL DDL
  9. File System - Beta Bridge
  10. Apache Hadoop HBase Database (Java API)
  11. Actian Vector (Vectorwise) Database (via JDBC)
  12. HP Vertica Database (via JDBC)
  13. Microsoft Azure SQL Database (via JDBC)
  14. Oracle MySQL Database (via JDBC)
  15. MarkLogic NoSQL Database (for JSON only)
  16. Apache Parquet Database Files
  17. QlikSense
  18. Talend Data Preparation

Also, the following Metadata Integration Bridges have been renamed:

Old Name

New Name

Apache Cassandra - New Beta bridge

Apache Cassandra Database

DataStax Enterprise (Cassandra) - New Beta bridge

DataStax Enterprise (Cassandra)

Apache Hadoop Hive Server

Apache Hadoop Hive Database (HCatalog via JDBC)

Cloudera Enterprise Hadoop Hive Server

Cloudera Enterprise Hadoop Hive Database (HCatalog via JDBC)

Hortonworks Hadoop Hive Server

Hortonworks Hadoop Hive Database (HCatalog via JDBC)

MapR Hadoop Hive Server

MapR Hadoop Hive Database (HCatalog via JDBC)

COBOL Copybook File

COBOL Copybook Database Files

Database SQL Data Definition Language (DDL) - New Beta bridge

Database SQL Data Definition Language (DDL) - Beta Bridge

Oracle Database SQL DDL - New Beta bridge

Oracle Database SQL DDL

Flat File Database (CSV or Excel) - New Beta bridge

Flat File Database (CSV or Excel) - Beta Bridge

Google BigQuery

Google BigQuery Database

JSON (JavaScript Object Notation) Files - New Beta bridge

JSON Database Files

MicroStrategy MDX Adapter (via ODBO)

MicroStrategy MDX Adapter (via ODBO) - Unsupported EOL Bridge

SAP NetWeaver Business Warehouse (BW) (via ODBO)

SAP NetWeaver Business Warehouse (BW) (via ODBO) - Unsupported EOL Bridge

SAS OLAP Server (via ODBO)

SAS OLAP Server (via ODBO) - Unsupported EOL Bridge

Microsoft SQL Server Analysis Services (SSAS) 2005 to 2012 (Repository)

Microsoft SQL Server Analysis Services (SSAS) 2005 to 2014 (Repository)

Microsoft SQL Server Analysis Services (SSAS) 2005 to 2012 (File)

Microsoft SQL Server Analysis Services (SSAS) 2005 to 2014 (File)

MongoDB - New Beta bridge

MongoDB Database (JSON)

OMG CWM Pre-1.0 XMI 1.1

OMG CWM Pre-1.0 XMI 1.1 - Unsupported EOL Bridge

Oracle Business Intelligence (OBI) Server

Oracle Business Intelligence (OBI) Repository (RPD file)

Old Name

New Name

OMG CWM Pre-1.0 XMI 1.1

OMG CWM Pre-1.0 XMI 1.1 - Unsupported EOL Bridge

SAP PowerDesigner OOM 9.x to 15.x (via UML 1.x XMI)

SAP PowerDesigner OOM 9.x to 15.x (via UML 2.x XMI)

Password Policy

The password policy for erwin has been updated. A password should fulfill the following criteria:

Apart from the above criteria, special characters are optional. This validation is applicable to reset, change, and forgot password processes.

Also, if you enter an incorrect password five consecutive times, your account will be locked for five minutes (300 seconds) by default.

While upgrading from 9.x to 9.8, if the existing password does not meet the updated password policy, you will be redirected to change the password.