We are pleased to announce the general availability (GA) of IDERA ER/Studio Data Architect 20.5. This latest release delivers updates to support the latest versions of PostgreSQL, Snowflake, and Google BigQuery. It also allows enterprise users to connect more easily to the Team Server repository using SSO.
Key Updates in ER/Studio Data Architect 20.5:
PostgreSQL v16.x Support
- Upgrade PostgreSQL support up to version 16
- Allow include columns for Postgres
Snowflake Support
- Support for CTE views
- Support for hybrid tables
- Extended properties for a Primary Key Constraint
Google BigQuery Support
- Support for Primary, FK, unique index and column defaults
Repository Security Improvements
- Allow Data Architect to log in to the Repository via SSO using Azure Entra
Key Updates in ER/Studio Team Server 20.5:
Team Server API improvements
- API to fetch Delta changes to model objects
Security
- Updates to database access components