Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

ER/Studio XE2 is the fastest, easiest and most collaborative way for data management professionals to build and maintain enterprise-scale databases and data warehouses. Built in facilities automate routine modeling tasks so users can analyse and optimise database and data warehouse designs faster than ever. With a server-side model management system and online portal, it is simply the most productive way to share, document and publish your models and metadata to distributed teams.

ER/Studio XE2 includes ER/Studio Data Architect, ER/Studio Business Architect, ER/Studio Software Architect, ER/Studio Portal, ER/Studio Repository, MetaWizard and AppWave.

Features

Key features

ER/Studio Data Architect

• “Where Used' Analysis with User-defined Mapping - Displays the mappings between logical entities and attributes and their implementation across physical designs. Allows data architects to customise the mapping of logical and physical artifacts for informational purposes.
• Visual Data Lineage - Visually documents source/target mapping and sourcing rules for data movement across systems. Customise data flows with shapes.
• Round-trip Database Support - Round-trip database support for forward and reverse engineering.
• Advanced Compare and Merge - Enables advanced, bidirectional comparisons and merges of model and database structures such as logical-to-physical, physical-to-physical, physical-to-database, etc.

ER/Studio Business Architect

• Conceptual Model Creation - Support for high-level conceptual modeling using elements such as subject areas, business entities, interactions, and relationships.
• Process Model Creation - Support for straightforward process modeling that uses standard elements such as sequences, tasks, swim lanes, start events and gateways
• BPMN Compliance - Optional automatic validation of process diagrams to ensure compliance with the BPMN specification and prevent the addition of non-compliant modeling elements.
• CRUD Reporting - CRUD reports identify which processes affect which data, and what affects they have. Reports are available in a straightforward spreadsheet view.

ER/Studio Software Architect

• Model Driven Architecture & Standards - Support Unified Modeling Language (UML 2.0 ), XML Metadata Interchange (XMI), Query/ Views/Transformations (QVT) and Object Constraint Language (OCL).
• Model Patterns - Provides powerful re-use facilities to jumpstart projects through predefined patterns.
• Document Generation - Document generation facility and templates to create external documentation to track projects. Export formats to RTF, HTML, TXT and PDF.
• Quality Assurance - Analyse and measure ongoing projects with OCL-base model audits and metrics that can easily be defined, saved and re-used.

ER/Studio Portal

• Structured Browsing & Navigation - Provides a web-based navigation of the repository diagrams The user will be presented with a scrollable list of projects and the diagrams contained within each repository project folder.
• Technical Reports - Pre-installed for implementation details such as data types, column width, column names, how objects are related, data lineage between models, and security classification information.
• Automatic Data Synchronisation - As diagram objects are added, deleted, or updated in the ER/Studio Repository, the most recent version of the diagram will be sent to the reporting portal. Synchronisation can be scheduled at the administrator’s discretion.
• Advanced Searching - Wildcard searching with the ability to limit the search to specific object types or specific projects and specify a sort order.

ER/Studio Repository

• Concurrent Model and Object Access - Allows real-time collaboration between modelers working on data models down to the model object level.
• Reviewing Changes and Resolving User Conflict - Conflict resolution through simple and intelligent interfaces to walk users through the discovery of differences identified between a specific user’s model and changes that have occurred simultaneously to the model by others connected to the Repository.
• Version Management - Manages the individual histories of models and model objects to ensure incremental comparison between, and rollback to, desired diagrams and diagram elements.
• Component Sharing and Reuse - Pre-defined Enterprise Data Dictionary that eliminates data redundancy and enforces data element standards.

Benefits

• Diagnose and understand the impact of changes more effectively with 'where used,' data lineage, enterprise data dictionary and 'compare and merge' technologies.
• Promote data reuse and collaboration in real-time through effective enterprise model management and metadata publication capabilities.
• Enhance visibility and information quality across enterprise systems with round-trip engineering and complete database lifecycle support.
• Effectively communicate models across the enterprise with real-time metadata reporting and publishing tools.
• With AppWave, you can experience your apps friction-free, like a mobile app.