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 Repository for model version control and Agile change management to the industry-leading data modeling capabilities. ER/Studio Enterprise Team edition is the perfect solution for organizations that require a collaborative data 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.

Furthermore, with the Enterprise Team edition, you can create business glossaries with consistent terms and definitions to ensure that data models and databases are aligned to organizational usage.

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?

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

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, metadata, and relevant reports directly to a corporate Intranet or Web site for review by executive management or business managers. Business and technical users can also access metadata, produce reports, and collaborate on enterprise glossary terms and definitions using ER/Studio Team Server. 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, and forward engineer a model into a Hadoop table. Data Architect also reverse engineers MongoDB databases into an organized layout, and includes a special “is contained in” notation for nested objects. Support for forward engineering to blank-sample JSON is also incorporated 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

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

Yes, Portal is planned for EOL on 12/31/2015. 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?

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

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 can be viewed in DBArtisan and Rapid SQL. Note that an ER/Studio Team Server 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, an ER/Studio Team Server installation is required, which provides unlimited user access for developers and administrators.

The minimum purchase to acquire ER/Studio Team Server is the ER/Studio Enterprise Team edition.

How do I manage users in Team Server?

Team Server works with your LDAP directory. Alternatively, individual user logins can be created, or you can set up a ‘generic’ login for truly view-only intermittent users.

Free Trial

Buy Now

Contact Us


Feature Comparison

Platform Support

System Requirements


Customer Testimonials

Screen Shots

Product Videos

On-Demand Webinars

Database Tools Portfolio

Maintenance and Support

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