Idera-logo

A data governance solution with a user-friendly interface

With ER/Studio Data Architect:

  • Build out an enterprise data model as entity relationship diagrams (ERD)
  • Create a data catalog to support data governance initiatives and seamless metadata management
  • Discover and document your existing data assets
  • Lay the foundation for robust data governance and data management
floating

Get a Free 14-Day Trial

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

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

  • 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, bidirectional comparisons and merges of model 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 high-quality data standards by validating for missing object definitions, unused domains, identical indexes and circular relationships.

  • Data Lineage Visualization

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

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