Page History
| Table of Contents | ||||
|---|---|---|---|---|
|
What's New in ER/Studio Data Architect
...
21.
...
0.x
For the new features and fixed issues in the latest version of ER/Studio Data Architect, see What's New.
System Requirements
Type | Platform | Version |
|---|---|---|
| Random Access Memory (RAM) |
| |
| Storage Disk Space |
| |
| Operating System | Microsoft Windows (64-bit) |
|
Repository (ER/Studio Data Architect Professional only)
The Repository for ER/Studio Data Architect Professional is packaged with ER/Studio Team Server and must be installed on a separate server. For more information about ER/Studio Team Server, see ER/Studio Team Server Technical Specifications.
Database Platform Support
...
| Platform | Version | Platform | Core Platform |
|---|---|---|---|
| Amazon Redshift | n/a | S M | Yes |
| Databricks | n/a | S M | Yes |
| Embarcadero InterBase |
| M | |
| Firebird |
| M | |
| Google BigQuery | n/a | S M | Yes |
| Greenplum (Pivotal) |
| M | |
| Hadoop Hive |
| M | |
| Hitachi HiRDB | n/a | M | |
| IBM Db2 Common Server | n/a | M | |
| IBM Db2 for iSeries |
| M | |
| IBM Db2 for Linux, UNIX, and Windows (LUW) |
| S M | Yes |
| IBM Db2 for z/OS |
| S M | Yes |
| IBM Informix Dynamic Server |
| M | |
| IBM Informix OnLine and SE | n/a | M | |
| IBM Netezza |
| M | |
| JSON (Instance and Schema Files) | n/a | S M | |
| Microsoft Access |
| A | |
| Microsoft Azure SQL Database | n/a | S M | Yes |
| Microsoft Azure Synapse Analytics | n/a | S M | Yes |
| Microsoft SQL Server and Microsoft SQL Server on Azure Virtual Machine (VM) |
| S M | Yes |
| Microsoft Visual FoxPro |
| A | |
| MongoDB |
| S M | |
| MySQL |
| M | |
| Oracle Database |
| S M | Yes |
| PostgreSQL |
| S M | Yes |
| M | ||
| SAP Adaptive Server Anywhere (ASA) |
| M | |
| SAP Adaptive Server Enterprise (ASE) |
| S M | Yes |
| SAP IQ |
| M | |
| Snowflake | n/a | S M | Yes |
| Teradata |
| S M | Yes |
| Generic DBMS | n/a | A |
...
ER/Studio Data Architect includes a subset of MetaWizard import bridges to access files from common modeling tools.
ER/Studio Enterprise Team Edition includes the full list of MetaWizard import and export bridges that can import metadata from a wide range of technologies such as databases, data lake structures, flat files, business intelligence (BI), and data movement (ETL) tools.
...
| Table of Contents | ||||
|---|---|---|---|---|
|
Version 21.0.1
- There are no new features but there are some fixed issues in this release.
Version 21.0
- Updates ER/Studio branding
- Introduces the AI Chatbot
- Adds support for Cross Database References in Views
- Improves repository security by allowing ERDA to log in via SSO using Okta
- Adds support for TLS 1.3
Version 20.9.1
- There are no new features but there are some fixed issues in this release.
Version 20.9
- Supports JSON complex columns in traditional databases
Version 20.8
- Introduces AI Model Builder capabilities
Version 20.7
- Adds support for JSON Examples field
Version 20.6
- Provides workflow macros to generate Data Vault assets from model objects
- Adds support for external tables in Azure SQL DB, Azure Synapse, and SQL Server
- Adds support for Oracle 23ai / 23c
- Adds support for SQL Server 2022
- Adds the Switch Object Class button for Databricks and Google BigQuery
Version 20.5.1
- Adds support for PostgreSQL up to version 16.x
- Improves support for Google BigQuery
- Improves support for Snowflake
- Improves repository security by allowing ERDA to log in via SSO using Microsoft Entra ID
Version 20.3.1
- There are no new features but there are some fixed issues in this release.
Version 20.3
- Adds support for Git
...
- Supports Azure Active Directory Password authentication method
- Allows users to log in to Team Server when logging into Repository
- Allows users to relate Business Terms with ER Objects
- Supports the 'where' clause for SQL Server and Azure SQL DB filtered index
- Supports the ‘Columnstore’ indexes for SQL Server 2012
- Supports Spatial Indexes for SQL Server and Azure SQL DB
- Allows users to define table and index compression for SQL Server
- Allows users to model temporal tables in SQL Server
- Supports extended properties for SQL Server Tables and Columns
- Supports SQL Server 2019
- Adds tolerance support for MySQL 8.0
- Allows users to generate MongoDB model output as plain JSON
- Supports Azure Synapse Analytics
- Supports Inheritance Relationships for PostgreSQL
- Allows TLS between Data Architect and Repository
- Supports WITH CTE for SQL Server 2005+, Azure SQL DB, and Azure Synapse Analytics
Version 2016 JA
- Supports Windows 7, 8, 8.1, and 10; Windows Server 2008, 2008 R2, and 2012; limited support on Windows 11 (Embedded browser-based on IE does not work)
- Documentation is available at https://docwiki.embarcadero.com/ERStudioDA/2016/ja