Data Modeling and Architecture with a Model Repository

ER/Studio Data Architect Professional

Extensive Database Platform Support

Access and manage models for multiple relational and big data platforms, both on premises and in the cloud. Extensive platform support is enabled through native and database-specific ODBC connections.

Forward and Reverse Engineering

Generate physical data models from existing database designs. Construct graphical models from existing database or schema, for both relational and big data platforms. Easily apply design changes with formulated alter code

Universal Mappings

Map between and within conceptual, logical and physical model objects to trace objects upstream or downstream, using the repository, and specify metadata such as definitions, notes, and attachments

Data Dictionary Standardization

Define and enforce standard data elements, naming standards and reference values for use across and between data models

Advanced Compare and Merge

Enable advanced bi-directional comparisons and merges of models and database structures

Business Data Objects

Represent master data and transactional concepts with multiple entities and relationships, such as products, customers, and vendors

Submodel Management

Allow creation of multi-leveled submodels, merge submodel properties across existing models and synchronize submodel hierarchies

Naming Standards

Assign a naming standards template to models, submodels, entities and attributes for automatic application between logical and physical models

Automatic Migration of Foreign Keys

Maintain foreign keys to ensure referential integrity in database designs

”Where Used” Analysis

Display mappings between logical entities and attributes to their implementation across physical designs

Model Completion Validation

Automate model reviews and enforce standards by validating for missing object definitions, unused domains, identical indexes and circular relationships

Visual Data Lineage

Visually document source/target mapping and sourcing rules using a drag-and-drop interface to understand Extraction, Transformation, and Load (ETL) data movement across systems

Source-to-target Mapping

View the relationships between the source and target, how the data flows from one table to another, and how the data is transformed

Dimensional Modeling

Leverage complex star and snowflake schema designs and support importing rich dimensional metadata from BI and data warehouse platforms

Metadata Integration

Import and export metadata from BI Platforms, UML and data modeling solutions, XML Schemas and CWM (Common Warehouse Metamodel) to create a metadata hub

Data Classification

Categorize and label objects according to the level of security and privacy

Permission Management

Enable user, role and group permissions at logical and physical level

Security Attributes

Define data security types and properties to be observed and enforced for compliance

Security Center Groups

Streamline security administration with local or LDAP groups improving productivity and reducing errors

Concurrent Model and Object Access

Allows real-time collaboration between modelers working on data models down to the model object level with token-based check-in/check-out

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

Predefined Enterprise Data Dictionary eliminates data redundancy and enforces data element standards

Agile Change Management

Assign and track tasks associated with data models to align changes to user stories and development workflows.

Advanced Graphics and Layout

Automatically create highly readable, highly navigable diagrams with one or a combination of layouts

Automated and Custom Transformation

Streamlines the derivation of one or more physical designs from a logical one and checks for normalization and compliance with the target database

Rich Text Editing

Easily edit text in data object fields, with integrated spell-checking, embedded hyperlinks, and text wrapping.

Extensible Automation Interface

Automate tedious, routine tasks such as coloring tables, enforcing and applying naming standards, globally update storage parameters and integrate with desktop applications

Multiple Reporting Formats

Publish models and reports in a variety of formats including HTML, RTF, XML Schema, PNG, JPEG and DTD Output


Buy Now

Includes first year of maintenance.

Add to Cart
Request a Quote

Live Product Demo

See ER/Studio Data Architect in action with a seasoned pro.

Request a Demo