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.

Important Installation Notes

• To install ER/Studio Data Architect on Windows 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

• 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

Important Release Advisory

Note regarding installing on Windows 10

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 17.0 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.

Resolving a font issue after upgrading from ERDA 18.0

Some users may experience an issue after upgrading from version 18.0 that causes the Data Explorer font size to decrease. This example uses version 18.2 imagery but still is valid on subsequent releases.

To resolve a decrease in font size

1. Go to ERStudio Data Architect shortcut link on the Desktop or directly to the exe in the install folder.
2. Right click the shortcut/exe, and then select Properties.
3. Switch to the Compatibility tab, and then click Change High DPI Settings.
4. Set this property to System as shown in the following image.

   

5. Click OK, and then click Apply or OK to apply the settings change.
6. Launch ER/Studio DA and the font appears in the default size.

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 Data Architect 18.4.0

ERS-19019	Added support for PostgreSQL datatype.
ERS-24628	Corrected an issue causing ERDA to fail when opening certain models if: the model has special characters and the operating system has other regional settings.
ERS-26396	Added the ability to disable spell check functionality.
ERS-26470	Corrected an issue causing Entity and Attribute definition crashes when entering Korean or Japanese characters.
ERS-26596	Corrected an issue causing the system to not located Postgres: IDENTITY in the DDL.
ERS-26632	Corrected a generate report issue caused by special characters in German language Umlauts, such as ä, ö, and ü.
ERS-26637	Updated the Quick Start Guide to reference Business Data Objects.
ERS-26746	Improved response time when reverse engineering models with a large number of constraints.
ERS-26937	Corrected an issue causing duplicate UNIQUE INDEX statements.
ERS-27114	Added functionality to allow reverse engineering of a Snowflake database using an ODBC connection.
ERS-27138	Corrected an issue causing comments to appear before a table rename statement in the Compare and Merge utility.
ERS-27253	Corrected an issue causing an invalid index name length when generating the DDL.
ERS-27598	Corrected an issue preventing the proper display of Scandinavian characters.
ERS-27601	Corrected an issue causing ERDA to fail during some Macro Text Editor functions.
ERS-27639	Improved end-user documentation for Relationship Notation.
ERS-27645	Added support for RANGE datatype in PostgreSQL.
ERS-27650	Improved General Options settings for MongoDB models.
ERS-27791	Improved datatype handling by now converting custom serial datatype foreign key columns to integer when the parent column uses the serial datatype.
ERS-27926	Updated Redshift Reverse Engineering from script to now recognize int4 and int8.
RWP-8889	Corrected an issue preventing View attributes from displaying in View details.
RWP-8924	Corrected an issue preventing linking of terms for domains in enterprise data dictionaries.
RWP-8989	Corrected an issue that ignored Publish Models permissions when using Repository permission precedence.
RWP-9007	Improved response time of CONCATENATE_OVERFLOW_DATA during ready state publishing in Oracle environments.
RWP-9015	Corrected an issue causing the error: Publication error - The maximum recursion 100 has been exhausted before statement completion.

Bugs Fixed in ER/Studio Data Architect 18.3.0

RWP-7663	This release now allows users to maintain ad hoc reports after upgrading.
RWP-8305	Updated the self-signed certificate to use SHA-2.
RWP-8512	Users now receive notification when someone changes an object that user follows.
RWP-8537	Corrected an issue that caused Definitions with RTF formatting saved in ERDA to display a tab in Team Server.
RWP-8723	Corrected an installation issue caused when the installer encountered an existing Visual C++ redistributable.
RWP-8729	Corrected an issue that caused a Partial Success status to appear after a successful publication where submodels were deleted.
RWP-8738	Corrected an issue that caused HTML tags to appear in table definitions.
RWP-8745	Corrected an upgrade issue that resulted in the uninstallation of and failure to reinstall the the MSSQL driver.
ERS-11543	Added support for PostgreSQL to generate Alter script.
ERS-16492	Added support for SQL import of PostgreSQL.
ERS-25925	Corrected an issue causing DDL for Views in PostgreSQL 9.x to generate View comments incorrectly.
ERS-26758	Corrected an issue preventing reverse engineering with Sybase ASE 15.x or 16.x.
ERS-27335	Corrected an issue causing the improper handling of the SERIAL data type for foreign keys in PostgreSQL.
ERS-27390	Corrected issues with the Data Lineage Export to Excel macro performance.
ERS-27455	Corrected an issue causing the GUI font to shrink.
ERS-27548	Improved testing of SQL Import to PostgreSQL.

Bugs Fixed in ER/Studio Data Architect 18.2.0

RWP-8078	Security issues fixed in the Team Server application.
RWP-8573	The Team Server installer no longer changes the port to 81 when upgrading.
RWP-8772	Corrected an issue preventing some users from configuring Team Server after an upgrade.

Bugs Fixed in ER/Studio Data Architect 18.1.1

ERS-27435	The Repository is no longer reading the Auto-Publish option as also enabling the Keep Checked Out option on check-in.
RWP-8138	Reference values with large numbers of values are now shown properly in Team Server.
RWP-8703	Users can now use Windows authentication for a separate runtime user when configuring against SQL Server 2016.

Bugs Fixed in ER/Studio Data Architect 18.1.0

ERS-24305	Corrected an issue when querying a large volume of mappings in Oracle-hosted Team Server databases, which sometimes cause an ORA-01795 exception message.
ERS-25396	Corrected an issue when attempting to right-click on a relationship inside of a business data object border. This issue is resolved so that the relationship is on top, allowing selection as well as right-click for the context menu.
ERS-25424	Corrected an issue with business data objects when updating a logical model in one model file form a physical model in another file. If compare and merge included business data objects, then the model tree pane in the target model was not automatically refreshing in real time. Therefore, the refresh failed to show entities contained in the business data object. All data is correct, but the tree did not update to show these items until the next time the model was opened.
ERS-25847	Corrected an issue in the Hive physical model editor. If a user selected the check box for a complex data type, then the input field was not getting enabled to accept input.
ERS-26000	On some Windows 10 systems, when installing ERDA, a message appeared indicating that a restart was required to finish installation. However, when selecting Restart, the license dialog appeared rather than performing the restart. This issue is fixed to display the message only when necessary, and then correctly executing once 'Restart' is clicked.
ERS-26214	The user guide in ER/Studio Viewer displayed the incorrect product icon (orange), rather than the rebranded IDERA icon (green).
ERS-26234	When checking a model into the repository, some tables with the Physical Only property set to Yes occasionally appeared on the conflict resolution page. This issue occurred even though there were no changes or mismatched values.
ERS-26247	In some situations, when updating data lineage properties in the attribute editor, the application crashed when trying to resize the dialog box.
ERS-26323	Corrected an intermittent error which would sometimes cause tables designated as Physical Only to lose that property when checked into the repository.
ERS-26363	Help window incorrectly displayed 2016 for 17.0 and later releases.
ERS-26514	An incorrect warning message displayed if a user tried to rename a repository project without the proper permissions. The warning message stated that the user did not have permission to create a project. This message now is updated to clearly state that the permission applied to renaming the project.
ERS-26535	Updated the product logo in the Review and Resolve Conflicts dialog box at the repository check in.
ERS-26536	In some situations, notes and definitions that contain RTF formatting appeared on the conflict resolution dialog box during repository check in. This issue occurred even when there were no changes or conflicting values.
ERS-26538	Some property names were not showing correctly on the Review Changes dialog box during repository check in. This issue is corrected and now properly displays all property names.
ERS-26539	An error occurred when checking in a model with business data objects in which entities or tables were added to a business data object. Review Changes was not showing the detailed containment links when clicking the More button to expand information.
ERS-26541	During model check in to the repository, the Review Changes dialog box was not displaying items that had been removed from submodels.
ERS-26560	When comparing a physical model to a database, if a model object's comments contain RTF formatting, it was flagged as a difference. This issue is fixed by changing to use the plain text version of the comments when comparing to a database.
ERS-26669	A silent installation was not completing successfully on Windows 10 due to prompting for a restart confirmation that was disrupting the installation process.
ERS-26744	In some circumstances, deleting a repository project caused orphaned records in the SQL Server-hosted repository database. ER/Studio Data Architect clients could not successfully log in. This issue is corrected.
ERS-26745	Corrected DDL generation for attribute comments inherited from a domain where the domain contains RTF comment formatting.
ERS-26807	The Review Changes dialog box displayed presentation data properties that were not relevant to check in and used only for publishing in Team Server.
ERS-26815	When opening editors to review information, a Discard Changes pop-up message appeared. This occurred even when no changes are made and required the user to confirm when exiting the editor. This message was triggered incorrectly if the object contained a definition or note.
ERS-26825	Minor update to help content.
ERS-26915	Corrected intermittent error that occurred when installing an ER/Studio Data Architect build over an earlier build number within the same point release.
ERS-26980	Adding an Entity/Table to Business Data Object using the right click context menu was not functioning correctly when attempting to add to an empty Business Data Object.
ERS-27020	When reverse engineering with the model overview window open, intermittent halts occurred, displaying the message "ER/Studio has stopped working."
ERS-27053	When canceling the user or role editor windows, a "Discard Changes" warning would pop up even when no edits had been made.
ERS-27092	Corrected a memory leak in the repository server (RepoSrvDB.exe). When running for long periods of time with a high frequency of check-ins, a low virtual memory condition would occur, causing the service to terminate.
ERS-27096	In some situations, when adding a new column to a table, the text entered in the columns definition tab was not being saved.
ERS-27117	The SAP Data Services Metawizard bridge was enabled for data lineage in addition to the existing metadata import capability.
ERS-27409	In ETE environments, if Auto-publish was set to On, checking in a model change behaved as though the "keep checked out" option was specified.

Bugs Fixed in ER/Studio Data Architect 18.0.1

ERS-27184

Added a fix to SQL Server reverse-engineering with Windows authentication when using an upgraded driver.

Bugs Fixed in ER/Studio Data Architect 18.0.0

ERS-25821	Updated repository password encryption.
ERS-26137	Publishing of models into Team Server is fully redesigned. In ER/Studio Enterprise Team Edition, there now is an additional prompt allowing you to publish a model triggered at check-in, or held and not published, if desired. This feature works in conjunction with the new global publishing options in Team Server.
ERS-26385	Updated documentation for repository connection options.
ERS-26434	Corrected an issue causing RTF format tags to display some object editors.
ERS-26646	Updated the Compare and Merge CMO file to be consistent with the updated password encryption.
ERS-26945	Added a selectable SQL Server driver for forward and reverse engineering.

Known Issues

RWP-8882	Error appears when testing connection in Data Sources.
RWP-8939	Notification emails sent for disabled logins.
ERS-27526	When generating an extended alter, the temporary table is not dropped in the script when using Compare/Merge on an Amazon Redshift model.
ERS-27591	License Manager does not display Amazon Redshift.
ERS-27725	Reverse engineering does not identify MD5Hash or Disable option on user passwords.
ERS-27806	Unable to validate SQL if referenced object has a space in its name.
ERS-27807	Unable to validate procedure/function if it contains (*).
ERS-27811	Table owner/schema name is not included in generated Alter SQL file.
ERS-27816	Datatypes point, pg_lsn and bit varying incorrectly reverse engineered as char in PostgreSQL.
ERS-27822	Inconsistency with time zone property when comparing against lice database in PostgreSQL.
ERS-27823	Alter SQL not generated properly for tables with point/pg_lsn datatypes.
ERS-27824	User-modified datatype mappings not honored during SQL Import.

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.

See Also

• What's New
• Installation Guide
• Supported Database Platforms