Data modeling tool for designing and understanding your databases

ER/Studio helps data architects discover, document, and re-use data assets and gives you the power to easily reverse-engineer, analyze, and optimize existing databases.

ER/Studio Data Architect
Key Features:
  • Complete database lifecycle support for forward and reverse engineering
  • Advanced bi-directional compare and merge for models and database structures
  • Data  dictionary standardization with domain inheritance, reusable objects, and automatic updates
  • Data lineage support with visual documentation of source/target mapping
  • “Where Used” analysis and user-defined mappings
  • Nested and attribute level submodel management
  • Customized XML schema generation
  • Advanced diagram and layout engines
  • Available add-on products for industry standard models/patterns
  • Centralized license management and tool deployment with Embarcadero ToolCloud

ER/Studio Data Architect is an industry-leading data modeling tool that enables companies to discover, document, and re-use data assets. With round-trip database support, data architects have the power to easily reverse-engineer, analyze, and optimize existing databases.  ER/Studio Data Architect’s strong reporting and communication capabilities help enforce organizational standards and achieve higher levels of productivity.

  • Enterprise wide data lineage and traceability
  • Automated model publication, communication and collaboration
  • Round-trip engineering
  • Multiplatform database lifecycle support

Ready to Upgrade to ER/Studio Enterprise?

Combining process modeling, data modelingUML modeling, a server- side repository, and a metadata reporting engine, upgrading to ER/Studio Enterprise provides you all the tools you’ll need to analyze,  model and design your complex applications and databases. Learn more about ER/Studio Enterprise.

Stuck On an Outdated Modeling Tool?

Making the switch and upgrading to ER/Studio is simple and easy. Read more about upgrading from ERwin or PowerDesigner.

ER/Studio Data Architect 8.5

New! Expanded Visual Data Lineage

enhanced_data_lineage_thumb
  • Communicate data flows more effectively with ETL developers.
  • Reduces need for spreadsheets that are quickly outdated to communicate source/target mappings between systems.

Portal Integration

portalsupport_thumb
  • Search and browse the Portal directly from the Repository within the Data Architect client for easy retrieval of metadata and diagrams.

Workflow Commenting & Labeling

object_commenting_thumb
  • New Workflow Communication facilities with web 2.0 technologies between ER/Studio Data Architect and Portal.
  • Communicate with DBA’s, developers, and business analysts more effectively during model reviews.

Learn more about other tools like Universal Data Models, ER/Studio MetaWizard, ER/Studio Viewer and other complimentary tools.

Revision Information:

  • Current Version: 8.5.3
  • Prior Version: 8.5.2
  • Current Release: February 2010
 
Database Tools | Developer Tools | Channel-E