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.
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
- The ability to suppress index names for Teradata. This option is
available within the Entity Editor DDL and the DDL Generation Wizard.
- 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 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
- To install ER/Studio DA on Windows 8, Windows 7, Windows
Vista, Windows XP Professional, or Windows XP Home Edition, 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:
- 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 DA 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 DA:
- 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
- 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.
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
- The Repository upgrade must be done incrementally from one
major version to the next until the target version is reached. You
cannot skip major versions during the Repository upgrade as the
installer for each major version only contains the database changes
between the new version and the previous one. When upgrading from
earlier versions, such as from 5.5 to Repository 6.6, you must first
upgrade the Repository to version 6.0, update the database, uninstall
version 6.0, then upgrade to 6.6, and update the database. Once the
Repository upgrade is complete and you have installed the latest
version of ER/Studio Data Architect, then you should upgrade your
diagrams with the latest version of ER/Studio DA.
Consult Embarcadero
Technical Support when upgrading from versions prior to 4.5. Upgrading from 6.5/6.6/6.7 to 7.0 does not
require the Diagram Upgrade step.
- If you are upgrading to ER/Studio Repository, upgrade your
version of ER/Studio Data Architect also. Ensure the build date of
ER/Studio Repository coincides with the build date of ER/Studio Data
Architect.
- If you are also using ER/Studio Portal, you must also
upgrade it to the latest version of ER/Studio Team Server.
- You can install ER/Studio Data Architect 11.x and an earlier
ER/Studio Data Architect version on the same workstation.
- Upgrading diagrams can be time consuming and memory
intensive. The number and size of ER/Studio Data Architect diagrams
managed in the upgraded Repository dictates how long the upgrade
process takes.
- Reference Models, supported in previous versions, are not
supported in ER/Studio Data Architect 7.x and later versions.
Preparing
to Upgrade the Repository
- Ensure you have backed up all your .dm1 files.
- 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.
- Rename all local copies of Repository diagrams in the
active file directory as follows:
- Choose Repository > Options.
- Make note of the Active File Directory.
- Switch to the Windows Explorer and rename all the
diagrams in the Active File Directory.
- Ensure no one is logged in to the Repository.
- Backup the current Repository database.
- 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.
- Log on to Windows with local administrator privileges.
- Start the Repository installation
program and select Repair Repository Services.
The installation program starts the following services:
- Embarcadero Repository Communication Server
- Embarcadero Repository Database Server
- Embarcadero Repository Event and Dispatch Server
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.