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.
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.
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.
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.
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.
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.
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.
ER/Studio documents business names and descriptions for tables and columns, relationships among Hive datasets and data types, business rules and domains.
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.
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.
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.
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.
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.
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.
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.
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
The Exclusive licenses that are bundled with ER/Studio can be upgraded to CONNECT Author licenses.
Concurrent Portal licenses can be upgraded to CONNECT licenses.
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.
Yes, concurrent Portal licenses can be installed on CONNECT, preserving Concurrent Portal functionality.
Yes, CONNECT contains and preserves all of the functionality of Portal.
No, CONNECT does not replace the Repository. Like Portal, CONNECT synchronizes with the Repository, but does not replace its functionality.
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.
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.
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).
Currently, DBArtisan and Rapid SQL will integrate with CONNECT. DB Change Manager and DB Optimizer integration will be available with a later release.