Welcome to ER/Studio Data Architect® 9.7
ER/Studio
Home | ER/Studio
Documentation | Embarcadero
Technical Support | www.embarcadero.com
Read Me Last Updated: Feb 12th, 2014.
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 9.7
Teradata - Temporal data types
-
Interval Datatypes
- Period
Datatypes
Teradata - DB Alter
Oracle -
Add Tolerance for Oracle 12C
SQL
Server - Add Tolerance for SQL Server 2014
Popout
Attribute/Column Editor
Save Repository Server Name
Release Notes
Important Installation
Notes
Important Release Advisory
Bug
Fixes
Known Issues
Upgrade Instructions
Upgrading from
ER/Studio Portal to Embarcadero Connect
Upgrades for
ER/Studio Repository 6.6 users
Upgrades for
version of ER/Studio Repository prior to 6
Additional Resources
Embarcadero
Technologies Technical Support
What's New in 9.7
Teradata - DB Alter
ER Studio now supports Alter generation for Teradata.
Teradata - Interval Parameters
Additions to the interface now include new controls to specify the units for Interval Datatypes.
Teradata - Period Datatypes
Period Datatypes are now supported across the product.
Oracle - Add Tolerance for Oracle
12C
Oracle version 12c is now fully supported across the
product.
SQL Server - Add Tolerance for
SQL Server 2014
Microsoft SQL Server 2014 is now fully supported across
the product.
Popout Attribute/Column Editor
A new option allows you to edit your columns and their
attributes in a new editor window. The management with the new method
is cleaner and more usable.
Save Repository Server Name
It is now possible to save the Repository Server name and
view Repositories that are available on the local network.
Release
Notes
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
ER/Studio Portal is no longer supported by
ER/Studio Data Architect. Most functionality formerly provided by
ER/Studio Portal is now provided by Embarcadero Connect. Users that
formerly used the Repository tab to browse the
portal can use a Web browser instead.
Bug
Fixes
Use your browser Find feature to locate a
particular bug number.
Bugs
Fixed in ER/Studio DA 9.7
| ERS-19771 |
Columns in views that contain
CASE statements are now displayed properly. |
| ERS-21580 |
Derived columns are now
displayed properly in views. |
| ERS-22584 |
The CACHE/NOCACHE clause is no
longer generated in the DDL for Oracle index-organized tables. |
| ERS-22865 |
The Oracle DATE data type is now
imported properly from ERWin models. |
| ERS-22897 |
Comments containing single
quotes or apostrophe's are now generated properly in DDL. |
| ERS-22898 |
The Repository now supports
logging in via the user's Windows account when the server is on a different
domain than the client. |
| ERS-22907 |
Large, complex views are now
reverse-engineered properly from DB2 z/OS |
| ERS-22915 |
An option has been added to
Tools->Options->View that will use "CREATE OR REPLACE" or
"REPLACE" for new views (when supported). |
| ERS-22923 |
It is no longer possible to
delete the Main Model submodel through the automation interface. |
| ERS-22973 |
It is no longer possible to
delete the Main Model submodel through the automation interface. |
| ERS-22995 |
The automation interface
property DisplayBackgroundColor for display objects is now writable. |
| ERS-23003 |
The Quick Launch in the Report
wizard now saves Visual Data Lineage object selections. |
| ERS-23005 |
A blank line is no longer
generated when PARALLEL is turned off while generating Oracle table DDL. |
| ERS-23011 |
The automation interface
property DisplayBackgroundColor for display objects is now writable. |
| ERS-23026 |
The Compare Wizard now properly
handles dictionary bindings in denormalized tables. |
| ERS-23029 |
The Compare Wizard now properly
orders alter statements when modified tables are also renamed. |
| ERS-23030 |
The Compare Wizard now remains
stable when comparing against a DB2 z/OS database that contains invalid
triggers. |
| ERS-23161 |
ER/Studio now remains stable
when saving old files in the new version. |
| ERS-23181 |
The Compare Wizard now properly
connects to DB2 databases. |
| ERS-23187 |
The MetaWizard now properly
imports IBM DataStage files that contain parameter sets. |
Known Issues
| ERS-23148 | SQL Import currently does not support the Teradata INTERVAL datatype. |
| ERS-23184 | ER/Studio can become unstable when switching to another entity through the Where Used tab of the popout attribute editor. |
Upgrade Instructions
Upgrading
from ER/Studio Portal to Embarcadero Connect
For detailed instructions on upgrading to
Connect, see Connect
Upgrade Notes.
Upgrades
for ER/Studio Repository 6.6 users
Keep the following in mind when updating
for this release:
- Only a service upgrade is required
- No diagram data version upgrade is required.
- There are no database changes from version 6.6
Upgrades
for version of ER/Studio Repository prior to 6
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. For more information,
see "Upgrading
ER/Studio Data Architect Diagrams." Consult Embarcadero
Technical Support when upgrading from versions prior to 4.5.
- 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.
- You can install ER/Studio Data Architect 9.x and an earlier
ER/Studio Data Architect version on the same workstation.
- Any *.dm1 files you use from the previous version will be
copied and converted to 8.x format when you open them for the first
time. You can then save the diagram with a different name or use the
same name to write over the old file. Previous versions of ER/Studio
Data Architect will not read 8.x and higher files.
- 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 into 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.
