ER/Studio Family Features

ER/Studio Data Architect
Universal MappingsMap between and within conceptual, logical and physical model objects to view upstream or downstream
"Where Used" AnalysisDisplay mapping between conceptual and logical models and their implementations across physical designs
Visual Data LineageVisually document source/target mapping and sourcing rules for data movement across systems
Round-trip Database SupportForward and reverse engineering for multiple RDBMS and big data platforms
Advanced Compare and MergeEnable advanced, bidirectional comparisons and merges of model and database structures
Report GenerationCreate reports in HTML & RTF, and other formats (XML Schema, PNG, JPEG and DTD Output)
ER/Studio Team Server Core
Team CollaborationApply 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 RegistrySingle searchable registry of all available created or imported data sources
Model and Metadata AccessShare and collaborate on models and metadata across the organization with unlimited web user access
Enterprise GlossaryImport or create a standards-based central repository of glossaries comprising business terms
Semantic MappingRelate business terms to critical data elements including tables, columns, entities and attributes
Inline DefinitionsView definitions for registered data elements or business terms in integrated data access tools and internal webpages
Centralized ReportingMore than 20 out-of-the-box reports and a reporting wizard for ad hoc reports that can be exported to several formats and shared
Model Repository
Concurrent Model and Object AccessAllows real-time collaboration between modelers working on data models down to the model object level
Reviewing Changes and Resolving User ConflictConflict resolution through simple and intelligent interfaces to walk users through the discovery of differences
Version ManagementManages the individual histories of models and model objects to ensure incremental comparison between, and rollback to, desired diagrams
Component Sharing and ReusePre-defined Enterprise Data Dictionary eliminates data redundancy and enforces data element standards
Security Center GroupsStreamline security administration with local or LDAP groups improving productivity and reducing errors
Business Architect
Conceptual Model CreationSupports high-level conceptual modeling using elements such as subject areas, business entities, interactions, and relationships
Process Model CreationSupport for straightforward process modeling that uses standard elements such as sequences, tasks, swim lanes, start events, and gateways
Software Architect
Model Driven Architecture and StandardsSupports Unified Modeling Language ™, XML Metadata Interchange (XMI ® ), Query/ Views/Transformations (QVT) and Object Constraint Language (OCL)
Model PatternsPowerful re-use facilities to jumpstart projects through predefined patterns
Import bridgesAll 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 bridgesEasily export your models using industry-standard exchange formats such as XMI, XML, and XSD; included in Enterprise Team edition

Buy Now

Free Trial

ContactUs Nor


Feature Comparison

Platform Support

System Requirements


Customer Testimonials

Screen Shots

Product Videos

On-Demand Webinars

Database Tools Portfolio

The Business Value of Data Modeling Webinar

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