Welcome to ER/Studio Data Architect® 16.5 (2016+)

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 16.5

Universal mappings enhancements

Improved relationship diagramming

Improved glossary integration

Added database support

Expanded change management features

IDERA Rebranding

Supports rich text functionality on entry fields

Added the ability to inherit relationship color from parent entity

Implemented unique tokens to identify repository checkout records

Improved repository security for new users and assigned roles

what’s new in version 2016

Business Data Objects
Model/Submodel NSTs
Windows 10 Support
Teradata Support
Teradata Enhancements
SQL Azure Support

Release Notes

Important Installation Notes

Important Release Advisory

Bug Fixes

Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server

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 16.5

Universal mappings enhancements

ER/Studio Enterprise Team Edition 16.5 expands universal mapping to include mappings between entity/table and attribute/column across design layers. Users now can add and view definitions, attachments, and notes related to Universal Mappings. For more information about universal mappings, see Working with Universal Mappings.

Improved relationship diagramming

Viewing data models can occasionally become cluttered with the number of relationships associated with the model. The Data Model View in ER/Studio Data Architect 16.5 introduces a toggle option that allows you to hide or unhide one, more, or all relationships in a submodel. To hide a relationship, simply select and right-click the item(s) you want to hide or unhide, and then select either Hide Relationship or Show All Hidden Relationships from the available menu. Note that when publishing models to Team Server, all hidden relationships remain hidden in the graphical display. For more information about managing relationships, see Creating and Editing Relationships.

Improved glossary integration

ER/Studio Data Architect XE7 introduced the ability to automatically link your Team Server glossaries directly into the ER/Studio interface. ER/Studio Enterprise Team Edition 16.5 continues to improve this feature by allowing association of specific models or sub-models in a .dm1 file and repository to be associated with a specific glossary. That glossary then can provide the scope when trying to detect and link terms to the model objects. If a glossary term is used in the Name, Definition, or Notes of a model object, it is highlighted to identify that you have a definition in your Team Server Glossary. Holding your mouse cursor over the highlighted term pops up the short definition while control-clicking on the term will navigate to that term in the Team Server Glossary. For more information about glossaries, see Glossary Integration or the ER/Studio Team Server online help section about Working with Glossaries.

Added database support

ER/Studio Data Architect 16.5 now includes database platform support for IBM DB2 for z/OS v11.x and SQL Server 2016 (does not include support for SQL Server 2016 JSON capabilities). For more information about supported platforms, see Supported Database Platforms.

Expanded change management features

ER/Studio Enterprise Team edition includes additional features to expand the support for Agile change management. Users now can associate tasks from third-party tools, such as Atlassian JIRA, to specific projects available within the Repository Project Center. Similar support also is expanded in Team Server, where you can add, change, and delete the same tasks. JIRA is the only issue- and project-tracking tool supported in this release. For more information about using this feature, see Change Records and Working with Repository Projects.

IDERA Rebranding

This release begins a rollout of rebranding this product from Embarcadero to IDERA. Note that these changes include a new license agreement, installation and data directories, icons, file names, registry settings, and more. For more information about IDERA and IDERA products, see www.idera.com.

Supports rich text functionality on entry fields

All fields where a user can type names, definitions, notes, etc. now include a spell check, allow some rich text functions such as bold and underlined text, and support embedded hyperlinks. In larger fields, a text wrap feature also was implemented. Available rich text options include:

·         Text font, color, and size

·         Bold, italics, and underline

·         Format and alignment options including bullets

·         Hyperlink capability

Added the ability to inherit relationship color from parent entity

The Colors & Fonts dialog now includes the Inherit from parent entity foreground checkbox that allows users to set whether you want the outline of an entity to be the same color as its parent entities. If you select a relationship and change its color, the manual change overrides the color inherited from the parent. Changes made in a child entity do not affect the color of the parent. For more information about setting diagrams colors, see Setting Default Diagram Colors and Fonts. This option is enabled only for the following object types when selected from the drop-down list available in the Colors & Fonts dialog:

·         Relationship object type. Relationship color is the same as the parent entity foreground (border.)

·         Inherited Primary Keys object type. Primary font color is the same as parent entity foreground (border).

·         Inherited Non-Keys. Foreign key color is the same as parent entity foreground (border).

Implemented unique tokens to identify repository checkout records

In this release of ER/Studio Data Architect, checkouts now include a unique identifier or token to easily resolve identification issues when attempting to check in to the Repository. Previously, checkouts included the host machine name as part of the identifier in the checkout record. This process caused issues in virtualized environments when the host names did not match upon reconciliation at check in, perhaps because the user disconnected from the repository before checking in the work.

Improved repository security for new users and assigned roles

This release of ER/Studio Repository features the following security enhancements to the Security Center:

·         When a new user is added, the user has the ability to log into the repository but has NO ACCESS to projects. An administrator must assign a role with the proper access to this user account.

·         Role assignment is inherited by all objects under the node for which the role is specified. For example, if you grant UserA access ProjectX, then UserA can access all elements under ProjectX. But if you want to restrict UserA's access to only a single element within ProjectX, such as Model1, you can grant access to Model1 while also granting a NO ACCESS role to UserA at the ProjectX level. The lower level access to Model1 has a higher priority than the ProjectX NO ACCESS role.

For more information about managing repository security, see Establishing Security for the Repository.

What's New in Version 2016

Business Data Objects

Model/Submodel NSTs

You can now bind Naming Standards Templates to Models and Submodels

Windows 10 Support

You can now install your favorite Data Modeling software on your newest OS.

Teradata Support
We now support Teradata 15.x.

Teradata Enhancements



SQL Azure Support
Microsoft SQL Azure is now fully supported for all operations.

Release Notes

To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires ER/Studio Repository (Team Server) version 16.5 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

Important Release Advisory

Bug Fixes

Bugs Fixed in ER/Studio DA 16.5

Bug #



Column names of foreign keys in physical models are now editable when no rolename specified


Increase the length of the Attribute Name and Column Name display fields


Macros do not work and next error pops up when closing application: WinWrap Basic control isn’t registered properly on your computer


Editors no longer wrap text for definition, notes


View warning when modifying the primary key


Deleting object in BDO causes corruption, Repository errors


Column deletion field no longer disappears when resizing


The note override checkbox can now be checked


RTF codes are no longer shown incorrectly for definitions


Column comments are now shown correctly in the DDL tab


Attribute/Column Names are now saved properly from editor

Bugs Fixed in ER/Studio DA 16.0.3

Bug #



Domain-based attributes in model published in Team Server display wrong datatype.


Parentheses in DDL not correct for default values.

Bugs Fixed in ER/Studio DA 16.0.2

Bug #



Iteration over index columns shows very slow performance.


Case sensitivity issue renders the 'Hide other users' feature ineffective.


Reverse Engineer from SQL Server 2014 does not get the default values for columns.


Opening a data model crashes the application.


ERDA crashes after adding attribute to entity on a submode.

Bugs Fixed in ER/Studio DA 2016

Bug #



Roll up of one subtype among many causes FK to be removed from other subtypes.


"MIRSETUP.XML" is missing from "\MetaIntegration\conf" folder.


Default the Place New Objects Near Existing Objects parameter in the Submodel Editor to checked.


Submodel_editor option to hide existing submodels from editor.


Comment edit box is not shown on "Repository Check In" window.


Length of NVARCHAR, VARCHAR and VARBINARY is displayed as 0 instead of max.


Copy and paste of entity with varchar(max) or nvarchar(max) does not preserve the data type setting.


Teradata - Date format default value generates incorrect Syntax.


Reverse engineering Teradata column lengths are incorrect.


Teradata decimal columns are being erroneously reverse engineered from database into model as IDENTITY columns.


TERADATA - Reverse engineering CLOB columns results in defined lengths being incorrect.


Ability to generate column comments for MySQL.


Undo causes instability in Data Architect after check out from Repo.


VARCHAR(MAX) is being generated as VARCHAR(4000) for MS SQL Server 2014.


Ability to remove double quotes from table and column names.


When running a roll-up denormalization a relationship is deleted.


Dropping relationship on roll-up denormalization.


Inconsistent formatting results.


Data Diagram Version Upgrade causes instability on a database upgrade from v6.0 to v7.0.


Templated procedures now included when using GenDLLUsingFileBasedQuickLaunch.


Korean language order is showing incorrectly.


The documentation incorrectly lists that Trigger.Text is a read-write property.


XML Schema Generation, Entity Option, "Add element refs to parent entity elements" is not adding reference to parent complex type.


Data Architect becomes unstable when getting a particular model due to incorrect positions of shapes.


Option to compare schemas is missing.


Reverse engineering Teradata. Error: ‘The parameter is incorrect’.


Error when setting a named release.


Term hyperlinks are not shown with Firefox when first clicked.


Users must close and reopen the Entity Editor after applying a Naming Standards Template.


Known Issues in ER/Studio DA 16.5

Bug #



Teradata databases with collect statistics enabled cannot be reverse-engineered.


Change Records are marked as completed even if the check in fails in the Repository server.


Certain keywords cause parser errors when importing an Oracle SQL script.


Definitions and Notes are no longer wrapped in editors.


Objects included in Business Architect subject areas are not shown in Universal Mappings Editor.


The Team Server Data Source option is unavailable in the Reverse-Engineer Wizard after log in.


The Teradata JSON datatype is not imported from a SQL file.


The ContainedObject count automation method always returns 0 for Business Data Objects.


Entities remain above Business Data Objects in the diagram view after being removed.


Crashes may occur when generating reports on Japanese system with Welcome Page open.


Using the SSL option for the Repository may cause a "Socket Disconnected" error.


Errors may occur while refreshing tree nodes when working with Business Data Objects.


Teradata temporal types are not fully supported in SQL Import.


Teradata temporal types are not fully supported in Alter SQL generation.

Known Issues in ER/Studio DA 16.0.2

Bug #



Teradata JSON datatype is not imported from a SQL file.


ContainedObject count method always returns 0 for Business Data Objects.

Upgrade Instructions

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

For detailed instructions on upgrading to Team Server, see the Upgrade Notes.

Upgrades for ER/Studio Repository users

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

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 the latest upgrade notes online.

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.