Fraud Blocker
Zum Inhalt springen

ER/Studio

Model, Analyze and Optimize Enterprise Data

ER/Studio is the fastest, easiest and most collaborative way for data modelling professionals to build and maintain enterprise-scale databases and data warehouses. ER/Studio sets a new standard for data management.
Create effective models to build a business-driven data architecture.

  • Document and enhance existing databases to reduce redundancy
  • Implement naming standards to improve data consistency and quality
  • Effectively share and communicate models across the enterprise
  • Map data sources and trace origins to enhance data lineage

Info

What is ER/Studio?

ER/Studio is a business process and conceptual modelling tool that simplifies how business stakeholders and data architects document conceptual models and business processes and how those processes impact enterprise data to align with business goals and regulatory requirements. Bringing together the simplicity of a drawing tool with the rich semantics of the BPMN 2.0 standard, business users and data professionals can easily model the relationships between people, processes, and data with Business Architect.

Neuigkeiten

New features in ER/Studio

ER/Studio 21.1 is mainly focused on AI readiness, semantic modelling and data governance. IDERA positions it as helping organisations build a stronger semantic backbone for AI ready data platforms.

The key areas are:

  • AI assisted data modelling, helping users create and maintain data models faster
  • Semantic modelling, improving how business meaning and definitions are connected to underlying data models
  • Stronger data governance, supporting consistent terminology and trusted data across the organisation
  • Governance integrations, including platforms such as Microsoft Purview and Collibra
  • Reusable semantic assets and universal mapping, making models easier to use across analytics, governance and AI initiatives
  • Improved automation, including logical to physical model transformation, forward engineering and DDL generation
  • Git based version control, improving collaboration and management of model changes

Competitive Differentiation

Competitive Differentiation

ER/Studio Business Architect Process models can now be built and validated with all BPMN 2.0 constructs. At times other products in the market claim to be BPMN 2.0 compliant but do not implement the full set of constructs with validation that conforms to the BPMN 2.0 standard. The fact that we offer Business Architect as a standalone product and an integral part of ER/Studio Enterprise Team Edition gives our customers maximum flexibility. We offer an easy-to-use solution that shares models, common objects, and glossaries across the organization, improving productivity and alignment.

Through ER/Studio Enterprise Team Edition, we provide a comprehensive, collaborative platform that encompasses Data Modeling, Business Process Modeling, and Enterprise Architecture to establish a foundation for Data Governance initiatives. In particular, this builds on our strong history in which we have provided integrated data and process modelling within the ER/Studio suite for over ten years. Other solutions in the marketplace claim to do the same but are comprised of separate, non-integrated products. In particular, Erwin has been making numerous claims regarding their leadership in enterprise architecture even though the process modelling products they acquired through corporate acquisitions (Corso and Casewise) are not integrated into the core Erwin data modeller products. Thus, creating silos rather than breaking them down.

ER/Studio Data Architect includes all the features you need to create and manage logical and physical data models, including detailed compare and merge capability, naming standards, data dictionaries, and extensive platform support.

ER/Studio Business Architect also includes the shared model repository for model change management and version control with branch and merge support.

Ausgaben

ER/Studio Editions

ER/Studio offers three editions tailored to different team sizes, goals, and governance requirements:

Enterprise Edition
Our all-inclusive package. Enterprise Edition delivers comprehensive governance, multi-domain modeling, and full integration with enterprise data governance platforms like Collibra and Microsoft Purview. It’s built to support complex environments, cross-functional teams, and regulatory compliance at scale. If you need traceability, auditability, and alignment across the enterprise—this is your edition.

Professional Edition
Designed for collaborative teams ready to move beyond spreadsheets and silos. Professional includes shared model repositories, metadata management, and business glossary integration to align technical and business stakeholders.

Standard Edition
A streamlined solution for individual modelers or small teams tackling foundational projects. Standard supports core modeling functions with the flexibility to scale up when you’re ready.

No matter your current architecture or maturity level, there’s an ER/Studio edition designed to match your needs—and evolve as your data strategy grows.

Systemanforderungen

Systemanforderungen

Minimum hardware requirements:

  • 2GB RAM, 2.5GB disk space

Supported Operating Systems:

  • Windows 11 and 10 (64-bit)
  • Windows Server 2025, 2022, 2019, 2016

ER/Studio Platform Support

  • Microsoft SQL Server 2025, 2022, 2019, 2017, 2016 and older
  • Microsoft Azure SQL Database
  • Microsoft Azure Synapse Analytics
  • Oracle Database 23ai/23c, 19c, 18c, 12c, 11g and older
  • PostgreSQL Up to 16.x
  • IBM Db2 LUW Up to 12.x
  • IBM Db2 for z/OS Up to 13.x
  • Snowflake
  • Databricks
  • Amazon Redshift
  • Google BigQuery
  • MongoDB 2.6 through 4.x
  • MySQL 3.x through 8.0
  • Teradata Multiple versions through 15.10
  • SAP ASE
  • SAP IQ
  • Firebird
  • Hadoop Hive
  • IBM Informix
  • IBM Netezza
  • JSON Instance and Schema files
  • Generic DBMS

Support

Informationsmaterial

Wir empfehlen folgende Online-Support-Seiten und -Ressourcen, damit Sie Ihr Produkt optimal nutzen können.

Support

We offer technical support to all Alfasoft customers. We recommend visiting our Help Centre and Knowledge Base, where you will find helpful resources, including solutions to frequently encountered issues and a wealth of additional information.

Wenn Sie die Antwort nicht finden können, reichen Sie bitte ein Support-Ticket in unserer Support und Knowledge Base ein. Geben Sie bei der Erstellung Ihres Tickets so viele Details wie möglich an. Dadurch können wir das Problem besser verstehen und eine genauere Lösung anbieten. Denken Sie immer daran, Informationen zu Ihrer Produktversion und Ihrem Betriebssystem anzugeben.