Release Notes
Thank you for using 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 Data Architect'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.
Contents
Important Installation Notes
- To install ER/Studio Data Architect on Windows 11, 10, 8.1, or 7, you must have administrative privileges. Once you have installed ER/Studio DA, you can then log in as a standard or limited user and use the application without having administrative privileges.
- In order to run ER/Studio DA, you must provide valid licensing information.
- When you install ER/Studio DA, certain files and directories that were previously stored under the Program Files folder are now by default installed to system-specified application data directories.
- During installation, the following directories are created:
- For Datatype Mapping Editor files, which is also the default location for user-generated Datatype Mapping files:
- C:\ProgramData\IDERA\ERStudioDA_XXXX\DatatypeMapping
- For Automation Handler files, which is also the default location for sample macros:
- C:\ProgramData\IDERA\ERStudioDA_XXXX\Macros
- For sample model files, for which a shortcut is generated in the ER/Studio DA program group:
- C:\ProgramData\IDERA\ERStudioDA_XXXX\Sample Models
- For Datatype Mapping Editor files, which is also the default location for user-generated Datatype Mapping files:
- When the application is run for the first time, the following directories are created by ER/Studio DA:
- Directories used by the Repository client to transfer files to and from the Repository server:
- C:\Users\<user>\AppData\Roaming\IDERA\ERStudio\RepoIn
- C:\Users\<user>\AppData\Roaming\IDERA\ERStudio\RepoOut
- Default directory for Report files:
- C:\Users\<user>\AppData\Roaming\IDERA\ERStudio\Report
- Default directory for SQL scripts:
- C:\Users\<user>\AppData\Roaming\IDERA\ERStudio\SQLCode
- Default directory for Quicklaunch files:
- C:\Users\<user>\AppData\Roaming\IDERA\ERStudio\XML
- Default Save location for new diagrams:
- C:ProgramData\IDERA\ERStudioDA_XXXX\Sample Models
- Directories used by the Repository client to transfer files to and from the Repository server:
Important Release Advisory
Note regarding installing on Windows
In some situations, background tasks may cause the installation to appear as though it has stopped, even though the progress on the setup window is indicating 100%. In these instances there may be a popup message indicating that a restart is required to finish installation. However, that message may be hidden behind the setup window. Try pressing ALT + TAB to bring the message to the foreground and answer to restart your computer and finish the installation.
Ensure Repository Sync
To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires ER/Studio Repository version 19.1 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 who 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 are not allowed.
Enhancements/Bug Fixes and Known Issues
Use your browser Find feature to locate a particular bug number or click a link below to see the issues addressed in a specific build.
Bugs Fixed in ER/Studio 19.2.2
| RWP-8110 | Resolves an issue causing HTML code to appear in the Definition field when exporting reports to .pdf or .xlsx. |
| RWP-8914 | Resolved an issue preventing non-admin users from saving reports. |
| RWP-9472 | Improved the error message displayed when an unauthorized user attempts to harvest Business Terms. |
| RWP-9573 | Resolved an issue causing Pentaho reports to return no results for Glossary Objects. |
| RWP-9606 | Resolved existing Cross-site Scripting (XSS) vulnerabilities. |
| RWP-9607 | Added code to ensure authentication in requests for state-changing operations. |
| RWP-9650 | Removes the user prompt and automatically uses the existing backup when upgrading from ER/Studio 19.1 to 19.2. |
| RWP-9707 | Resolves an issue preventing users from publishing to Collibra due to a unified attribute. |
Bugs Fixed in ER/Studio 19.2
| ERS-27243 | Resolves an issue causing the validation results window to scrolls to the right by default. |
| ERS-27969 | Resolves an issue causing ERDA to truncate anything with the word CAST in DDL. |
| ERS-28186 | Resolves an issue causing a macro error when using BusinessDataObjects.Count. |
| ERS-28282 | Resolves an issue preventing users form editing tables containing Korean characters. |
| ERS-28314 | Resolves an issue causing a PostgreSQL VARCHAR Off by 4 error. |
| ERS-28326 | Adds support for CREATE OR ALTER VIEW. |
| ERS-28488 | Resolves an issue in Redshift preventing DDL generation from generating Constraint name. |
| ERS-28640 | Resolves an issue preventing macro shortcuts on the Ribbon Bar from properly working. |
| ERS-28709 | Resolves an issue preventing Partition Type information from a proper save when reverse engineering. |
| ERS-28809 | Resolves an error in the macro when getting object lists from models. |
| ERS-28889 | Resolves an error in PostgreSQL reverse engineering stating the parameter is incorrect. |
| ERS-28913 | Resolves an issue causing DDL generation to create history tables after the temporal tables. |
| ERS-28930 | Resolves an issue causing the precision of datetime2 datatype to reset to 0 after SQL import. |
| ERS-28936 | Resolves an issue causing the index to disappear form the model when checking in to the repository. |
| ERS-28938 | Resolves an issue preventing reverse engineering of Azure SQL Database defaults. |
| ERS-28939 | Adds a Compare and Merge exclude option for Extended Properties tabs. |
| ERS-28946 | Resolves an issue causing only one extended property to generate when importing multiple extended properties from SQL for SQL Server. |
| ERS-28958 | Resolves an issue causing truncation when reverse engineering Procedure definitions longer than 8000 characters. |
| ERS-28990 | Resolves an issue causing a crash upgrading a diagram during CTE updates. |
| ERS-28996 | Resolves an issue causing the Business Term warning dialog to appear when creating a domain with a new attribute. |
| ERS-29001 | Resolves an issue causing a loss of Chinese characters. |
| ERS-29017 | Resolves an issue preventing Redshift SQL Import from reading constraint names. |
| ERS-29023 | Resolves an issue preventing Redshift comments from importing from a SQL file. |
| ERS-29027 | Resolves an issue causing a missing Table name in an IDENTITY_INSERT statement after a merge. |
| ERS-29048 | Resolves an issue resulting in missing generated ALTER script. |
| ERS-29051 | Resolves an issue resulting an a blank compare script generation after making changes to two tables. |
| ERS-29068 | Resolves an issue causing missing definitions in the CREATE table merge script. |
| ERS-29132 | Resolves an issue causing the Entity editor to be unusable when logged into Team Server with many terms. |
| RWP-8872 | Corrects the format when displaying bold/italic content in Glossary definitions. |
| RWP-9217 | Resolves an issue causing some migrations to ERTS 18.5 to fail due to a large amount of CLOB to CHAR or BLOB to RAW data. |
| RWP-9307 | Resolves an issue causing some diagrams to lose relationship lines in the Team Server Interactive Viewer. |
| RWP-9351 | Resolves an issue causing GET calls on SQL Server repositories to fail in diagrams with many universal mappings. |
| RWP-9439 | Resolves an issue causing carriage return characters to appear in rectangular shapes in Team Server. |
| RWP-9452 | Resolves an issue causing a typo to leads to Workspace Publishing errors. |
| RWP-9463 | Improves performance for Diagram upgrade and publishing. |
| RWP-9535 | Resolves an issue preventing users from creating large Models in Collibra. |
| RWP-9536 | Resolves an issue preventing Collibra relationships from appearing. |
Bugs Fixed in ER/Studio 19.1.1
| ERS-27243 | Resolves the View Validation Results window scroll issue. |
| ERS-28314 | PostgreSQL CHAR/VARCHAR is no longer off by four bytes when reverse-engineering. |
| ERS-28515 | Import from SQL Script for Snowflake now handles UNBOUNDED, CLUSTER BY. |
| ERS-28809 | Resolves an issue with the Macro functions on Model object lists. |
| ERS-28889 | Long object names now are supported for PostgreSQL reverse-engineer. |
| ERS-28921 | PK constraints now are properly imported from SQL on SQL Server. |
| ERS-28923 | DDL now is generated for sequences without schema names. |
| ERS-28942 | Reverse-engineering columnstore indexes with more than 32 columns completes appropriately. |
| ERS-28951 | Import from SQL Script for Snowflake handles NOT NULL DEFAULT. |
| ERS-28952 | Import from SQL Script for Snowflake handles DESC keyword. |
| ERS-28957 | Improved Procedures/Triggers syntax handling for SQL Server. |
| RWP-9458 | Created UI for WhereScape 3D integration parameters. |
| RWP-9459 | Created export facility for WhereScape 3D integration. |
| RWP-9499 | Added more built-in properties for Collibra integration for columns and attributes. |
Bugs Fixed in ER/Studio 19.1
| ERS-10996 | Includes support for external tables in Oracle 12c and later. |
| ERS-13564 | Includes support for interval partitioning in Oracle 11g and later. |
| ERS-18310 | Includes support for saving varchar size units as BYTE or CHAR for physical models in Oracle 12c and later. |
| ERS-22355 | Includes support for reference partition in Oracle 11g and later. |
| ERS-25176 | Includes support for partitioning by RANGE in Oracle 12c and later. |
| ERS-25281 | Resolved an issue causing an invalid token error for an embedded pound (£) symbol. |
| ERS-25362 | Updates the compare/merge script generation to create the FK after the parent table. |
| ERS-25414 | Updates the Oracle parser to handle function calls without parameters and parentheses. |
| ERS-25797 | Updates the INTERVAL DAY(0) datatype in the live database to no longer be reversed as INTERVAL DAY(11). |
| ERS-26416 | Resolves an issue with Alter SQL generated during extended alter for constraints. |
| ERS-26739 | Includes support for identity columns in Oracle 12c and later. |
| ERS-27129 | Resolves the Oracle create user DDL syntax. |
| ERS-27180 | Updates compare/merge to now generate the correct extended alter SQL in specific case. |
| ERS-28173 | Resolves an issue with parsing LISTAGG in the Materialized view. |
| ERS-28235 | Populate the file name for GetFilePath() in macros. |
| ERS-28625 | Retains the Quick Access toolbar and styles persistent when a style is chosen. |
| ERS-28444 | App crashes when a user performs a compare and merge against live DB. |
| ERS-28780 | Correctly reverse engineers certain views from Redshift. |
| ERS-28792 | Resolves an issue so the user is no longer prompted to override the Business Terms Value when Team Server is not configured. |
| ERS-28867 | Resolves an issue causing some users to experience a crash when upgrading a diagram during a CTE update. |
| ERS-28916 | Creates Primary Keys for PostgreSQL when generating a Physical Model. |
| RWP-9114 | Allows the Team Server admin to synchronize Collibra integration Terms. |
| RWP-9071 | Allows the Team Server admin to hide menu items based on user group. |
| RWP-9083 | Includes the ability to specify a backup folder location upon uninstall. |
| RWP-9093 | Includes support for a hyperlinked URL on a Term Custom Attribute. |
| RWP-9115 | Allows the Team Server admin to publish Logical and Physical models from Team Server to Collibra with mappings of related Terms. |
| RWP-9207 | Updates the user interface colors of tabs to be in line with other similar items. |
| RWP-9230 | Allows the Team Server admin to add custom properties to selected objects without using Enterprise Data Dictionary attachments or the Repository. |
| RWP-9249 | Replaces current Java version with AdoptOpenJDK 11. |
| RWP-9264 | Allows the Team Server admin to manage Collibra integration settings and configuration. |
| RWP-9329 | Allows viewing of attributes in ER Objects. |
Bugs Fixed in ER/Studio 19.0.1
| ERS-25202 | Supports additional features for SQL Server Temporal Tables. |
| ERS-27441 | Adds quotation marks to the Field Names when generating the database JSON. |
| ERS-28256 | Adds the Universal Mappings button to the Repository ribbon. |
| ERS-28313 | Adds the Diagram Properties button to the Model ribbon. |
| ERS-28386 | Allows user to switch between open files. |
| RWP-8839 | Adds a graphical relationship component. |
| RWP-8941 | Modifies the Business Term object page to view ER Objects graphically. |
| RWP-9096 | Allows simple relationships ("is attribute of," "is type of," "is synonymous with") between Terms. |
| RWP-9097 | Allows complex relationships ("relates to" and additional properties) between Terms. |
| RWP-9101 | Adds Parent Glossary advanced search option in the Business Terms list. |
| RWP-9102, RWP-9103, RWP-9104, RWP-9105 | Modifies the Business Term object page to:
|
| RWP-9108 | Improves Glossary deletion by allowing users to select whether they want to delete child Business Terms or leave the parent Glossary blank. |
| RWP-9109 | Modifies the CSV import/export to support relationships. |
| RWP-9166 | Modifies the Business Term object page to view related ER Objects graphically. |
Bugs Fixed in ER/Studio 19.0.0
| ERS-10973 | Supports Inheritance Relationships for PostgreSQL. |
| ERS-14719 | Supports SQL Server CTE Views. |
| ERS-16141 | Supports the 'where' clause for SQL Server and Azure SQL DB filtered index. |
| ERS-11888 | Supports extended properties for SQL Server Tables and Columns. |
| ERS-18591 | Allows users to define table compression for SQL Server and Azure DB. |
| ERS-19263 | Supports Spatial Indexes for SQL Server and Azure SQL DB. |
| ERS-20179 | Allows users to define index compression for SQL Server and Azure DB. |
| ERS-23385 | Supports the 'Columnstore' index for SQL Server. |
| ERS-25202 | Allows users to model temporal tables in SQL Server. |
| ERS-25783 | Added an option to select Azure Active Directory Password authentication support. |
| ERS-27836 | Allows TLS between Data Architect and Repository. |
| ERS-27986 | Supports the 'relates to' relationship between Business Terms and Objects. |
| ERS-27991 | Supports Azure Synapse Analytics. |
| ERS-28017 | Supports SQL Server 2019. |
| ERS-28136 | Supports MySQL 8.0. |
| ERS-28160 | Allows users to generate MongoDB model output as plain JSON. |
| ERS-28211 | Combined Repository and Team Server login features into a single dialog box. |
| RWP-9095 | Allows namespacing of Terms to parent Glossary ("is part of"). |
| RWP-9099 | Updates the Glossary page to show Terms that are namespaced to that Glossary and updates Relate options. |
| RWP-9100 | Modifies the Terms List page to include the parent Glossary name in parentheses after each Business Term name. |
| RWP-9106 | Modifies the Business Term Object page to show the parent Glossary relationship. |
| RWP-9107 | Modifies the ER Objects pages to show the parent Glossary relationship. |
| RWP-9170 | Resolves an issue preventing a user from saving edits to a Business Term when two or more terms have the same name but different Entity Types. |
Known Issues
| ERS-29296 | In Place edit datatype does not set common default values for width. |
| ERS-29324 | Meta Edges Positions are off on first load. |
| ERS-29426 | Role Names Not Propagated for Containment Lines. |
| ERS-29473 | Containment Label positions not saved. |
| ERS-29525 | Valid JSON File Fails to import due to international characters when not UTF-8. |
| RWP-9719 | DDL section has no JSON script for a table on ER Objects page after publishing a JSON Instance diagram. |
| RWP-9744 | Detail Pane is not shown on the Data Catalog page without Create permission. |
| RWP-9746 | Cannot create Data Source when logged in as a user that belongs to the Reader group with added permission. |
| RWP-9804 | Collibra connection fails after SSL certificate is updated. |
| RWP-9814 | Data Catalog Tree fails to show repeated JSON elements. |
| RWP-9823 | Logout and login required after logging into Configurator. |
Upgrade Instructions
Upgrading from ER/Studio Portal to ER/Studio Team Server
For detailed instructions on upgrading to ER/Studio Team Server, see Team Server Upgrade Notes.
Upgrades for ER/Studio Repository users
To use the repository with this release, you must run that same version number of ER/Studio Repository.
Upgrades for versions 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 Upgrading From Previous Versions.
IDERA Technical Support
To contact Support, go to Customer Support Center.