Release Notes

Welcome to ER/Studio Data Architect 11.0.1

ER/Studio Home | Documentation | Technical Support | Embarcadero.com

Read Me Last Updated: July 08th, 2015.

---

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.

Release Notes

Important Installation Notes
Important Release Advisory
Bug Fixes

Upgrade Instructions

Upgrading from Embarcadero Connect to ER/Studio Team Server
Upgrades for ER/Studio Repository users
Upgrades for version of ER/Studio Repository prior to 7

Release 11.0.1 features summary:

Submodel Editor improvements

To reduce opening times for larger models, the 'Limited Submodel Editor' option allows you to limit the amount of submodels that are loaded in to the editor when opening.

You are now able to create any submodel at the root of the model, just by selecting the 'create at root' selection box of the submodel interface.

Bug Fixes

The release of 11.0.1 comes with a number of fixes. To view the list, please click here.

Release 11.0 features summary:

Change Management

Allowing you to collaborate in an Agile environment, Change Management Center gives you the ability to track and manage the changes made by Repository check ins.

Welcome Page

Newly implemented in version 11.0 of ER/Studio Data Architect is the interactive Welcome Page. A starting point for new and experienced users. Containing links to your recent files, plus the ability to create new models, open the reverse engineer or import wizards in a single click. The Welcome Page also includes a number of helpful videos to guide you through some of the more important features, and for new users, a simple getting started video. If you do not have Internet connectivity, there is an auto-sensing offline page that shows limited interactive content, but is still filled with convenient information and the same useful quick links to get you quickly back to where you left off.

Auto Naming Standards

Naming Standards have been an effective method of keeping your models in line with any organizational naming conventions and compliance that is in place, however now the Auto Naming Standards feature allows you to create and modify while automatically applying your naming standard templates.

New Installer

Streamlining the install process, the new WiX installer means you have more power, with less keystrokes.

Enhanced Platform Support

• The ability to suppress index names for Teradata. This option is available within the Entity Editor DDL and the DDL Generation Wizard.
• Partition by Growth for Universal Table Space (UTS) is now supported for DB2 z/OS.
• Support added for Advanced Compression with Oracle Database 11g.

Glossary Integration

The business glossary is an extremely important source of information for collaboration between all stakeholders including data modelers, business analysts, developers and subject matter experts. Your Team Server glossaries are now able to be linked directly in to the ER/Studio interface. 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.

User Interface Enhancements

To ease keyboard navigation the tab order has been improved on the dialog boxes.

Release Notes

Important Installation Notes

• If you are going to install the x64 bit client version of ER/Studio Data Architect you must uninstall any previously installed x32 bit versions of the software.
• To install ER/Studio Data Architect on Microsoft Windows, you must have administrative privileges. Once you have installed ER/Studio Data Architect, 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 Data Architect, you must provide valid licensing information.
• When you install ER/Studio Data Architect, 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:
    • Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\DatatypeMapping
    • Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\DatatypeMapping
  • For Automation Handler files, which is also the default location for sample macros:
    • Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Macros
    • Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\Macros
  • For sample model files, for which a shortcut is generated in the ER/Studio Data Architect program group:
    • Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Sample Models
    • Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_X.X\Sample Models
• When the application is run for the first time, the following directories are created by ER/Studio Data Architect:
  • Directories used by the Repository client to transfer files to and from the Repository server:
    • Windows XP:
      • C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\RepoIn
      • C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\RepoOut
    • Windows 8, Windows 7, and Windows Vista:
      • C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoIn
      • C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\RepoOut
  • Default directory for Report files:
    • Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\Reports
    • Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\Report
  • Default directory for SQL scripts:
    • Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\SQLCode
    • Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\SQLCode
  • Default directory for Quicklaunch files:
    • Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\XML
    • Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\XML
  • Default Save location for new diagrams:
    • Windows XP: C:\Documents and Settings\All Users\Application Data\Embarcadero\ERStudioDA_X.X\Sample Models
    • Windows 8, Windows 7, and Windows Vista: C:\Users\<user>\Documents\ERStudioDA_X.X

Important Release Advisory

• Manual Uninstall version 11.0: If you have a previous version of ER/Studio 11.0, you must manually uninstall prior to running the installation.

• To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires at least ER/Studio Repository version 7.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 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

Bug Fixes

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 11.0.1

ERS-24620	Reverse Engineering Teradata column length are now correct.
ERS-24661	Korean language order now displays correctly.
ERS-24602	The documentation incorrectly lists that Trigger.Text is a read-write property.
ERS-24745	XML Schema Generation, Entity Option, "Add element refs to parent entity elements" is not adding reference to parent complex type.
ERS-24322	Data Architect crashes when getting a particular model due to incorrect positions of shapes
ERS-24496	Teradata Bug - Date format default value generates incorrect Syntax
ERS-24609	Teradata decimal columns are being erroneously reverse engineered from database into model as IDENTITY columns.
ERS-24722	TERADATA - COMPRESSION always shown as NULL whereas original DDL shows several different compression values
ERS-24724	TERADATA - Reverse engineering CLOB columns results in defined lengths being incorrect.
ERS-24633	Option to compare schemas is missing.
ERS-24681	Reverse engineering Teradata issue.
ERS-24714	Error when setting a named release

Bugs Fixed in ER/Studio Data Architect 11.0

ERS-24544	Entity Editor help links corrected
ERS-19764	Date attachments now stored in user locale specific format.
ERS-24475	Teradata Compare and Merge now generates correct diff script
ERS-24483	Constraint names formatting issue for MS SQL Server 2014
ERS-24482	VARCHAR(MAX) correction for MS SQL Server 2014
ERS-24344	API - SrcTrgtTableOwnerName now added to DataMovementColumnLink Class
ERS-23890	Fixed a forward engineering syntax issue for Teradata
ERS-23891	Fixed an index syntax issue for Teradata
ERS-22479	The Length of the Entity Name and Table Name display windows has been increased
ERS-24403	Added users checkbox in Objects comparison tab
ERS-23914	In some cases reverse engineering Hive datasource failed
ERS-24313	Constraint names now match in Create/Drop ForeignKeys
ERS-24151	Fixed truncated names issue during reverse engineering and compare/merge
ERS-23188	Fixed an issue with the attachments that are returned by macro
ERS-23860	It is now possible to drop on to Model node to bring nested submodels to root
ERS-23987	Fixed an issue with associative entities that are created for non-specific relationships
ERS-22517	Fixed an scrolling object duplication issue
ERS-24184	Updated the ImportAttributeAttachments macro to fix an update issue Attachments macro
ERS-24248	Export to Excel PK value error
ERS-24059	Type mismatch issue
ERS-24094	Modifications on 'Move-Up Key Columns' macro
ERS-23878	ActiveX Vulnerability fix
ERS-23689	Import erwin file issue.

Known Issues

ERS-23001	Performance issues when navigating and editing tables.
ERS-24062	Term hyperlinks are not shown with Firefox when first clicked.
ERS-24319	Oracle's COMPRESS option is not supported in SQL Import.
ERS-23678	Reverse engineering from MongoDB creates incorrect results with fields or arrays using different data types.
ERS-23791	Compare/Merge fails to properly merge MongoDB objects in some cases.
ERS-24419	Users must close and reopen the Entity Editor after applying a Naming Standards Template.
ERS-24577	Change Records are marked as completed even if the check in fails in the Repository server.

Upgrade Instructions

Upgrading from Embarcadero Connect to ER/Studio Team Server

For detailed instructions on upgrading to ER/Studio Team Server, see ER/Studio Team Server Upgrade Notes.

Check also the Transition Tech Notes

Upgrades for ER/Studio Repository users

See Upgrading From Previous Versions.

Upgrades for version of ER/Studio Repository prior to 7

To ensure compatibility with ER/Studio Repository synchronization, this version of ER/Studio Data Architect requires at least ER/Studio Repository version 7.0 for all Repository operations. To use this version of ER/Studio Data Architect, you will need to upgrade your Repository version to at least version 7.0.

Embarcadero Technologies Technical Support

To contact Support, go to embarcadero.com/support.

Comments: Email Us

See Also

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