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.
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.
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.
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).
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 model information from BI, ETL, and NoSQL platforms, other modeling tools, and industry-standard metadata interchange formats.
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
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.
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.
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.
View, classify, relate and centrally store authoritative business definitions in an extensible enterprise glossary of business terms, and associate glossaries with models and submodels
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.
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.
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.
Easily search and filter results for data objects, data sources, glossaries, and terms.
Security Center Groups
Streamline security administration with local or LDAP groups.