Enterprise Data Modeling Plus
ER/Studio Product and Feature Comparison
Enterprise Data Modeling, Metadata Management, and Data Governance Made Easier
The World Runs on Data…ER/Studio Runs Data Smarter
ER/Studio is more than a data modeling tool; it’s a strategic enabler. ER/Studio empowers organizations to model their data wherever it resides, understand it, and strategically leverage it. The benefits of Data Governance can be attained and management is simplified because of the comprehensive enterprise data model and business glossaries ER/Studio produces. ER/Studio bridges the gap between technical data management and strategic business decision-making.
Your environment is unique, as are your data strategy and management needs. Speaking to a product specialist is the best place to start.
Contact →
ER/Studio Works with: Oracle, MySQL, Microsoft SQL ServerSQL, IBM Db2, MongoDB, Snowflake, Google BigQuery, Teradata, and many more. Coming soon Databricks – stay tuned.
ER/Studio Integrates with: Collibra, Silwood Safyr, MetaIntegration, Atlassian Jira, and WhereScape. Many more integrations coming soon.
ER/Studio Standard
ER/Studio Standard (Data Architect) is designed for crafting clear, business-focused data models. It supports a wide range of data schemas, accommodating everything from operational databases to advanced data warehouses and business intelligence systems.
Starting at $1,470
Includes:
- ✓ Articulate data requirements through graphical models.
- ✓ Design and document a wide range of data products using forward and reverse engineering.
- ✓ Use Compare/Merge function to translate changes into ALTER scripts for your databases as business requirements evolve.
ER/Studio Professional
Expands ER/Studio Standard with a repository for team collaboration and project version management that propels data modeling strategy. This allows for streamlined teamwork that provides a robust framework for managing various iterations of data models.
Includes ER/Studio Standard, PLUS:
- ✓ Collaborate easily with team-based model sharing and versioning.
- ✓ Leverage central repository for data models for broader team collaboration.
- ✓ Build libraries of shared components that drive standardization.
ER/Studio Enterprise
ER/Studio Enterprise, paired with Team Server Core, is designed to manage large-scale enterprise projects. This combination connects data architecture seamlessly with data governance, creating an integrated, company-wide data ecosystem.
Includes ER/Studio Professional, PLUS:
- ✓ Use MetaWizard bridges to model a broad range of data platforms.
- ✓ Create a business glossary integrated with popular Data Governance tools.
- ✓ Develop and publish an enterprise data model with conceptual and logical layers for strategic planning.
- or strategic planning.
Data Modeling
Conceptual data modeling (basic)
Business process modeling (basic)
Logical data modeling
Physical data modeling
Relational or dimensional data modeling
Hierarchical data modeling
Data flow modeling (data lineage modeling) (ETL modeling)
Forward engineering (design new database)
Reverse engineering (from existing database)
Compare and merge
Data dictionaries
Automation
Data model import
Data model export
Data dictionary import
Limited metadata import (MetaIntegration Technology’s MetaWizard bridges)
Integrate with ERP and CRM metadata import (Silwood’s Safyr)
Data Model and Metadata Storage Database
Metadata, and Data Governance Collaboration Platform
Data model and metadata publication
Glossaries
Terms
Entity-relationship object
Data sources
Data catalogs
Report sharing (business reports and technical reports)
Activity notifications
Change management
Business term harvesting
Graphical visualization of relationships
Integrate with data warehouse automation (Idera, Inc.’s WhereScape)
Integrate with data governance (Collibra)
Business Process and Conceptual Modeling
Business process modeling
Conceptual modeling
Impact analysis diagram
Impact analysis report and web report
Conceptual model import from Data Architect’s logical models
Conceptual model update from Data Architect’s logical models
Conceptual model export to Data Architect’s logical models
Data import
Microsoft Visio diagram import
Diagram export
Grid editor data export
Grid editor data import
Workspace export and import
Full Metadata and Data Lineage Import and Export
* Full Metadata and Data Lineage Import and Export can also be an Add-on for Standard and Pro.
Full metadata import (MetaIntegration Technology’s MetaWizard bridges)
Metadata export (MetaIntegration Technology’s MetaWizard bridges)
Data lineage import (MetaIntegration Technology’s Data Lineage bridges)