ER/Studio Family Features

ER/Studio Data Architect
Universal Mappings Map between and within conceptual, logical and physical model objects to view upstream or downstream
"Where Used" Analysis Display mapping between conceptual and logical models and their implementations across physical designs
Visual Data Lineage Visually document source/target mapping and sourcing rules for data movement across systems
Round-trip Database Support Forward and reverse engineering for multiple RDBMS and big data platforms
Advanced Compare and Merge Enable advanced, bidirectional comparisons and merges of model and database structures
Naming Standards Automatically apply a naming standards template across logical and physical models by binding it to entities and attributes
Report Generation Create reports in HTML & RTF, and other formats (XML Schema, PNG, JPEG and DTD Output)
ER/Studio Team Server
Team Collaboration Apply enterprise collaboration features such as activity and discussion streams, to capture and share corporate knowledge, in order to reduce time identifying and correcting expensive data quality issues
Data Source Registry Single searchable registry of all available created or imported data sources
Data Source Mappings Track and analyze the impact of data model changes back to affected data sources
Model and Metadata Access Share and collaborate on models and metadata across the organization with unlimited web user access
Enterprise Glossary Import or create a standards-based central repository of glossaries comprising business terms, and track changes with an audit trail
Glossary Hierarchy Create child glossaries that inherit a subset of terms from one or more glossaries to define a tiered structure that can correlate to organizational configurations
Semantic Mapping Relate business terms to critical data elements including tables, columns, entities and attributes
Inline Definitions View definitions for registered data elements or business terms in integrated data access tools and internal webpages
Centralized Reporting More than 20 out-of-the-box reports and a reporting wizard for ad hoc reports that can be exported to several formats and shared
Advanced Search Easily search and filter results for data objects, data sources, glossaries, and terms
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
Version Management Manages the individual histories of models and model objects to ensure incremental comparison between, and rollback to, desired diagrams
Component Sharing and Reuse Pre-defined Enterprise Data Dictionary eliminates data redundancy and enforces data element standards
Security Center Groups Streamline security administration with local or LDAP groups improving productivity and reducing errors
Agile Change Management Assign and track tasks associated with data models to keep the models relevant with fast-changing databases and applications
Business Architect
Conceptual Model Creation Supports 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
Software Architect
Model Driven Architecture and Standards Supports Unified Modeling Language ™, XML Metadata Interchange (XMI ® ), Query/ Views/Transformations (QVT) and Object Constraint Language (OCL)
Model Patterns Powerful re-use facilities to jumpstart projects through predefined patterns
Import bridges All editions include import capabilities from the native file formats of common modeling tools; Enterprise Team edition also includes importing from ETL and other sources
Export bridges Easily export your models using industry-standard exchange formats such as XMI, XML, and XSD; included in Enterprise Team edition

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

driving business value 159x228 registernow

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

Receive the newsletter and email alerts

Get RAD Studio Email Alerts