Welcome to ER/Studio Data Architect® 2016.0.2
ER/Studio
Home | ER/Studio
Documentation | Embarcadero
Technical Support | www.embarcadero.com
Read Me Last Updated: January 12th,
2016.
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 2016
Business Data Objects
Model/Submodel NSTs
Windows 10 Support
Teradata Support
Teradata Enhancements
SQL Azure Support
Release Notes
Important
Installation
Notes
Important
Release Advisory
Bug
Fixes
Known
Issues
Upgrade Instructions
Upgrading
from
ER/Studio Portal to Team Server
Upgrades
for
version of ER/Studio Repository prior to 2016
Additional Resources
Embarcadero
Technologies Technical Support
What's
New in 2016
Business Data Objects
You can now group your entities/tables in to Business Data Objects.
These objects allow you to better describe your business concepts by
grouping entities or tables that share a common relationship in to a
visible container.
Model/Submodel NSTs
You can now bind Naming Standards Templates to Models and Submodels
Windows 10 Support
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 at least ER/Studio
Repository version 2016 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_XX.X\DatatypeMapping
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_XXXX\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_XX.X\Macros
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\ERStudioDA_XXXX\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_XX.X\Sample Models
- Windows 8, Windows 7, and Windows Vista: C:\ProgramData\Embarcadero\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:
- 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\ERStudio\Sample Models
- Windows 8, Windows 7, and Windows Vista: C:ProgramData\Embarcadero\ERStudioDA_XXXX\Sample Models
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 2016 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 16.0.2
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 submodel.
Known Issues Fixed in ER/Studio DA 16.0.2
ERS-25024 Teradata JSON datatype is not imported from a SQL file
ERS-25134 ContainedObject count method always returns 0 for Business Data Objects
Bugs
Fixed in ER/Studio DA 2016
ERS-24626 Roll up of one subtype among many causes FK to be removed from other subtypes.
ERS-24959 "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
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.
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 least version 2016 of Repository as a minimum.
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.
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.