Welcome to ER/Studio Data Architect 10.0.2

ER/Studio Home | ER/Studio Documentation | Embarcadero Technical Support | www.embarcadero.com

Read Me Last Updated: Mar 05th, 2015. Any updates to these Read Me notes will be available at docs.embarcadero.com.


database award logo
DBTA100 SDT100_2014 SD Times Award

SD Times Award

CS Award

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 10.0.2

MongoDB Authentication Options
MongoDB Forward Engineering
Sybase Adaptive Server IQ 15 and 16 now supported

WHAT'S NEW in 10.0.1

New 64 bit Version
Hive DB Support
MongoDB Support
Sax Basic updated
MIMB 8.0 64-bit updates

Release Notes

Important Installation Notes

Important Release Advisory

Bug Fixes

Known Issues

Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server Core

Upgrades for ER/Studio Repository 6.7 users

Upgrades for version of ER/Studio Repository prior to 6

Additional Resources

Embarcadero Technologies Technical Support



What's New in 10.0.2

MongoDB Authentication Options

When Reverse Engineering a MongoDB database, further authentication options are now available.

MongoDB Forward Engineering

Using the The DDL Generation Wizard it is now possible forward engineer a MongoDB database.

Sybase Adaptive Server IQ 15 and 16 now supported

We have now included support for the latest versions of Sybase. This includes generating physical models, modeling, forward and reverse engineering and more.


New in 10.0.1


New 64 bit Version
ER/Studio Data Architect and ER/Studio Repository now run as a native 64-bit application. Separate installers let you choose between 32-bit and 64-bit applications. You must be using 64-bit versions of DBMS platform drivers when using the 64-bit version of ER/Studio Data Architect.


Hive DB Support
As part of the increasing support for big data platforms, this release provides native support for reverse-engineering Hive 0.12 and 0.13.


MongoDB Support
As part of the expanded platform support and to enable better visibility into metadata for unstructured data formats (including a notation to show nested data hierarchies that is unique to ER/Studio), this release provides native support for MongoDB 2.4 and 2.6.


Sax Basic updated
Version 10 of Sax Basic, now called WinWrap basic, has been upgraded to the latest version. This update includes all the latest features and updated documentation.


MIMB 8.0 Updates
The MetaWizard bridges now include 64-bit ERWin import bridges.

Release Notes

Important Installation Notes


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 ER/Studio Team Server. 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 10.0.2


ERS-23914 ER/Studio now supports the Hortonworks Hive ODBC driver.
ERS-24042 The MetaWizard now supports MS SQL Sever Analysis Services 2012.
ERS-24059 The "Selectively Update Index" macros have been fixed to run properly in WinWrap Basic.
ERS-24082 The Reverse-Engineer wizard now properly stores multiple database selections in the quicklaunch.
ERS-24094 The "Move-Up Key Columns" sample macro has been improved to reflect the column order of the parent table(s).
ERS-24126 Several issues with importing Sparx Enterprise Architect have been resolved in the MetaWizard.
ERS-24141 The nullability of a column is no longer changed when changing datatypes.
ERS-24145 The application now remains stable when switching between Teradata tables within the table editor.
ERS-24213 ER/Studio now supports reverse-engineering Teradata tables with names longer than 30 characters.
ERS-24248 The "Export Meta Data to Excel Version 2.1" sample macro now exports PK and FK properties properly.
ERS-24256 Relationship verb phrase positions are now saved properly.
ERS-24387 Performance when modeling in a diagram that has many submodels has been greatly improved.



Known Issues

ERS-23001 Performance issues when navigating and editing tables.
ERS-24257 Cannot connect to MongoDB with URI in Compare/Merge wizard.
ERS-23678 Reverse engineering from MongoDB creates incorrect results with fields or arrays using different data types.
ERS-23791 Compare/Merge fails to properly merge MongoDB objects in some cases.




Upgrade Instructions

Upgrading from ER/Studio Portal to Team Server Core


For detailed instructions on upgrading to Team Server, see the Upgrade Notes.

Upgrades for ER/Studio Repository 6.7 users


Keep the following in mind when updating for this release:

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

Preparing to Upgrade the Repository

  1. Ensure you have backed up all your .dm1 files.
  2. 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.
  3. Rename all local copies of Repository diagrams in the active file directory as follows:
  4. Ensure no one is logged into the Repository.
  5. Backup the current Repository database.
  6. 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.

  1. Log on to Windows with local administrator privileges.
  2. Start the Repository installation program and select Repair Repository Services. The installation program starts the following services:

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.