Welcome to ER/Studio Data Architect 19.2

ER/Studio Home | ER/Studio Documentation | IDERA Technical Support | www.idera.com


Thank you for using IDERA ER/Studio Data Architect, previously known as ER/Studio, the award-winning data modeling application for logical, and physical database design and construction. ER/Studio Data Architect's (ER/Studio DA) powerful, multi-level design environment addresses the everyday needs of database administrators, developers, and data architects who build and maintain large, complex database applications.

ER/Studio DA's progressive interface and processes have been logically organized to effectively address the ease-of-use issues that have plagued data modeling tools for the past decade. The application facilitates your ability to create, understand, and manage the mission-critical database designs within an enterprise. It offers strong logical design capabilities, bidirectional synchronization of logical and physical designs, automatic database construction, accurate reverse engineering of databases, and powerful HTML-based documentation and reporting facilities. Before you use ER/Studio, please read the information below.

See the most recent documentation at the IDERA Web site, https://www.idera.com/support/productdocuments


WHAT'S NEW in version 19.2

Improves support MongoDB and JSON Instance

Includes hierarchical visualization of MongoDB, XML, and JSON

Supports JSON Instance files

Allows users to switch between MongoDB and JSON Instance hierarchical platforms

WHAT'S NEW in version 19.1.1

No new features

WHAT'S NEW in version 19.1

Adds support for multiple Oracle 12c and later features

Adds support for multiple Oracle 11g and later features

WHAT'S NEW in version 19.0.1

Supports additional features for SQL Server Temporal Tables

Allows users to switch between open files

Adds the Universal Mappings button to the Repository ribbon

Adds the Diagram Properties button to the Model ribbon

Adds quotation marks to the Field Names when generating the database JSON

WHAT'S NEW in version 19.0

Supports Azure Active Directory Password authentication method

Allows users to log in to Team Server when logging into Repository

Supports the ‘relates to’ relationship between Business Terms and Objects

Supports the ‘where’ clause for SQL Server filtered index

Supports the ‘Columnstore’ index for SQL Server

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

Supports 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 SQL Server CTE Views

Release Notes

Important Release Advisory

Important Installation Notes

Bug Fixes and Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server

Upgrades for ER/Studio Repository Users

Upgrades for version of ER/Studio Repository prior to 2016

Additional Resources

Licensing Your IDERA Product

IDERA Product Support

IDERA Technical Support

IDERA on the Web

What's New in Version 19.2

Improves support for MongoDB and JSON Instance

This release of ER/Studio Data Architect includes many improvements to supporting MongoDB and JSON Instance.

·        Adds support for MongoDB 4.x

·        Includes SCRAM authentication option as default for MongoDB

·        Supports importing JSON Objects from JSON documents

·        Supports switching a MongoDB object's class between Collection and Nested Object

·        Improves Logical to Physical conversion to MongoDB

·        Improves compare/merge options to MongoDB Physical Models

·        Supports repeated Elements in hierarchical Models

·        Adds Denormalization tools for hierarchical Objects

·        Adds source code to the Object Editor DDL tab

·        Adds a relationship validity check and display

Includes hierarchical visualization of MongoDB, XML, and JSON

ER/Studio 19.2 includes the following improvements to support a hierarchical visualization of MongoDB, XML, and JSON content:

·        Provides a roll-up view for hierarchical Models

·        Provides a roll-up Contained Objects view for hierarchical Models

·        Provides Repeated Object icons for nested Objects

·        Provides Expand/Contract icons for roll-up views

·        Allows users to set data types during In Place Editing

·        Provides keyboard entry tools for roll-up views

·        Supports Move function for roll-up views

·        Provides parent/child Entity switch icon in Table Editor

Supports JSON Instance files

ER/Studio 19.2 includes tolerance support for JSON Instance.

Allows users to switch between MongoDB and JSON Instance hierarchical platforms

Users now can switch the database platform of a physical data model ONLY between hierarchical model platforms. Use Change Database Platform to switch from MongoDB to JSON Instance and vice versa, but not to any non-hierarchical platforms.

What's New in Version 19.1.1

There are no new features in this release of ER/Studio Data Architect. There are numerous fixed issues that you may review in the Release Notes.

What's New in Version 19.1

Adds support for multiple Oracle 12c and later features

ER/Studio Data Architect 19.1 includes support for the following features in Oracle 12c and later:

·        External tables. External tables allow Oracle to query data stored outside of the database in flat files. Use the Table Editor option to designate an external table and gain access to the External Table Properties dialog for further definition of the table. For more information about this feature, see Defining Table Storage: Oracle 12c and Later Storage Options.

·        Saving varchar size units as BYTE or CHAR for physical models. For more information about this feature, see Defining Model Options for the Selected Model and Generating a Physical Data Model.

·        Subpartitioning by RANGE. Range partitioning distributes data based on a given range, as in time intervals and allows you to easily add new data while purging older data. For more information about this feature, see Subpartition Editor.

·        Identity columns. Identity columns allow you to auto-increment values each time you add a row. You can set only those columns having a Data Type of Number as identity columns, and you may have only one Identity column per table. For more information about this feature, see Creating and Editing Columns: Datatype tab.

Adds support for multiple Oracle 11g and later features

ER/Studio Data Architect 19.1 includes support for the following features in Oracle 11g and later:

·        Interval partitioning. Interval partitioning automatically partitions a database at specified intervals when new data added to the table exceeds all of the specified range partitions to avoid insert failures. Use the Partition tab of the Table Editor to set what interval is in use. For more information on this feature, see Partitioning a Table: Table Partition Options for Oracle.

·        Reference partitioning. Reference partitioning allows you to partition two tables that are related based on an existing parent-child relationship. You can manage partition keys and types on the Partition tab of the Table Editor. For more information on this feature, see Partitioning a Table: Table Partition Options for Oracle.

What's New in Version 19.0.1

Supports additional features for SQL Server Temporal Tables

ER/Studio Data Architect 19.0.1 includes additional support for SQL Server Temporal Tables, allowing users to designate in-memory tables and have Data Architect check whether the columns are suitable as not all datatypes are supported for in-memory. For more information about this feature, see Microsoft SQL Server Table Storage Options.

Allows users to switch between open files

This release includes the addition of the Switch Windows button in the Diagram ribbon. This button allows the user to switch and view each of the different open files.

Adds the Universal Mappings button to the Repository ribbon

The new Universal Mappings button on the Repository ribbon allows users to create links between objects across models, which are visible in the Where Used tab of Objects and in Team Server Core.

Adds the Diagram Properties button to the Model ribbon

The new Diagram Properties button on the Model ribbon allows users to easily set properties for the diagram file.

Adds quotation marks to the Field Names when generating the database JSON

New options allow users to select how the plain JSON output is generated from MongoDB-specific content. For more information about this feature, see MongoDB JSON Generation.

What's New in Version 19.0

Supports Azure Active Directory Password authentication method

This version of ER/Studio Data Architect supports Azure Active Directory – Password as an authentication method in Azure SQL Database available in the following scenarios:

·        Reverse engineering objects from Azure SQL Database with a direct connection.
In the Authentication field of the Reverse Engineering Wizard, select the Azure Active Directory – Password option. For more information about this feature, see Reverse Engineering an Existing Database.

·        Forward engineering to Azure SQL Database using a direct connection.
In the Authentication field of the DDL Generation Wizard, select the Azure Active Directory – Password option. For more information about this feature, see Generating a Script File or Database.

·        Compare/Merge with a live database for Azure SQL Database using a direct connection.
In the Authentication field of the Compare and Merge Utility, select the Azure Active Directory – Password option. For more information about this feature, see Using the Compare and Merge Utility.

Allows users to log in to Team Server when logging into Repository

The separate Repository and Team Server login menu buttons and dialog boxes now are combined, allowing users to optionally connect to Repository and Team Server at the same time. The single Log In button opens a dialog box that includes areas for both components. For more information about this feature, see Logging In and Out of the Repository and ER/Studio TS.

Supports the ‘relates to’ relationship between Business Terms and Objects

ER/Studio Data Architect now allows association between business terms in Team Server and objects in Data Architect by using the relates to relationship. Objects that support this capability include Entity, Table, Attribute Column, and Domain. For more information about this feature, see the What’s New topic Supports the 'relates to' relationship between Business Terms and Objects.

Supports the ‘where’ clause for SQL Server and Azure SQL DB filtered index

ER/Studio Data Architect now supports the where clause for SQL Server 2008+ and Azure SQL DB filtered index. For more information about this feature, see Microsoft Access, Azure SQL DB, and SQL Server Index Options.

Supports the ‘Columnstore’ index for SQL Server

ER/Studio Data Architect now supports the Columnstore index for SQL Server 2012+. For more information about this feature, see Microsoft Access, Azure SQL DB, and SQL Server Index Options.

Supports Spatial Indexes for SQL Server and Azure SQL DB

The new Spatial tab in the ER/Studio Data Architect Index Editor allows users to configure geo-spatial indexes for SQL Server 2012+ and Azure SQL DB platforms. For more information about this feature, see Spatial tab.

Allows users to define table and index compression for SQL Server

This version of ER/Studio Data Architect allows users to define table and index compression for SQL Server and Azure SQL DB platforms. The Compression option allows you to choose from row or page compression types when using compression and the On Partitions options lets you specify which partitions are affected. For more information about these features, see Microsoft SQL Server Table Storage Options and Microsoft SQL Server Index Storage Options.

Allows users to model temporal tables in SQL Server

The ability for users to model temporal tables for SQL Server 2016 and later is now included in ER/Studio Data Architect. The System Versioning Properties feature allows you to select between anonymous or a named History Table when using temporal tables. For more information about this feature, see Microsoft SQL Server Table Storage Options.

Supports extended properties for SQL Server Tables and Columns

The new Extended Properties tab exists for SQL Server Tables and Columns to manage a list of extended properties. You can add, edit, and delete property values and descriptions. For more information about this feature, see Extended Properties tab Table options and Extended Properties tab Column options.

Supports SQL Server 2019

ER/Studio Data Architect now supports SQL Server 2019 database platform. For more information about supported databases, see Supported Database Platforms.

Supports MySQL 8.0

ER/Studio Data Architect now supports MySQL 8.0 database platform. For more information about supported databases, see Supported Database Platforms.

Allows users to generate MongoDB model output as plain JSON

Users now can use the Output as plain JSON checkbox to remove all MongoDB-specific constructs when generating a database for a MongoDB model. This option removes MongoDb constructs such as ObjectId() and instead a generic JSON is generated. For more information about this feature, see MongoDB JSON Generation.

Supports Azure Synapse Analytics

ER/Studio Data Architect now supports Azure Synapse Analytics. For more information about supported databases, see Supported Database Platforms.

Supports Inheritance Relationships for PostgreSQL

This release of ER/Studio Data Architect add support for Inheritance Relationships for PostgreSQL. The Inherits checkbox in the Properties tab is enabled only for Identifying Relationships. When this option is checked, all other properties on the Properties tab are unavailable (greyed out). For information about creating a new inheritance relationship, see Creating a New Inheritance Relationship.

Allows TLS between Data Architect and Repository

This version of ER/Studio Data Architect allows you to use TLS between Data Architect and Repository. For more information about this feature, see How to Specify Repository Ports.

Supports WITH CTE for SQL Server 2005+, Azure SQL DB, and Azure Synapse Analytics

ER/Studio now supports the WITH common table expression on Views for SQL Server 2005 and later, Azure SQL DB, and Azure Synapse Analytics. You can use a CTE clause in a CREATE VIEW statement as part of its defining SELECT statement. Note that you can apply multiple CTEs to a view and that CTEs can be recursive. For more information about this feature, see Creating and Editing Database View With (CTE) tab.

Release Notes

Important Release Advisory


To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires ER/Studio Repository (Team Server) version 19.1 or later for all Repository operations.

ER/Studio Portal is no longer supported by ER/Studio Data Architect. Most functionality formerly provided by ER/Studio Portal is now provided by ER/Studio Team Server. Users that formerly used the Repository tab to browse the portal can use a Web browser instead.

License Enforcement

When working with the Repository, all users must use the same license type. ER/Studio now enforces this by marking the Repository as an Enterprise Team Edition Repository when a user with an Enterprise Team Edition license logs in. Subsequent log in attempts by users with a non-Team Edition license will not be allowed

Important Installation Notes


Bug Fixes and known issues


For the more recent list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/ERStudioDA/192/en/Release_Notes.

Upgrade Instructions

Upgrading from ER/Studio Portal to ER/Studio Team Server


For detailed instructions on upgrading to Team Server, see Install or Upgrade Team Server and Repository.

Upgrades for ER/Studio Repository users


To use the repository with this release, you will need to be running ER/Studio Repository (Team Server) 19.0 or later.

Upgrades for version of ER/Studio Repository prior to 2016


Repository is now installed as part of Team Server. To upgrade an earlier version of Repository, please see About Team Server and Repository Upgrade.

Additional Resources

Licensing Your IDERA Product

All IDERA products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the Quick Start Guide. If you have not yet purchased this product, contact [email protected].

IDERA Product Support

The IDERA Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the IDERA Knowledge Base. Visit www.idera.com/support, or click any of the links below, to find:

IDERA Technical Support

If you have a valid maintenance contract with IDERA, the Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of IDERA products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Customer Support Center. For additional information about IDERA Technical Support, visit the Support section of our Web site.

IDERA on the Web

To download evaluations of other IDERA products or to learn more about our company and our products visit us at www.idera.com.