ER/Studio Frequently Asked Questions

General Questions

Which version is right for me?

ER/Studio Data Architect is the stand-alone edition for users only looking for data modeling. ER/Studio Data Architect Professional edition adds the model repository for version control to the industry-leading data modeling capabilities. ER/Studio Enterprise Team edition is the perfect solution for organizations that require a collaborative modeling environment or have a need for data modeling, business process modeling, and application modeling and reporting in a powerful multi-level design environment. All editions support a variety of relational and big data DBMS platforms, whether you need support for just one or for multiple database types in a heterogeneous configuration.

How does ER/Studio help me manage and control growth in data?

ER/Studio offers model-driven analysis of database objects with a clear separation between logical and physical layers. This allows a clear representation of data structures regardless of the implementation-specific optimizations on the physical layer. By leveraging the separation of logical and physical models, redundant data can be consolidated. Users can also leverage ER/Studio's reusability features and collaboration support to effectively work in teams and ensure consistency across their environment.

Can I leverage ER/Studio to improve data quality?

Yes. ER/Studio allows users to create reusable objects to foster standardization throughout the infrastructure. This ensures that data is consistent across different systems. In addition, ER/Studio provides a view of the "as is" data so users can look at data patterns. Users can leverage this knowledge to standardize data, ease integration between systems, and resolve potential data quality issues.

How would an ER/Studio modeling solution help increase user productivity?

ER/Studio provides an intuitive and easy-to-use interface that significantly reduces the time needed for users to become productive. ER/Studio users benefit from significant productivity gains through the advanced reusability features, the ability to import and export metadata from different systems, and the excellent graphic capabilities of the product.

How does ER/Studio support the use/reuse of metadata throughout the enterprise?

ER/Studio complies with the leading industry standards for metadata and modeling notations. This enables reusability of the metadata as well as integration with different applications. ER/Studio models can be imported and exported in standards-based formats for reuse in such applications as SOA, BPM, UML, business analytics, and integration products.

Does ER/Studio provide any benefits to non-users of the product (i.e. executive management and business managers)?

Yes. ER/Studio can facilitate communication with non-users of the product by publishing data models and metadata directly to a corporate Intranet or Web site for review by executive management or business managers. Users can also access metadata through the ER/Studio Model Repository and collaborate on enterprise glossary data definitions using ER/Studio Team Server Core. This data can be repurposed for use in other enterprise systems and reports.

How does ER/Studio facilitate SOA implementations?

With ER/Studio, you can export XML schemas and generate XSD from both logical and physical models. This allows for the re-use of existing metadata and ensures corporate standards are enforced.

How does ER/Studio document a big data store such as Hadoop Hive?

ER/Studio documents business names and descriptions for tables and columns, relationships among Hive datasets and data types, business rules and domains. ER/Studio Data Architect can natively reverse engineer a Hadoop Hive table into the modeling tool.

What is Software Architect in ER/Studio?

Software Architect is ER/Studio's UML modeling tool for application architects to visually design and analyze complex software applications. Supporting the UML 2.0 specification, Software Architect simplifies the design stage of a project by enabling developers and architects to organize and visualize the requirements, subsystems, design patterns, and audit and metrics of intensive software systems.

How can I purchase Software Architect?

Software Architect is available in the ER/Studio Enterprise Team edition; it is not sold separately. ER/Studio Enterprise Team edition combines UML modeling in Software Architect, along with data and business process modeling, and reporting into a multi-level design environment, providing you with one of the most powerful modeling and design solutions on the market.

How does Business Architect work with ER/Studio Data Architect?

Business Architect (formerly named EA/Studio) offers an import/export bridge to ER/Studio, allowing you to import data models into Business Architect. You can then create relationships between the entities and attributes from your data model and Business Architect business processes, business units, and stewards. You can also export conceptual data models created in Business Architect to ER/Studio as the foundation for logical and physical models.

What is the BPMN standard?

The Business Process Modeling Notation (BPMN) is an open standard developed by the Object Management Group (OMG) as a graphical notation to depict the steps in a business process. It is designed to be intuitive to the business community (using many common flowcharting shapes, for example), yet robust enough to allow for code generation (via BPEL, for example). Business Architect provides full support for process modeling that adheres to the BPMN.

How does Business Architect compare with a BPM Vendor or Suite like IDS Scheer, Pegasystems, Lombardi, etc.?

Business Architect is a lightweight business modeling tool that addresses process modeling (BPA) and conceptual modeling and its relationship to data. Business Architect helps data modelers and business users communicate better. Focused BPM tools focus more on the execution, simulation, and metrics associated with business process management.

How does Business Architect compare with EA vendors like Telelogic (Popkin) System Architect?

Business Architect provides a focused subset of a full enterprise architecture, offering deep functionality for data modeling, process modeling, and the interrelationships between process and data. EA vendors tend to have light coverage in a broader range of areas, including assets, network, etc. For customers focused on data and process, we offer an easier-to-use solution, and robust functionality.

How does Business Architect compare with a drawing tool like Visio?

In addition to diagramming capabilities, Business Architect captures meta-data associated with business processes. This allows users the capability to model the relationships between business processes and data models, and to export information into a variety of formats, including HTML, .PDF, Excel, ER/Studio, and more.

What is included in the Universal Data Models available from Embarcadero?

The UDM models offered by Embarcadero are based on those in The Data Model Resource Book series, but provide much more content than the book's supplement CDs, which provide the models via SQL DDL statements and are only current through 2001. The UDM models for ER/Studio include:

  • Comprehensive and updated models (based upon experiences with implementing the models over the years as well as additional research)
  • Extensive metadata such as comprehensive entity and attribute definitions (with many examples of instances), attribute domains, and relationship names
  • All the models laid out in graphical format in a full repository in ER/Studio with a library of integrated sub-models

ER/Studio Team Server Questions

Can the Exclusive Portal licenses that are bundled with ER/Studio be upgraded to ER/Studio Team Server?

The Exclusive licenses that are bundled with ER/Studio can be transitioned (through a sales engagement) to ER/Studio Team Server licenses, which are capacity based.

Can concurrent Portal licenses be upgraded to ER/Studio Team Server?

Contact your sales representative to obtain a quote and more information for transitioning your existing ER/Studio and Portal licenses to the latest release of ER/Studio Enterprise Team edition.

Can the Exclusive Portal licenses that are bundled with previous versions of ER/Studio be upgraded to ER/Studio Enterprise Team edition and ER/Studio Team Server Core?

Contact your sales representative to obtain a quote and more information for transitioning your existing ER/Studio and Portal licenses to the latest release of ER/Studio Enterprise Team edition.

Can Portal licenses be installed on the ER/Studio Team Server Core?

Yes. Portal licenses can be installed on the ER/Studio Team Server Core. This allows an existing Portal user to preserve their accustomed Portal features set. Users who access the ER/Studio Team Server Core with a Portal license will see the Portal 2.0.x interface, and WILL NOT see any of the new ER/Studio Team Server Core features. For instance, users that access ER/Studio Team Server Core with a Portal license will not be able to see or search for Business Terms. Contact your sales representative to obtain a quote and more information for transitioning your existing ER/Studio and Portal licenses to the latest release of ER/Studio Enterprise Team edition, to enable your deployment with the rich collaboration capabilities.

Is Embarcadero going to EOL (End Of Life) Portal?

Please refer to the Supported Versions page for information on EOL plans.

Are all of the Portal features, like Search, available in ER/Studio Team Server Core?

Yes, ER/Studio Team Server Core contains and preserves all of the functionality of Portal for collaborating on models, and expands upon those capabilities with the sharing of metadata through enterprise glossaries.

Does ER/Studio Team Server Core replace the Model Repository?

No, ER/Studio Team Server Core does not replace the Model Repository. Like Portal, ER/Studio Team Server Core synchronizes with the Model Repository, but does not replace its functionality.

Will the Semantic mapping information be available as a pop-up in your browser or will the user have to log into ER/Studio Team Server and drill down to see the data elements?

The tool-tip pop-up in the browser will contain a link that points back to ER/Studio Team Server. In order to see the semantic mappings, the user will have to follow the link back to ER/Studio Team Server, which requires that they log into ER/Studio Team Server. The link will then take them to the details for that particular term; no additional navigation is required.

The "sensitive data alerts" and other warnings, where are they visible? Do they appear in Rapid SQL and DBArtisan?

These alerts in ER/Studio Team Server Core can be viewed in DBArtisan and Rapid SQL. Note that an ER/Studio Team Server Core license is required to view this information.

I own Rapid SQL/DBArtisan/DB PowerStudio and want to use the new ER/Studio Team Server features. What is required to gain access to this new functionality?

In order to utilize ER/Studio Team Server features in Rapid SQL/DBArtisan/DB PowerStudio, two things are required: a ER/Studio Team Server installation, and a ER/Studio Team Server license for each Rapid SQL/DBArtisan/DB PowerStudio user.

The minimum purchase to acquire ER/Studio Team Server is the ER/Studio Enterprise edition. ER/Studio Team Server can be bought as an add-on to the single-platform version; the multi-platform version includes ER/Studio Team Server with a single ER/Studio Team Server license).

I am a DB PowerStudio user. Will all of the DB PowerStudio products integrate with ER/Studio Team Server?

Currently, DBArtisan and Rapid SQL will integrate with ER/Studio Team Server. DB Change Manager and DB Optimizer integration will be available with a later release.


Request DemoBlue

Buy Now

Free Trial

Contact Us

Top 10 reasons to switch to ER/Studio


Feature Comparison

Platform Support

System Requirements


Customer Testimonials

Screen Shots

Product Videos

On-Demand Webinars

Database Tools Portfolio

Agile Data Modeling

Try ER/Studio

BI/DW Resource Center

Learn best practices about data modeling for BI and data warehousing from industry experts Ralph Kimball, Bill Inmon and Claudia Imhoff.

Get Started! >

Connect Online

Facebook Facebook
Twitter Twitter
Google+ Google+
Community Community