ER/Studio Frequently Asked Questions

General Questions

Which version is right for me?

ER/Studio Enterprise 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. Designed for the enterprise, it provides all the tools needed to diagnose and understand the impact of changes, promote data reuse, and effectively communicate models and metadata across teams and departments. ER/Studio Data Architect is the stand-alone edition for users only looking for data modeling. Both editions support a variety of 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 Repository and collaborate on enterprise glossary data definitions using CONNECT. 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.

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 editions; it is not sold separately. ER/Studio Enterprise 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

CONNECT Questions

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

The Exclusive licenses that are bundled with ER/Studio can be upgraded to CONNECT Author licenses.

Can concurrent Portal licenses be upgraded to CONNECT?

Concurrent Portal licenses can be upgraded to CONNECT licenses.

Can the Exclusive Portal licenses that are bundled with ER/Studio be installed on CONNECT?

Yes. Portal licenses can be installed on CONNECT. This allows an existing Portal user to preserve their accustomed Portal features set. Users who access CONNECT with a Portal license will see the Portal 2.0.x interface, and WILL NOT see any of the new CONNECT features. For instance, users that access CONNECT with a Portal license will not be able to see or search for Business Terms.

Can concurrent Portal licenses be installed on CONNECT?

Yes, concurrent Portal licenses can be installed on CONNECT, preserving Concurrent Portal functionality.

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 CONNECT?

Yes, CONNECT contains and preserves all of the functionality of Portal.

Does CONNECT replace Repository?

No, CONNECT does not replace the Repository. Like Portal, CONNECT synchronizes with the 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 CONNECT and drill down to see the data elements?

The tool-top pop-up in the browser will contain a link that points back to CONNECT. In order to see the semantic mappings, the user will have to follow the link back to CONNECT, which requires that they log into CONNECT. 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 can be viewed in CONNECT, in website pop-ups, and in DBArtisan and Rapid SQL. Note that a CONNECT license – Reader or Author – is required to view this information.

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

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

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

I am a DB PowerStudio user. Will all of the DB PowerStudio products integrate with CONNECT?

Currently, DBArtisan and Rapid SQL will integrate with CONNECT. DB Change Manager and DB Optimizer integration will be available with a later release.

Buy Now

Free Trial

ContactUs Nor

Datasheet

Feature Comparison

Platform Support

System Requirements

FAQ

Customer Testimonials

Screen Shots

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+