ER/Studio
Home | ER/Studio
Documentation | IDERA Technical
Support | www.idera.com
Thank
you for using IDERA 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 the IDERA Web site, https://www.idera.com/support/productdocuments
WHAT'S NEW in version 16.5
Universal mappings enhancements
Improved relationship diagramming
Expanded change management features
Supports rich text functionality on entry fields
Added the ability to inherit relationship color
from parent entity
Implemented unique tokens to identify repository
checkout records
Improved repository security for new users and
assigned roles
what’s new in version 2016
Business
Data Objects
Model/Submodel NSTs
Windows
10 Support
Teradata
Support
Teradata
Enhancements
SQL Azure
Support
Release Notes
Upgrade Instructions
Upgrading from
ER/Studio Portal to Team Server
Upgrades for version
of ER/Studio Repository prior to 2016
Additional Resources
What's New in Version 16.5
Universal mappings enhancements
ER/Studio Enterprise Team Edition 16.5 expands universal mapping to
include mappings between entity/table and attribute/column across design
layers. Users now can add and view definitions, attachments, and notes related
to Universal Mappings. For more information about universal mappings, see Working
with Universal Mappings.
Improved relationship diagramming
Viewing data models can occasionally become cluttered with the
number of relationships associated with the model. The Data Model View in
ER/Studio Data Architect 16.5 introduces a toggle option that allows you to
hide or unhide one, more, or all relationships in a submodel.
To hide a relationship, simply select and right-click the item(s) you want to
hide or unhide, and then select either Hide Relationship or Show All Hidden
Relationships from the available menu. Note that when publishing models to Team
Server, all hidden relationships remain hidden in the graphical display. For
more information about managing relationships, see Creating
and Editing Relationships.
ER/Studio Data Architect XE7 introduced the ability to
automatically link your Team Server glossaries directly into the ER/Studio
interface. ER/Studio Enterprise Team Edition 16.5 continues to improve this
feature by allowing association of specific models or sub-models in a .dm1 file
and repository to be associated with a specific glossary. That glossary then
can provide the scope when trying to detect and link terms to the model
objects. 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. For more information about glossaries, see Glossary
Integration or the ER/Studio Team Server online help section about Working
with Glossaries.
ER/Studio Data Architect 16.5 now includes database platform
support for IBM DB2 for z/OS v11.x and SQL Server 2016 (does not include
support for SQL Server 2016 JSON capabilities). For more information about
supported platforms, see Supported
Database Platforms.
Expanded change management features
ER/Studio Enterprise Team edition includes additional features to
expand the support for Agile change management. Users
now can associate tasks from third-party tools, such as Atlassian
JIRA, to specific projects available within the Repository Project Center.
Similar support also is expanded in Team Server, where you can add, change, and
delete the same tasks. JIRA is the only issue- and project-tracking tool
supported in this release. For more information about using this feature, see Change
Records and Working
with Repository Projects.
This
release begins a rollout of rebranding this product from Embarcadero to IDERA.
Note that these changes include a new license agreement, installation and data
directories, icons, file names, registry settings, and more. For more
information about IDERA and IDERA products, see www.idera.com.
Supports rich text functionality on entry
fields
All fields
where a user can type names, definitions, notes, etc. now include a spell
check, allow some rich text functions such as bold and underlined text, and
support embedded hyperlinks. In larger fields, a text wrap feature also was
implemented. Available rich text options include:
·
Text font, color, and size
·
Bold, italics, and underline
·
Format and alignment options including bullets
·
Hyperlink capability
Added the ability to inherit relationship
color from parent entity
The Colors & Fonts dialog now includes the Inherit from parent entity foreground
checkbox that allows users to set whether you want the outline of an entity to
be the same color as its parent entities. If you select a relationship and
change its color, the manual change overrides the color inherited from the
parent. Changes made in a child entity do not affect the color of the parent.
For more information about setting diagrams colors, see Setting
Default Diagram Colors and Fonts. This option is enabled only for the
following object types when selected from the drop-down list available in the
Colors & Fonts dialog:
·
Relationship object type. Relationship color is the same as the parent entity foreground
(border.)
·
Inherited
Primary Keys object type. Primary font color is the same as parent
entity foreground (border).
·
Inherited
Non-Keys. Foreign key color is the same as parent entity foreground
(border).
Implemented unique tokens to identify
repository checkout records
In this release of ER/Studio Data Architect, checkouts now include
a unique identifier or token to easily resolve identification issues when
attempting to check in to the Repository. Previously, checkouts included the
host machine name as part of the identifier in the checkout record. This
process caused issues in virtualized environments when the host names did not
match upon reconciliation at check in, perhaps because the user disconnected
from the repository before checking in the work.
Improved repository security for new users
and assigned roles
This release of ER/Studio Repository features the following
security enhancements to the Security Center:
·
When a new user is added, the user has the ability to log into the
repository but has NO ACCESS to projects. An administrator must assign a role
with the proper access to this user account.
·
Role assignment is inherited by all objects under the node for
which the role is specified. For example, if you grant UserA
access ProjectX, then UserA
can access all elements under ProjectX. But if you
want to restrict UserA's access to only a single
element within ProjectX, such as Model1, you can
grant access to Model1 while also granting a NO ACCESS role to UserA at the ProjectX level. The
lower level access to Model1 has a higher priority than the ProjectX
NO ACCESS role.
For more information about managing repository security, see Establishing
Security for the Repository.
What's New in Version 2016
Business Data Objects
Model/Submodel NSTs
You can now bind Naming
Standards Templates to Models and Submodels
You can now install your
favorite Data Modeling software on your newest OS.
Teradata Support
We now support Teradata 15.x.
Teradata Enhancements
AS
VALIDTIME.
AS TRANSACTIONTIME.
SQL Azure Support
Microsoft SQL Azure is now fully supported for all operations.
Release Notes
To ensure compatibility
with ER/Studio Repository synchronization, this version of ER/Studio Data
Architect requires ER/Studio Repository (Team Server) version 16.5 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
Bugs Fixed in ER/Studio DA 16.5
Bug # |
Description |
ERS-22178 |
Column names of
foreign keys in physical models are now editable when no rolename
specified |
ERS-24199 |
Increase the length of
the Attribute Name and Column Name display fields |
ERS-24644 |
Macros do not work and
next error pops up when closing application: WinWrap
Basic control isn’t registered properly on your computer |
ERS-24926 |
Editors no longer wrap
text for definition, notes |
ERS-24927 |
View warning when
modifying the primary key |
ERS-25826 |
Deleting object in BDO
causes corruption, Repository errors |
ERS-26106 |
Column deletion field
no longer disappears when resizing |
ERS-26109 |
The note override checkbox
can now be checked |
ERS-26115 |
RTF codes are no
longer shown incorrectly for definitions |
ERS-26116 |
Column comments are
now shown correctly in the DDL tab |
ERS-26126 |
Attribute/Column Names
are now saved properly from editor |
Bugs Fixed in ER/Studio DA 16.0.3
Bug # |
Description |
ERS-25756 |
Domain-based
attributes in model published in Team Server display wrong datatype. |
ERS-25762 |
Parentheses in DDL not
correct for default values. |
Bugs Fixed in ER/Studio DA 16.0.2
Bug # |
Description |
ERS-25198 |
Iteration over index
columns shows very slow performance. |
ERS-25405 |
Case sensitivity issue
renders the 'Hide other users' feature ineffective. |
ERS-25532 |
Reverse Engineer from SQL
Server 2014 does not get the default values for columns. |
ERS-25589 |
Opening a data model
crashes the application. |
ERS-25603 |
ERDA crashes after
adding attribute to entity on a submode. |
Bugs Fixed in ER/Studio DA 2016
Bug # |
Description |
ERS-24626 |
Roll up of one subtype
among many causes FK to be removed from other subtypes. |
ERS-22959 |
"MIRSETUP.XML"
is missing from "\MetaIntegration\conf" folder. |
ERS-22486 |
Default the Place New
Objects Near Existing Objects parameter in the Submodel
Editor to checked. |
ERS-24407 |
Submodel_editor option to hide existing submodels from editor. |
ERS-24893 |
Comment edit box is
not shown on "Repository Check In" window. |
ERS-24917 |
Length of NVARCHAR, VARCHAR
and VARBINARY is displayed as 0 instead of max. |
ERS-24931 |
Copy and paste of
entity with varchar(max) or nvarchar(max) does not
preserve the data type setting. |
ERS-24496 |
Teradata - Date format
default value generates incorrect Syntax. |
ERS-24620 |
Reverse engineering
Teradata column lengths are incorrect. |
ERS-24609 |
Teradata decimal
columns are being erroneously reverse engineered from database into model as
IDENTITY columns. |
ERS-24724 |
TERADATA - Reverse engineering
CLOB columns results in defined lengths being incorrect. |
ERS-18123 |
Ability to generate
column comments for MySQL. |
ERS-24770 |
Undo causes
instability in Data Architect after check out from Repo. |
ERS-24482 |
VARCHAR(MAX) is being generated as VARCHAR(4000) for
MS SQL Server 2014. |
ERS-16232 |
Ability to remove
double quotes from table and column names. |
ERS-23897 |
When running a roll-up
denormalization a relationship is deleted. |
ERS-24284 |
Dropping relationship
on roll-up denormalization. |
ERS-24801 |
Inconsistent
formatting results. |
ERS-24743 |
Data Diagram Version
Upgrade causes instability on a database upgrade from v6.0 to v7.0. |
ERS-23629 |
Templated
procedures now included when using GenDLLUsingFileBasedQuickLaunch. |
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 becomes
unstable when getting a particular model due to incorrect positions of
shapes. |
ERS-24633 |
Option to compare schemas
is missing. |
ERS-24681 |
Reverse engineering
Teradata. Error: ‘The parameter is incorrect’. |
ERS-24714 |
Error when setting a
named release. |
ERS-24062 |
Term hyperlinks are
not shown with Firefox when first clicked. |
ERS-24419 |
Users must close and
reopen the Entity Editor after applying a Naming Standards Template. |
Known Issues in ER/Studio DA 16.5
Bug # |
Description |
ERS-24515 |
Teradata databases
with collect statistics enabled cannot be reverse-engineered. |
ERS-24577 |
Change Records are
marked as completed even if the check in fails in the Repository server. |
ERS-24773 |
Certain keywords cause
parser errors when importing an Oracle SQL script. |
ERS-24926 |
Definitions and Notes
are no longer wrapped in editors. |
ERS-24996 |
Objects included in
Business Architect subject areas are not shown in Universal Mappings Editor. |
ERS-25004 |
The Team Server Data
Source option is unavailable in the Reverse-Engineer Wizard after log in. |
ERS-25024 |
The Teradata JSON datatype is not imported from a SQL file. |
ERS-25134 |
The ContainedObject count automation method always returns 0
for Business Data Objects. |
ERS-25155 |
Entities remain above
Business Data Objects in the diagram view after being removed. |
ERS-25166 |
Crashes may occur when
generating reports on Japanese system with Welcome Page open. |
ERS-25285 |
Using the SSL option
for the Repository may cause a "Socket Disconnected" error. |
ERS-25358 |
Errors may occur while
refreshing tree nodes when working with Business Data Objects. |
ERS-25359 |
Teradata temporal
types are not fully supported in SQL Import. |
ERS-25360 |
Teradata temporal
types are not fully supported in Alter SQL generation. |
Known Issues in ER/Studio DA 16.0.2
Bug # |
Description |
ERS-25024 |
Teradata JSON datatype is not imported from a SQL file. |
ERS-25134 |
ContainedObject count method always returns 0 for Business Data Objects. |
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 ER/Studio Repository (Team Server) 16.5.
Upgrades
for version 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 the latest
upgrade notes online.
All IDERA products include a 14-day trial period. To continue
using the product without interruption, we recommend that you license it as
soon as possible. For information on licensing your product, refer to the Quick
Start Guide. If you have not yet purchased this product, contact [email protected].
The IDERA Web site is an excellent source for additional product
information, including white papers, articles, discussion forums, and the IDERA
Knowledge Base. Visit www.idera.com/support,
or click any of the links below, to find:
If you have a valid maintenance contract with IDERA, the Technical
Support team is available to assist you with any problems you have with our
applications. Our maintenance contract also entitles registered users of IDERA
products to download free software upgrades during the active contract period.
Evaluators receive free technical support for the term of their evaluation (14
days).
We encourage you to open technical support cases via the Customer Support Center. For
additional information about IDERA Technical Support, visit the Support section of our Web site.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.