Video : ER/Studio Enterprise Team Edition

ER/Studio 18.3 contains support for the latest versions of the PostgreSQL database in both ER/Studio Data Architect and ER/Studio Team Server. Customers using this database platform will benefit from this release. We have also added additional support for the Amazon Redshift platform, and a new notification feature in ER/Studio Team Server.

Improvements to ER/Studio Data Architect 18.3 appear in the following areas:

• PostgreSQL support

– Support for newer versions of PostgreSQL from 9.5 through to 12
– Import from SQL file
– Generate alter script from compare and merge operation
– PostgreSQL data types. Note, we omitted some types. Special functionality that sets foreign key properties created against serial data type to integer.
– PostgreSQL procedures in physical models
– PostgreSQL functions in physical models

• Amazon Redshift support

– Redshift procedures, functions, users, and schemas in physical models

• Meta Integration Technology, Inc. (MITI) bridge support

– 15 new import bridges for ER/Studio Enterprise Team Edition, including data cataloging bridges with enhanced handling of flat file formats for platforms such as Azure Data Lake Gen2.

Improvements to ER/Studio Team Server and Repository 18.3 appear in the following areas:

• Change notifications

– When users follow an object, they can opt to be emailed notification of changes to the object. For example, it can notify a developer who has code accessing a table if the structure of that table changes.

• Certified Team Server Repository against Microsoft SQL Server 2019
• Bug fixes

Watch this video to see ER/Studio 18.3 in action.