ER/Studio Home | ER/Studio Documentation | Embarcadero Technical Support | www.embarcadero.com
Read Me Last Updated: April 2, 2013. 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
What's New in ER/Studio DA 9.5.1
What's New in ER/Studio DA 9.5
Release Notes
Additional Resources
Embarcadero Technologies Technical Support
What's New in ER/Studio DA 9.5.1
Distributing Columns for GreenPlum
Distribution keys are now supported for the GreenPlum platform. The Table editor has been expanded by adding a new Distribution tab for the GreenPlum 4.x platform.
The Distribution tab of the Table Editor for the GreenPlum platform allows you to create the DISTRIBUTED BY or DISTRIBUTED RANDOMLY statements that specify the distribution key. If you do not specify the columns of the distribution key and do not activate the random distribution option, the GreenPlum server will assign to the distribution key by default by the first column created in the table.
What's New in ER/Studio DA 9.5
The following sections provide a brief overview of the major features of ER/Studio Data Architect 9.5. You can find more in-depth information in the New Features Guide and in the Users Guide.
General Updates
Graphics Improvements
You can now select multiple objects (entities, views, and shapes) and apply a layout command. All relationships, view relationships or lines that belong to the selected objects will be affected by the layout. You can use existing layout commands from the menu and toolbar. If you want to layout the entire submodel, no objects should be selected. For more information, see Partial Layout.
Custom Datatypes
Using the Datatype Mapping Editor, you can now create your own custom datatypes. For more information, see Custom Datatypes.
Universal Naming Utility
From the Search Results window, you can now double-click an entry to gain access to the editor for the selected object editors.
Universal Mappings
Mappings you create for Tables, Attributes, Views and Shapes are now automatically matched when comparing and merging models. In addition, mapping you force in the Compare and Merge Utility can be saved in the target model for use in future compare/merge operations. You can see and edit the mappings you create on the Where Used tab of the object.
New Platform Versions
This release enhances support of the following database platforms through additional version support:
New Platforms
ER/Studio Data Architect now supports this database platform:
New Operating Systems
ER/Studio Data Architect now supports this Operating System:
New DBMS Features
DB2 LUW 9.x
TIMESTAMP datatypes now support generated by default option.
DB2 z/OS
Range-partitioned Universal Tablespaces are now supported
Netezza 6.0
Organizing keys are now supported
Oracle 10g and 11g
Capacity planning of tables can now be based on the average row size.
Teradata 12 and 13
ST_GEOMETRY datatype is now supported.
COLLECT STATISTICS and CHECKSUM clauses are now supported.
PostgreSQL 8.0 and 9.x
Support has been added for uuid, money, xml, and serial datatypes; uuid is mapped to the UNIQUEID logical type; money is mapped to MONEY logical type, xml is mapped to XML logical type; and serial is mapped to SERIAL/INTEGER logical type.
Repository Enhancements
Windows 8
Now supported for ER/Studio Data Architect Repository.
Security Center
To make it easier to handle permissions, group support has been added to the ER/Studio Repository Security Center. Repository administrators can assign roles to the group at repository, project and diagram levels, then simply add or remove users from the group to apply the settings to the users quickly and easily. The Repository administrator can either manually create a group and assign users to it or use and LDAP/Active Directory group and add users to the Repository to a group based on LDAP/Active Directory settings.
Release Notes
Known Issues
ERS-21891 | Partial Layout improperly affects edges that are not between selected nodes. |
ERS-22022 | Universal Mappings between objects in the same file do not show up properly in Where Used. |
ERS-22037 | UNIVERSAL_MAPPINGS:Universal Mappings aren't displayed properly in Where Used when matching objects in the same dm1 file. |
ERS-22061 | Cannot launch ER/Studio DA 9.5 after uninstalling ER/Studio DA 9.1.4. The workaround is to perform a repair install. |
ERS-22202 | COMPARE_MERGE: GENERATED BY DEFAULT option does not work correctly in logical to physical compare. |
ERS-22206 | Unmatching objects in the Compare Wizard does not automatically delete mappings between the objects. |
ERS-22230 | UNIVERSAL_MAPPINGS: Problems with Universal Mappings in View Editor Where Used tab. |
ERS-22432 | Problems connecting to Portal 2.0 in ERDA 9.5. |
Bug Fixes
Use your browser Find feature to locate a particular bug number or click a link below to see the issues addressed in a specific build.
Bugs Fixed in ER/Studio DA 9.5.1
Bugs Fixed in ER/Studio DA 9.5
Bugs Fixed in ER/Studio DA 9.5.1ERS-18860 | Korean Characters not displayed correctly in title or tree node. | ERS-21060 | Positioning coordinates are not being retained. Coordinates such as Horizontal position of the entity are not stored and/or computed properly. | ERS-21581 | Default Column Name incorrectly set to attribute name when rolenames cleared with multiple relationships to same entities. | ERS-21584 | Cleared rolenames not updated back to column name, or updated to attribute name. | ERS-21612 | Displays attribute name rather than logical rolename on Physical model when logical names are shown. | ERS-21723 | Data Flow diagram origins not preserved. | ERS-21801 | Fit Shape causes truncated text. | ERS-21811 | Verb phase positions not accurately maintained on Repo diagrams. | ERS-21815 | Submodels are not displayed correctly in html report. | ERS-21979 | Newly created non-specific relationships incorrectly have the Relationship.Mandatory property set. | ERS-21980 | Relationship.CardinalityNo always returns "Zero or More" for non-specific relationships, even for mandatory children. | ERS-21981 | Non-specific relationship cardinality inconsistently displayed. | ERS-22111 | Table Post-SQL should be generated before Comments. | ERS-22135 | Incorrect DDL generated for IDENTITY column - NOT NULL is not included resulting in deployment error. | ERS-22172 | PK attributes unified via the relationship rolename editor are re-appearing when progagated to another entity using a rolename. | ERS-22239 | Owner not included in MySQL DDL when Enclose In Backticks option is enabled. | ERS-22247 | Images copied to the clipboard no longer have shadows and arrow head is unfilled. | ERS-22250 | Non-identifying relationship lines no longer drawn correctly in all situations. | ERS-22254 | HTML Reports contains old Embarcadero logo. | ERS-22259 | When user hovers the cursor over relationship line the mouse does not change and he has difficulty selecting the relation to move it. | ERS-22292 | Copying operation results in a move operation. | ERS-22311 | Need a way to generate NOCOMPRESS, NOCACHE and NOPARALLEL clauses. | ERS-22343 | ER/Studio terminates with hash partitioned table syntax. | ERS-22359 | Dm1 corruption after rolling up some but not all subtypes. | ERS-22367 | "Apply to Submodel" menu option missing from the explorer tree. |
ERS-16901 | When you enter Grid Steps Per Line you now see the specified cell per sub grid. |
ERS-17597 | The Compare and Merge utility no longer drops Stored Procedures as if they were Triggers. |
ERS-18942 | New Domains are now created properly if user doesn't have Update Dictionary Object privileges. |
ERS-19083 | Formatting of the Table Summary page generated by the Reporting tool has been improved. |
ERS-19220 | On the Netezza platform, the Reverse Engineering Wizard no longer incorrectly identifies system objects and normal objects. System and user tables and views are now shown correctly in the wizard. |
ERS-19293 | TS: Alter script generated by the Compare/Merge Utility will not run as generated |
ERS-19308 | The Data Lineage dialog now launches quicker. |
ERS-19310 | Submodel Attachment Synchronization now works across .dm1 files. |
ERS-19658 | TS: DATA_SECURITY - Disable arrow keys when a Security Type is selected. |
ERS-19762 | In the Repository options, the server name field now allows more than 30 characters. If the server name is too long to be displayed in the text box, you can click on the text box to see the full name. |
ERS-19943 | On the Netezza platform, data types are merged correctly with and without the override data type option selected. |
ERS-20026 | Changing the table name within DDL tab page is now effortless. |
ERS-20086 | When moving attributes while the entities are checked in you are prompted to check out the entities before you can complete the move. |
ERS-20389 | The automation interface property, DataMovementRuleLink object now returns overriden text using the read/write ValueOverride property and the read only ValueCurrent property. You can also use the ValueOverride property to change the data movement rule. |
ERS-20396 | When a relationship is moved, the verb phrases now maintain their relative position to the relationship line. |
ERS-20513 | The options to reverse-engineer View and Other Dependencies are now saved in Quicklaunch files. |
ERS-20547 | When comparing a PDM from the tool with a database, the Compare/Merge tool now compares the tablespace of a HASH Partitioned PK index. |
ERS-20585 | TS: SQL_IMPORT: Import SQL fails to handle "CREATE OR REPLACE" and "REPLACE" statements. |
ERS-20670 | TS: COMPARE_MERGE: Phantom columns added to table after merge |
ERS-20843 | On the Oracle platform, the constraint name generated is now no longer than 30 characters. |
ERS-20854 | The Index is now recreated when column part of the index is changed using the Compare/Merge utility. |
ERS-20999 | You can now select and modify a relationship placed on a shape. |
ERS-21052 | On the Netezza platform the DOUBLE and DOUBLE PRECISION datatypes are no longer converted to a CHAR(10) datatype. |
ERS-21053 | TS: TERADATA - Support for TITLE option in Teradata |
ERS-21058 | On the DB2 LUW platform, the Generate By Default option is now available for TIMESTAMP columns. DB2 LUW. |
ERS-21071 | On the Oracle 10g platform, function-based indexes now longer show up as being different between PDM and database is there is no differences. |
ERS-21072 | On the SQL Server 2008 platform, the Identity Property options are now included when generating a Physical Model. |
ERS-21705 | TS: AI - Submodel scroll and zoom API properties do not function correctly or at all |
ERS-21078 | Data Lineage has been improved to prevent data lineage transformations from being connected in two different data lineage streams. |
ERS-21084 | Convert Case Name macro is now working as expected. |
ERS-21094 | TS: Named Release General Info discrepancy |
ERS-21100 | The clustered property is now ignored if the platform doesn't support clustered indexes. |
ERS-21124 | When running ER/Studio as a restricted user, there are no longer problems with upgrading models from earlier versions of ER/Studio DA to more recent versions. The memory leak that caused the problem has been fixed. |
ERS-21125 | The active model is now rendered again after deleting an enterprise dictionary to prevent problems when performing a Save As on a Repository file. |
ERS-21126 | Attributes are no longer removed from entities after canceling a checkout during a drag and drop operation. |
ERS-21131 | Refresh now updates macros renamed or added from the file system folder. |
ERS-21156 | Incorrect error no longer displays when editing recursive relationship where attributes are shared in compound primary key. Only one key needs to be rolenamed. |
ERS-21185 | Changing relationship layout from straight to elbowed no longer causes all verb phrase positions to be reset. |
ERS-21237 | If you try to create in submodel a previous deleted cluster between supertype and subtype, the appropriate message is displayed, "This entity is already a subtype of the selected parent entity". Otherwise, the appropriate message, "This entity is already a member of another subtype cluster" displays. |
ERS-21250 | Rolldowns on non-identifying relationships no longer propagate parent PKs to child PKs. |
ERS-21252 | Propagated keys from "Physical Only" relationships no longer show up in Compare and Merge." |
ERS-21263 | TS: COMPARE - Merging relationships does not include column rolename details. |
ERS-21266 | HTML Report now displays the Constraint Name in the correct location within the diagram image. |
ERS-21270 | TS: Get Named Release performance is slow when there are a large number of named releases for a diagram. |
ERS-21278 | Foreign key FK columns are no longer removed from tables as part of the Repository Add Diagram action. |
ERS-21284 | The automation interface property, DataMovementRuleLink object now returns overriden text using the read/write ValueOverride property and the read only ValueCurrent property. You can also use the ValueOverride property to change the data movement rule. |
ERS-21287 | The "Attribute name" field now has the "Logical Rolename" information for non-keys columns when PM is generated with the "Make Native" option checked and parent entity set as "Logical only." |
ERS-21327 | If a procedure references a view and all tables are removed, the diagram can now be added to the Repository. |
ERS-21330 | Drawing Transformation and Data Stream objects is no longer slow with multiple connected sources. |
ERS-21357 | TS: Problem parsing view with USING |
ERS-21367 | Resolved problem with upgrading the Repository database that required columns and rolenames to be updated right after getting a diagram. |
ERS-21371 | TS: COMPARE - Error comparing SYS.XMLTYPE datatypes. |
ERS-21405 | When checking in a model after modifying a view, a "_1" suffix is no longer added to Views with same name but different schema." |
ERS-21462 | TS: Oracle Synonym Wizard does not have enough space to see the full object name. |
ERS-21488 | Column name and rolename are now set properly after a merge. |
ERS-21497 | TS: PROC_PARSE: Syntax error in stored procedure containing keyword 'sparse' |
ERS-21573 | Resolved intermittent crashing problem while generating HTML reports when there is an Enterprise Data Dictionary in the file. |
ERS-21579 | TS: Metawizard - Unable to import SAP MDM 7.1 XML file. |
ERS-21611 | Setting a new attribute or column name using Attribute.AttributeName or Attribute.ColumnName now perform correctly if the name only differs by case. The Convert Name Case macro now works as expected. |
ERS-21618 | TS: OBJECT_TYPE: Syntax error near "'@someVariableName'" returned on the type validation |
ERS-21637 | TS: VIEWS - Support for the UNIPIVOT function within Views. |
ERS-21659 | TS REVERSE-ENGINEER: Sybase Connection is refused when having the ocs.cfg file |
ERS-21644 | Changes in General tab of the Naming Standards Template Editor are now saved to the Repository. |
ERS-21645 | Changes in General tab of the Naming Standards Template Editor are no longer overwritten when upgrading to the ER/Studio Data Architect 9.x.. |
ERS-21681 | Extra 'r' character is no longer appended to AS in the View validation. |
ERS-21728 | Relationship lines are no longer hidden during image copy and paste when in front of shapes, |
ERS-21729 | TS: ER/Studio crashing after macro execution |
ERS-21733 | Images copied to the clipboard now preserve their shadows, subtype connections, and subtype arrow graphics when pasted into other applications. |
ERS-21734 | TS: Subtypes no longer display correctly - lines do not meet shape |
ERS-21906 | TS: Ability to specify a float type without having to specifying the width. |
ERS-21915 | You can now specify the COMPRESS property for TIMEZONE and VARCHAR columns. |
ERS-21922 | TS: INDEX_EDITOR: Should enforce index name uniqueness at the table level instead of the model level for Teradata |
ERS-21924 | TS: MODEL_OPTIONS: Crash changing model options when focus is on a submodel |
ERS-21928 | Compare/Merge operartion involving denormalizations no longer cause an application crash. |
ERS-21939 | in the Export MetaWizard, the password is no longer displayed in readable text. |
ERS-21936 | TS: REVERSE_ENGINEER: Large view DDL statement truncated after reverse-engineering from Teradata |
ERS-21977 | Resolved error when importing Teradata comments. |
ERS-22056 | TS: METAWIZARD: Crash accessing Export Submodel Metadata on a partial physical diagram |
ERS-22062 | TS: Reverse Engineer - MySQL table name starting with number fails. |
ERS-22080 | TS: COMPARE_WIZARD: Problem matching security objects when comparing models |
ERS-22141 | TS: DDL_GEN: The order of foreign key columns is wrong, referencing wrong columns. |
ERS-22152 | TS: DDL_GEN: [TERADATA 13.10] Generated DROP INDEX statement is syntactically invalid. |
ERS-22214 | TS: REPO_MERGE: Submodel layout changes lost when second user checks in unrelated change |
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 the www.embarcadero.com.
To contact Support, go to Support.