ER/Studio 20.6の導入：データボールト設計の自動化とデータプラットフォームのサポートの拡張

We are excited to announce the release of ER/Studio 20.6, delivering groundbreaking automation for Data Vault modeling along with expanded support for modern databases and data lakehouse architectures.

Data Vault Modeling Just Got Smarter

The highlight of ER/Studio 20.6 is the introduction of intelligent wizards and マクロ that make Data Vault modeling easier, faster, and fully business-driven. These are more than simple templates—they ensure your Data Vault remains aligned with enterprise-wide business models rather than being dictated by source systems.

How ER/Studio 20.6 Automates Data Vault Modeling

Business-Driven Hub & Link Creation

• The new wizard allows you to select logical entities from an existing business data model and transform them into hubs and links using accepted business keys.
• Naming standards and governance rules are automatically applied to ensure consistency and compliance.

Effortless Satellite Generation

• Easily create satellites from source system models and attach them to a predefined palette of hubs and links, ensuring a clean, business-aligned データ保管庫.
• This prevents the creation of redundant or inconsistent Data Vault structures that often arise from direct source system mappings.

自動化されたデータ・リネージとモデルの同期化

• Visualize the flow of data from source to satellite, making transformations easy to track and audit.
• Compare & merge tools allow for seamless updates between the logical and physical models, enabling the automatic generation of alter scripts for deployment.

With ER/Studio 20.6, Data Vault automation is now built-in, enabling teams to design and maintain scalable, governance-ready data architectures with minimal manual effort. Check out the video for a walkthrough.

Expanded Data Platform Support in ER/Studio 20.6

Beyond Data Vault automation, ER/Studio 20.6 enhances support for modern data platforms, allowing organizations to design, document, and manage the latest database technologies more effectively.

Key Database & Platform Enhancements:

オラクル23aiサポート – Ensures compatibility with the latest オラクル database version.
PostgreSQL 16 サポート – Expands PostgreSQL capabilities, including support for include columns.
MS SQL Server 2022 サポート – Verified support for reverse engineering, SQL imports, DDL generation, and ALTER script creation.
Lakehouse & Cloud Support – Now supports external tables for:

• Azure SQL DBとシナプス
• Google BigQueryとDatabricks
  • バグ修正と機能強化 – Improvements to object class tools for better denormalization management.

Explore ER/Studio 20.3 Today

Ready to see the new features of ER/Studio 20.6 in action? デモのリクエスト today  and experience the future of automated Data Vault modeling!