Idera-logo

A Data Modeling Tool for Enterprise-Scale Data Architecture

With ER/Studio Enterprise Team Edition:

  • Perform change management and impact analysis on new policies or projected changes to data models, databases, or data fields
  • Ensure consistency between data models and database design while coordinating changes across development and BI teams and enabling a collaborative data modeling approach.
  • Lay the foundation for robust data governance, data governance frameworks, and data management
  • Build a company-wide business glossary to define and catalog data assets and data structures
floating

Get a Free 14-Day Trial

If you would like to speak with a representative, then please call +1 (713) 523-4433.

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

  • Data Dictionary Standardization

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

  • Database Model and Metadata Documentation

    Model data from numerous data types, as well as relational, NoSQL, Microsoft SQL Server, mySQL, big data, file based systems, business intelligence and ETL sources.

  • 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./li>

  • 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, XSD, PNG, and JPEG.

  • Data Lineage Visibility

    Leverage visualization for 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.

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

  • 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 terms with models and submodels to answer the important question, “What data do I have, and where is it?”

  • Ontology and Taxonomy

    Arrange business terms into comprehensive ontologies and taxonomies to provide a business-friendly knowledge graph of the metadata of the organization.

  • 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 Catalog

    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.

  • Advanced Search

    Easily search and filter results for data objects, data sources, glossaries, and terms.

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

  • Security Center Groups

    Streamline security administration with local or LDAP groups.

Copyright © 2004-2021 IDERA, Inc.