Forward and Reverse Engineering

Use ER/Studio Data Architect to generate source code from existing databases, construct graphical models from existing database or schema, and easily apply design changes with generated ALTER code.

“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.

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.

Process Model Creation

Design straightforward process models that use standard elements such as events, tasks, gateways, pools/swim lanes, choreographies and conversations, using BPMN 2.0 notation.

Process Validation

Validate your business processes based on BPMN 2.0 standards (in real time or as needed).

Conceptual Model Creation

Create high-level conceptual models using elements such as subject areas, business entities, interactions, and relationships.

Import/Export Capabilities

Easily export conceptual models to ER/Studio Data Architect to create logical models, and import logical data models from Data Architect.

Model Driven Architecture and Standards

ER/Studio Software Architect 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.

Round-Trip Database Support

Perform native forward and reverse engineering for multiple RDBMS and big data platforms, both on premises and in the cloud. Extensive platform support is enabled through native and database-specific ODBC connections.

Import Bridges

Import model information from BI, ETL, and NoSQL platforms, other modeling tools, and industry-standard metadata interchange formats.

Export Bridges

Easily export your models to BI, ETL, other modeling tools, and industry-standard exchange formats such as XMI, XML, and XSD.

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.

Model Storage and Publication

Store files in the shared model Repository and publish them to Team Server for viewing, when working with the Enterprise Team Edition.

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

Reviewing Changes and Resolving User Conflict

Resolve conflicts through simple and intelligent interfaces to walk users through the discovery of differences.

Agile Change Management

Assign and track tasks associated with data models to align changes to user stories and development workflows; view and edit tasks in both Data Architect and Team Server, and link projects and tasks to JIRA records

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.

Universal Mappings

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

Interactive Model Image Navigator

View the data model image interactively within the Team Server web interface, including zoom, search, and re-positioning functions.

Team Collaboration

Apply enterprise collaboration features such as activity and discussion streams, to capture and share corporate knowledge and reduce time identifying and correcting data quality issues.

Enterprise Glossary

View, classify, relate and centrally store authoritative business definitions in an extensible enterprise glossary of business terms, and associate glossaries with models and submodels

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, and view associated Universal Mappings in the detailed description

Data Source Registry

Create and view a 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.

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.

Security Center Groups

Streamline security administration with local or LDAP groups.