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
Business Data Objects Represent master data and transactional concepts with multiple entities and relationships, such as products, customers, and vendors
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 models, submodels, 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
Interactive Model Image Navigator View the data model image interactively within the Team Server web interface, including zoom, search, and repositioning functions
Enterprise Glossary View, classify, relate and centrally store authoritative business definitions in an extensible enterprise glossary of 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
Combined Deployment with Team Server Team Server and Repository have a shared database to simplify deployment and model storage and to eliminate synchronization while allowing for selective publication
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 align changes to user stories and development workflows
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
Data Lineage
Data Lineage Visibility Visualize source-target mapping and sourcing rules designed in an external Extract-Transform-Load (ETL) tool or Data Integration (DI) tool
ETL/DI Tool Integration Import mapping requirements information to the lineage model from most of the leading ETL and DI tools

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

Data modeling

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