ER/Studio
Home | ER/Studio
Documentation | IDERA Technical
Support | www.idera.com
Thank
you for using IDERA 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 the IDERA Web site, https://www.idera.com/support/productdocuments
WHAT'S NEW in version 20.3
Adds support for RSA SecureID single sign-on (SSO)
Updates the user experience to connect with Okta
SSO
Adds support for a Service principal account
Improves Security Audit Trail reporting
Release Notes
Upgrade Instructions
Upgrading from
ER/Studio Portal to Team Server
Upgrades for ER/Studio Repository
Users
Upgrades for version
of ER/Studio Repository prior to 2016
Additional Resources
What's New in Version 20.3
ER/Studio Data Architect 20.3 allows you to deploy a Devops process by integrating Data Architect with your Git
repository. This feature allows you to commit CREATE DDL to your Git repository
as well as use the Compare/Merge functionality to compare models with previous
versions of that CREATE DDL in your Git repository. You can get started in
setting up your Git integration by clicking the Git Options button in
the Tools menu. You must be in the Physical Model view for this option
to appear.
Adds support for RSA SecureID single sign-on (SSO)
This release of ER/Studio Team Server includes support for RSA
SecureID single sign-on (SSO). In the Configurator, select Use SSO, and
then select RSA Secure ID from the Select SSO Provider list. Note
that the fields change based on this selection. Be sure to complete these
fields as necessary for your SSO provider.
Updates the user experience to
connect with Okta SSO
ER/Studio Team Server's support of Okta SSO is expanded, with the
ability for users to manage dynamic Authorization and Scope data.
These details are added during setup using the Team Server Configurator or
managed using the process available in Configuring Your Okta SSO Provider.
Adds support for a Service principal
account
ER/Studio Team Server now supports a Service principal account for
Microsoft Entra as an alternative to basic authentication
for the Team Server backend database. In the Configurator, select MS Azure
SQL DB. Notice the Service Principal Authentication check box and
associated fields appear. Note that the user account adding this information
must have Create database privileges. In addition, the user account must
have the Log on as a service permission on the local app server as the
Repository services are changed to run under that account in order to connect
to the database using Service Principal authentication. If the account does not
have this permission, you will receive an error when testing the connection.
Complete the following fields:
·
Client ID and Client Secret.
Type the Azure AD service principal client ID and secret.
·
Database. Specify the name of the database
that you want to create for a new installation or update the name in the case
of an upgrade.
Once you complete these fields, click Test to verify your
entries. Click Next to continue.
Improves
Security Audit Trail reporting
Security Audit logging in Team Server is improved with this
release. In the Configurator, go to the Repository Setting page, and then check
the box for Enable Activity Logs to enable additional audit logging of
model changes and security updates. Make sure to click Next, and then
finish the Configurator for the changes to take effect. In addition, you must
open services.msc, and then restart the Idera Repository Database Server service.
To ensure compatibility
with ER/Studio Repository synchronization, this version of ER/Studio Data
Architect requires ER/Studio Repository (Team Server) version 19.1 or later 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
For the more recent
list of known issues and bug fixes in this release, see http://docwiki.embarcadero.com/ERStudioDA/203/en/Release_Notes.
Upgrade Instructions
Upgrading
from ER/Studio Portal to ER/Studio Team Server
For detailed instructions on upgrading to Team Server, see Install
or Upgrade Team Server and Repository.
Upgrades for ER/Studio Repository users
To use the repository with this release, you will need to be
running ER/Studio Repository (Team Server) 19.0 or later.
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 About
Team Server and Repository Upgrade.
All IDERA products include a 14-day trial period. To continue
using the product without interruption, we recommend that you license it as
soon as possible. For information on licensing your product, refer to the Quick
Start Guide. If you have not yet purchased this product, contact [email protected].
The IDERA Web site is an excellent source for additional product
information, including white papers, articles, discussion forums, and the IDERA
Knowledge Base. Visit www.idera.com/support,
or click any of the links below, to find:
If you have a valid maintenance contract with IDERA, the Technical
Support team is available to assist you with any problems you have with our
applications. Our maintenance contract also entitles registered users of IDERA
products to download free software upgrades during the active contract period.
Evaluators receive free technical support for the term of their evaluation (14
days).
We encourage you to open technical support cases via the Customer Support Center. For additional
information about IDERA Technical Support, visit the Support section of our Web site.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.