ER/Studio Data Architect 8.5 ReadMe

Welcome to ER/Studio Data Architect® 8.5

ER/Studio Home | ER/Studio Documentation | Embarcadero Technical Support | www.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.

WHAT'S NEW IN VERSION 8.5

Customer requests continue to guide us in our quest to bring to market the best database tools available. Thank you for your support.

Main Features

Comments can now be added to model objects.
ER/Studio Portal has been integrated with ER/Studio DA to enable the Repository to be explored on the Repository tab.
Portal Search criteria can now be used to retrieve models from ER/Studio Repository

General Updates

Portal Search critera is now supported in the Get Diagram from Repository dialog.
Improved Repository Performance
Image Export Improvements. Image Export now supports GIF and PNG formats. JPEG Export now supports larger models.
Drawing Shapes are now supported in Visual Data Lineage diagrams.

DBMS Updates

Teradata 12.0 is now supported.
Interbase 2009 is now supported.
Oracle Updates
- Compression on index-organized tables is supported
- Support for enabling/disabling constraints in PK and FK.

Other Enhancements

The following customer requests have been addressed in this release.

Issues Addressed in ER/Studio DA 8.5
ERS-10340	The JPEG export now supports larger models than in previous versions.
ERS-10456	Export Image now supports GIF and PNG formats.
ERS-10575	The Dependencies tab of the Table/Entity Editor now displays views associated with the table. Views are also now listed in the Explorer tree in the Table/Entity hierarchy.
ERS-10822	Index-organized tables with compression are now supported on Oracle.
ERS-14338	TeraData 12.0 is now supported.
ERS-14381	Definitions and Notes now have separate formatting options in HTML reports.
ERS-15554	Drawing shapes are now supported for data flows on the Data Lineage tab.
ERS-15555	The Display Levels for Data Lineage objects are no longer mutually exclusive.
ERS-15557	In the Data Lineage explorer, the inputs and outputs under each transfromation lists columns and attributes.
ERS-16267	The list of diagrams in the Get from Repository dialog can now be filtered.
ERS-16365	Enable constraint for PK and FK is now supported on Oracle.
ERS-16366	Index-organized tables with compression are now supported for Oracle 10g.
ERS-16431	The Macro Editor now retains any new settings.
ERS-17100	Comments can now be added to model objects.

Release Notes

Important Installation Notes

Important Advisory Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

Release Notes

Important Installation Notes

To install ER/Studio on Windows XP Professional, Windows XP Home Edition or Windows Vista, you must have administrative privileges. Once you have installed ER/Studio, you can then log in as a standard or limited user and use the application without having administrative privileges.
The first time you run the program, you will see a product registration dialog. Enter the serial number from the beta download page, then click the "I need to create a DN account" link and follow the instructions.
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 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 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 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 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 Vista: C:\Users\<user>\AppData\Roaming\Embarcadero\ERStudio\Reports

Default directory for SQL scripts:

Windows XP: C:\Documents and Settings\<user>\Application Data\Embarcadero\ERStudio\SQLCode
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 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 Vista: C:\Users\<user>\Documents\ERStudioDA_X.X

Known Issues
ERS-14561	The new Description and Bound Attachments features for User Defined Mappings have not yet been implemented in Reports.
ERS-15585	Drag and drop within the Data Lineage tree is not yet supported.
ERS-15921	Data Flows are not supported in Repository partial diagrams.
ERS-15974	Currently it is not possible to copy and paste Data Lineage objects.
ERS-16067	Objects in Data Flows in Repository models can be resized when the user only has Update Physical Model Display permissions. This should be restricted to the Update Data Flow Display permission.
ERS-16068	The Check Out Object context menu item in the VDL tree currently does not work properly for Transformations.
ERS-16439	In the InstantOn version of ER/Studio, Help cannot be invoked from within the SaxBasic edit control.
ERS-16916	The Portal View tree is sometimes not updated properly after dragging another window on top of it.
ERS-17255	The ExportImageOptions automation object members currently do not work when exporting data flow images.
ERS-17279	System overflow tables for Index Organized Tables are currently not hidden in the Reverse-Engineer wizard.
ERS-17680	Comments currently are not supported in Repository Branches.
ERS-17882	Duplicate view names in the Dependencies tab of the table editor are currently not qualified by the owner name.
ERS-17973	It is currently not possible to add comments to Subtype Cluster objects.
ERS-18100	Operations conducted prior to using Switch To in the Entity Editor are not added to the Undo stack.

Bug Fixes

Use your browser Find feature to locate a particular bug number

Bugs Fixed in ER/Studio DA

ERS-13727 ER/Studio DA now properly reverse-engineers TeraData primary index partition expressions.

ERS-13792 The XML Schema Generation wizard now displays Korean characters properly in the Preview window.

ERS-13994 Naming Standards are now applied properly to rolenamed foreign keys.

ERS-14381 The formatting options for definitions and notes are now separated in the HTML report wizard.

ERS-14521 The "Do Not Generate" flag for tables is now taken into consideration when generating DDL via automation.

ERS-14649 The DDLGenerationObject.GeneratePKByAlterStatement and DDLGenerationObject.GeneratePKByAlterStatementAndUniqueIndex automation interface properties now work properly.

ERS-14820 The Naming Standards Utility now applies invalid character handling before applying abbreviation and word separation rules.

ERS-14842 The DDL Wizard no longer quotes lower case owner names when generating aliases.

ERS-14855 The Branch Merge operation no longer reports that the Data Dictionary needs to be checked in when it is already checked in.

ERS-15101 The performance of the Repository Check Out Object operation has been improved.

ERS-15107 ER/Studio DA now properly parses SQL Server synonyms that include a database name.

ERS-15123 The automation interface now properly handles attachment text lists with duplicate entries.

ERS-15521 ER/Studio DA now supports Distribute By Hash partitioning for DB2 LUW 9.x.

ERS-16431 The Macro Editor now retains the last used settings when the editor is invoked.

ERS-16466 The table editor no longer automatically binds reference values to newly created columns.

ERS-16641 SRTF files are now deleted when upgrading a Repository database.

ERS-16720 The Create Associative Entity option state is now saved in the quicklaunch for the Generate Physical Model wizard.

ERS-16805 The application no longer shuts down after copying all objects in a submodel.

ERS-16693 ER/Studio DA now generates correct SQL Server scripts when the Generate PK By Alter Statement option is enabled.

ERS-16785 The Oracle View parser now supports the "UID" keyword.

ERS-16801 SQL Import now supports columns named "Nickname".

ERS-16834 It is now possible to specify "Unlimited" for Max Segments in the Oracle Lob Segment editor.

ERS-16850 Attachment bindings are now propagated to foreign keys when a relationship is created.

ERS-16864 SQL Import now handles the Enforced clause in DB Alter Table statements.

ERS-16866 SQL Import now handles DB2 functions with the ATOMIC clause.

ERS-16875 The performance of the Universal Naming Utility has been improved.

ERS-16954 The SQL Server view parser now handles table functions with '::" global qualifier.

ERS-16955 The DDL Wizard now generates the correct error message when attempting to overwrite an existing read-only file.

ERS-16970 The Report Title field in the Report Wizard is no longer disabled when the dialog is maximized.

ERS-16995 SQL Server view comments are now generated properly.

ERS-17044 ER/Studio DA no longer displays foreign keys that are hidden by denormalization mappings.

ERS-17160 The HTML Report wizard no longer displays duplicate Foreign Keys in the Relationship report.

ERS-17164 The DB2TbsPartitions automation collection now contains both defined and undefined partitions. A new Defined property was added to the DB2TbsPartition object to indicate whether the partition is defined or not.

ERS-17183 Moving attributes with user-defined mappings no longer causes errors in the DM1 file.

ERS-17193 The DB2 Procedure parser now handles different variations of CASE statements.

ERS-17261 The Naming Standard Utility now correctly modifies foreign key columss that are unified.

ERS-17264 The SQL Server function/procedure parser has been updated to handle value assignments in variable declarations.

ERS-17368 The Sax Basic Help menu item in the Help menu now works properly.

ERS-17392 The SQL Server View parser now handles views with the National Character Set prefix ('N').

ERS-17419 The Compare Wizard now remains stable when comparing models in separate DM1 files to generate alter SQL.

ERS-17449 ER/Studio DA now imports SQL Server 2008 scripts with computed columns.

ERS-17475 Deleting an attribute with User Defined Mappings no longer causes an error in the DM1 file.

ERS-17478 The DB2 table editor now allows users to specify strings of up to 128 characters.

ERS-17485 Enterprise Data Dictionary names are now preserved after checking in changes to the EDD definition.

ERS-17500 The MetaWizard now properly imports ERWin 7 files.

ERS-17512 The MetaWizard now properly imports COBOL Copybook files.

ERS-17524 The automation interface now maintains index column sequences after deleting a relationship.

ERS-17528 The Compare Wizard no longer shows differences in whitespace in procedures.

ERS-17577 The "Auto-Color All Entities With Foreign Keys" sample macro has been updated.

ERS-17582 The Compare Wizard now properly generates alter code for indexes with new columns.

ERS-17595 Duplicate parent keys are no longer displayed in the relationship editor after performing a copy and paste.

ERS-17626 The Compare Wizard now properly merges datatype changes when the source and target columns are bound to different domains.

ERS-17636 The automation interface Relationships collection has a new method, AddWithUnification that unifies new Foreign Keys with existing native attributes instead of deleting the native attributes.

ERS-17641 The Compare Wizard now properly sets the text list value to the default value when merging attachment bindings.

ERS-17666 The Compare Wizard now properly generates view comments for SQL Server.

ERS-17672 The MetaWizard now properly imports ERWin files that have relationships with no type set.

ERS-17732 ER/Studio DA now supports BINARY and VARBINARY datatypes for DB2 z/OS.

ERS-17741 The Compare Wizard now retains the domain folder structure when possible.

ERS-17748 Tables hidden due to denormalization mappings are now excluded from the Bound Objects automation collection.
ERS-17769 The MetaWizard now remains stable when selecting the Sparx Enterprise Architect (EA) via the UML 2.x XMI bridge.

ERS-17771 Foreign Keys are now properly inferred when reverse-engineering from MySQL.

ERS-17825 ER/Studio DA now remains stable when generating an HTML report with the Use Enhanced Version option enabled.

ERS-17826 The automation BoundObjects collection now works properly with unified attributes.

ERS-17845 The SQL Server Trigger parser now handles triggers with "FOR XML".

ERS-17869 Performance has been improved when displaying the Repository Delete Diagram and Repository Change Diagram Filename dialogs.

ERS-17941 Oracle Materialized View comments are now generated properly.

ERS-17952 The "Constraint Generator" sample macro has been updated to handle Reference Values with the "Values NOT Between" option set.

ERS-17997 The Index Editor now properly handles indexes that had the Piecesize set to an invalid value in the Generate Physical Model wizard.

ERS-18012 The Compare Wizard no longer shows differences in whitespace in functions.

ERS-18036 Some performance improvements have been made when expanding a diagram in the Repository Get Diagram dialog.

Bugs Fixed in ER/Studio DA
ERS-13727	ER/Studio DA now properly reverse-engineers TeraData primary index partition expressions.
ERS-13792	The XML Schema Generation wizard now displays Korean characters properly in the Preview window.
ERS-13994	Naming Standards are now applied properly to rolenamed foreign keys.
ERS-14381	The formatting options for definitions and notes are now separated in the HTML report wizard.
ERS-14521	The "Do Not Generate" flag for tables is now taken into consideration when generating DDL via automation.
ERS-14649	The DDLGenerationObject.GeneratePKByAlterStatement and DDLGenerationObject.GeneratePKByAlterStatementAndUniqueIndex automation interface properties now work properly.
ERS-14820	The Naming Standards Utility now applies invalid character handling before applying abbreviation and word separation rules.
ERS-14842	The DDL Wizard no longer quotes lower case owner names when generating aliases.
ERS-14855	The Branch Merge operation no longer reports that the Data Dictionary needs to be checked in when it is already checked in.
ERS-15101	The performance of the Repository Check Out Object operation has been improved.
ERS-15107	ER/Studio DA now properly parses SQL Server synonyms that include a database name.
ERS-15123	The automation interface now properly handles attachment text lists with duplicate entries.
ERS-15521	ER/Studio DA now supports Distribute By Hash partitioning for DB2 LUW 9.x.
ERS-16431	The Macro Editor now retains the last used settings when the editor is invoked.
ERS-16466	The table editor no longer automatically binds reference values to newly created columns.
ERS-16641	SRTF files are now deleted when upgrading a Repository database.
ERS-16720	The Create Associative Entity option state is now saved in the quicklaunch for the Generate Physical Model wizard.
ERS-16805	The application no longer shuts down after copying all objects in a submodel.
ERS-16693	ER/Studio DA now generates correct SQL Server scripts when the Generate PK By Alter Statement option is enabled.
ERS-16785	The Oracle View parser now supports the "UID" keyword.
ERS-16801	SQL Import now supports columns named "Nickname".
ERS-16834	It is now possible to specify "Unlimited" for Max Segments in the Oracle Lob Segment editor.
ERS-16850	Attachment bindings are now propagated to foreign keys when a relationship is created.
ERS-16864	SQL Import now handles the Enforced clause in DB Alter Table statements.
ERS-16866	SQL Import now handles DB2 functions with the ATOMIC clause.
ERS-16875	The performance of the Universal Naming Utility has been improved.
ERS-16954	The SQL Server view parser now handles table functions with '::" global qualifier.
ERS-16955	The DDL Wizard now generates the correct error message when attempting to overwrite an existing read-only file.
ERS-16970	The Report Title field in the Report Wizard is no longer disabled when the dialog is maximized.
ERS-16995	SQL Server view comments are now generated properly.
ERS-17044	ER/Studio DA no longer displays foreign keys that are hidden by denormalization mappings.
ERS-17160	The HTML Report wizard no longer displays duplicate Foreign Keys in the Relationship report.
ERS-17164	The DB2TbsPartitions automation collection now contains both defined and undefined partitions. A new Defined property was added to the DB2TbsPartition object to indicate whether the partition is defined or not.
ERS-17183	Moving attributes with user-defined mappings no longer causes errors in the DM1 file.
ERS-17193	The DB2 Procedure parser now handles different variations of CASE statements.
ERS-17261	The Naming Standard Utility now correctly modifies foreign key columss that are unified.
ERS-17264	The SQL Server function/procedure parser has been updated to handle value assignments in variable declarations.
ERS-17368	The Sax Basic Help menu item in the Help menu now works properly.
ERS-17392	The SQL Server View parser now handles views with the National Character Set prefix ('N').
ERS-17419	The Compare Wizard now remains stable when comparing models in separate DM1 files to generate alter SQL.
ERS-17449	ER/Studio DA now imports SQL Server 2008 scripts with computed columns.
ERS-17475	Deleting an attribute with User Defined Mappings no longer causes an error in the DM1 file.
ERS-17478	The DB2 table editor now allows users to specify strings of up to 128 characters.
ERS-17485	Enterprise Data Dictionary names are now preserved after checking in changes to the EDD definition.
ERS-17500	The MetaWizard now properly imports ERWin 7 files.
ERS-17512	The MetaWizard now properly imports COBOL Copybook files.
ERS-17524	The automation interface now maintains index column sequences after deleting a relationship.
ERS-17528	The Compare Wizard no longer shows differences in whitespace in procedures.
ERS-17577	The "Auto-Color All Entities With Foreign Keys" sample macro has been updated.
ERS-17582	The Compare Wizard now properly generates alter code for indexes with new columns.
ERS-17595	Duplicate parent keys are no longer displayed in the relationship editor after performing a copy and paste.
ERS-17626	The Compare Wizard now properly merges datatype changes when the source and target columns are bound to different domains.
ERS-17636	The automation interface Relationships collection has a new method, AddWithUnification that unifies new Foreign Keys with existing native attributes instead of deleting the native attributes.
ERS-17641	The Compare Wizard now properly sets the text list value to the default value when merging attachment bindings.
ERS-17666	The Compare Wizard now properly generates view comments for SQL Server.
ERS-17672	The MetaWizard now properly imports ERWin files that have relationships with no type set.
ERS-17732	ER/Studio DA now supports BINARY and VARBINARY datatypes for DB2 z/OS.
ERS-17741	The Compare Wizard now retains the domain folder structure when possible.
ERS-17748	Tables hidden due to denormalization mappings are now excluded from the Bound Objects automation collection.
ERS-17769	The MetaWizard now remains stable when selecting the Sparx Enterprise Architect (EA) via the UML 2.x XMI bridge.
ERS-17771	Foreign Keys are now properly inferred when reverse-engineering from MySQL.
ERS-17825	ER/Studio DA now remains stable when generating an HTML report with the Use Enhanced Version option enabled.
ERS-17826	The automation BoundObjects collection now works properly with unified attributes.
ERS-17845	The SQL Server Trigger parser now handles triggers with "FOR XML".
ERS-17869	Performance has been improved when displaying the Repository Delete Diagram and Repository Change Diagram Filename dialogs.
ERS-17941	Oracle Materialized View comments are now generated properly.
ERS-17952	The "Constraint Generator" sample macro has been updated to handle Reference Values with the "Values NOT Between" option set.
ERS-17997	The Index Editor now properly handles indexes that had the Piecesize set to an invalid value in the Generate Physical Model wizard.
ERS-18012	The Compare Wizard no longer shows differences in whitespace in functions.
ERS-18036	Some performance improvements have been made when expanding a diagram in the Repository Get Diagram dialog.

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase. Go to www.embarcadero.com, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with EmbarcaderoTechnologies, the Embarcadero Technical Support team is available to assist youwith any problems you have with our applications. Our maintenance contract alsoentitles registered users of Embarcadero Technologies products to download freesoftware upgrades during the active contract period. Evaluators receive freetechnical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.