Welcome to ER/Studio Data Architect 11.0.1

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

Read Me Last Updated: July 08th, 2015. Any updates to these Read Me notes will be available at docs.embarcadero.com.


DBTA100 SDT100_2014 SD Times Award

SD Times Award

CS Award

Thank you for using Embarcadero 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 Embarcadero's Web site, http://www.embarcadero.com/resources/documentation.html.


WHAT'S NEW in 11.0.1


Submodel Editor improvements
Bug Fixes

WHAT'S NEW in 11.0


Change Management
Welcome Page
Auto-Naming Standards
New Installer
Enhanced Platform Support
Glossary Integration
User Interface Enhancements



Release Notes

Important Installation Notes

Important Release Advisory

Bug Fixes

Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server Core

Upgrades for ER/Studio Repository 7.0 users

Upgrades for version of ER/Studio Repository prior to 6

Additional Resources

Embarcadero Technologies Technical Support



What's New in 11.0.1

Submodel Editor Enhancements

To reduce opening times for larger models, the 'Limited Submodel Editor' option allows you to limit the amount of submodels that are loaded into 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.


What's New in 11.0


Change Management

Allowing you to collaborate in an Agile environment, Change Management Center gives you the ability to easily 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 more experienced users. Containing links to your recent files, plus the ability to create new models and open the reverse engineer or import wizards in a single click.
The Welcome Page 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 useful 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 the Auto Naming Standards feature now allows you to create and modify while automatically applying your naming standard templates (NST) to your models.


New Installer

Streamlining the install process, the new WiX installer means you have an easier install, with less keystrokes.

Enhanced Platform Support


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 into the ERStudio 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 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

If you have ER/Studio 11.0 installed, you will need to manually uninstall it prior to running the 11.0.1 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

Important Installation Notes


Important Release Advisory



Bug Fixes


Use your browser Find feature to locate a particular bug number.


Bugs Fixed in ER/Studio DA 11.0.1

ERS-24620 Reverse Engineering Teradata column length are now correct.
ERS-24661 Korean language order is showing incorrectly.
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 DA 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 onto 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 a 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 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 at version 7.0 of Repository as a minimum.

Upgrades for version of ER/Studio Repository prior to 7.0


Use the following checklist to ensure ER/Studio Repository is correctly upgraded.

Upgrade Checklist

Important Notes

Preparing to Upgrade the Repository

  1. Ensure you have backed up all your .dm1 files.
  2. Check in all your diagrams and objects. Note: If you try to check in a file from the previous version with the same name as a current file, the current file will become corrupted.
  3. Rename all local copies of Repository diagrams in the active file directory as follows:
  4. Ensure no one is logged in to the Repository.
  5. Backup the current Repository database.
  6. Restart the Repository host computer.

Upgrading the Repository

Note: This procedure is for ER/Studio Enterprise installations only, which include the Repository. When you upgrade ER/Studio Data Architect you must also upgrade ER/Studio Repository to correspond with the same build date as ER/Studio Data Architect.

  1. Log on to Windows with local administrator privileges.
  2. Start the Repository installation program and select Repair Repository Services. The installation program starts the following services:

The Repository services and your existing database will be upgraded to the current version.

Note: If you are upgrading from a Repository version prior to 4.0, you can delete the C:\Program Files\Embarcadero\Repository\Data directory. This directory is not used with Repository versions 4.0 and later.

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, our Support team will assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period.

Evaluators receive free technical support for the term of their evaluation. To download evaluations of Embarcadero Technologies products go to www.embarcadero.com.

To contact Support, go to http://www.embarcadero.com/support.