Schema Shift Happens: September Data Edge Newsletter

⚡ Schema shift happens... and when it does, automation keeps you ahead.

This month, join our live webinar on accelerating Azure SQL with WhereScape 3D and RED, and catch our on-demand session on validating architecture before you deploy. 📺 Explore our new white paper on simplifying Microsoft Fabric, see what’s new in RED 10.5, and don’t miss webinars from our IDERA Software / Idera, Inc. family brands ER/Studio and DB PowerStudio. Plus, we’ll be at key conferences in Dallas, Vienna, Seattle, and Hannover—come connect with us. 🌍

Automation isn’t just faster, it’s safer, smarter, and built to scale. 🎯

Live Webinar | Accelerating Data Warehousing on Azure SQL with WhereScape 3D and RED

📅 Tuesday, September 30, 2025 | 10:00 AM CDT | 4:00 PM BST

Azure SQL projects don’t have to be slow or complex. Join this live session to see how WhereScape 3D and RED automate the entire lifecycle—from discovery to deployment—cutting manual coding by up to 95% and delivering analytics up to 80% faster.

What You’ll Learn:

• Advanced Data Discovery & Profiling – Analyze sources, uncover insights, and design models aligned with business and technical needs.
• Rapid Prototyping & Agile Design – Iterate on warehouse designs with built-in automation for faster validation and fewer delays.
• Automated Code Generation & Deployment – Use wizards, templates, and best practices to create SQL code, orchestrate ETL, and deploy seamlessly to Azure SQL or Synapse.
• Enhanced Integration & Productivity – Boost developer efficiency with no-code automation, real-time handling, and governance-ready Azure integrations.

🎙 Featuring Duan Uys , Solutions Architect at WhereScape

Register Now

On Demand | Stop Burning Budget: Validate Your Data Architecture Before You Deploy

☁️ Cloud costs spiraling? This session shows you how to take control before it’s too late.

Without validating your architecture first, cloud adoption can lead to expensive rework, wasted compute, and project delays. In this recorded webinar with speaker Patrick O'Halloran , see how WhereScape helps you design, test, and validate complete workflows before they hit production.

What You’ll Learn:

• Model Smarter, Faster – Build fully governed prototypes with automation instead of hand-coding.
• Validate Before You Deploy – Test flows against real business rules before consuming compute.
• Cut Cloud Surprises – Prevent overruns with informed architecture decisions upfront.

▶️ Watch Now

New White Paper | From Source to Report: Simplifying Microsoft Fabric with WhereScape

Microsoft Fabric consolidates analytics into one platform, but operationalizing it requires automation. This paper outlines how WhereScape enables metadata-driven delivery across the Fabric ecosystem.

Inside the white paper, you'll find:

• 95% Reduction in Manual Coding – Automate schema generation, business rules, and transformations.
• OneLake + Fabric Warehouse Deployment – Eliminate brittle hand-coded DDL with repeatable automation.
• ADF Pipelines at Scale – Auto-generate ingestion and transformation flows with dependency handling.
• Medallion & Data Vault 2.0 Templates – Consistent, best-practice modeling across Bronze/Silver/Gold and vault layers.
• Migration Blueprints – Proven patterns for moving from legacy systems into Fabric.
• Governance Embedded – Automated documentation, lineage, and audit columns generated as you build.

For architects and engineers adopting Fabric, this resource provides repeatable methods to reduce rework, accelerate deployment, and enforce governance from day one.

📖 Download the White Paper

Product Release | New in RED 10.5: Streamlined Install, Smarter Upgrades & Enterprise Scale

The latest WhereScape RED release reduces friction in installs, upgrades, and operations while expanding enterprise capacity.

Key Updates:

• Faster Installs – Wizards auto-create metadata DBs and DSNs.
• Automated Upgrades – Scheduler upgrade workflow replaces manual steps.
• Operational Resilience – New maintenance wizards, improved ODBC handling, and stuck-job controls.
• Enterprise Scale – Support for 1000+ projects/groups and larger SQL character limits.
• Migration Support – Backward compatibility for RED 9 scripts and new automation hooks.

RED 10.5 keeps teams current, stable, and ready to scale.

📖 Read the Full Release Here

From the Idera, Inc. Family • IDERA ER/Studio Webinar – The Dark Side of Embedded JSON

📅 September 11, 2025 | 10:00 AM CT

Many modern databases allow JSON to be stored directly in tables—convenient, but risky. Hidden structures and shadow data can bypass governance and create blind spots.

In this live IDERA ER/Studio webinar, Tim Rone , Lead Solutions Architect, will demonstrate how version 20.9 helps uncover, document, and govern hybrid relational + JSON environments.

👉 Register Now

From the Idera, Inc. Family • @DB PowerStudio Webinar – Cross-Platform Tuning, Simplified

📅 September 18, 2025 | 10:00 AM CT

Managing performance across Oracle, SQL Server, DB2, and more doesn’t have to be complex. In this live session, see how DBArtisan and DB Optimizer let you monitor, diagnose, and tune multiple platforms from one interface—streamlining workflows and improving overall database health.

👉 Register Now

Upcoming Conferences | Where Can You Find WhereScape?

PASS Data Community Summit On Tour – Dallas, TX

📅 Date: September 15–16, 2025 📍 Location: Westin Irving Convention Center, Dallas

Attending PASS Summit On Tour in Dallas? Let’s talk automation. WhereScape will be onsite to show how modern data teams streamline SQL Server, Fabric, and hybrid data environments—without manual effort.

Conference Session: The Need for Speed: Agile Prototyping in Microsoft Fabric 📅 September 16 | 1:30 PM - 2:30 PM | Room: Masa 🎤 Speaker: Patrick O'Halloran , WhereScape

🔗 Register Here

European Microsoft Fabric Community Conference

📅 Date: September 15-18, 2025📍 Location: Vienna, Austria

Join WhereScape at #FabConEurope – Booth #2! Heading to Vienna for the European Microsoft Fabric Community Conference? Stop by to see how WhereScape automates ingestion, modeling, and governance across Microsoft Fabric. Whether you're migrating to OneLake or building agile Data Vaults, we’ll show you how to do it faster—with zero hand-coding.

Featured Session: Accelerating Microsoft Fabric Success: From Bronze to Gold with Model-Driven Automation📅 Thursday, September 18 | 🕙 10:30–11:30 🎤 Speakers: Endika Pascual of WhereScape & Jochen Abild of IT-Logix AG

🔗 Register Here!

EDUCAUSE Annual Conference 2025

📅 Date: October 27-30, 2025📍 Location: Nashville, TN

Join WhereScape at EDUCAUSE 2025! Visit us at Booth 116 to explore how our data automation solutions can support your institution’s digital transformation and enhance student success. Learn how automation can simplify data management and drive innovation in higher education.

Featured Session: Sandbox to Cyber Lab: Build an Academic Infrastructure for Safe Experiential Cyber Learning 📅 Wednesday, October 29, 2025 | 3:15 PM–4:00 PM CT Session Type: Poster Session Delivery Format: Poster 🎤Speakers: Bren Triplett , Colorado Christian University and Patrick O'Halloran , WhereScape

🔗 Register Here!

PASS Data Community Summit 2025 – Seattle, WA

📅 Date: November 17–21, 2025 📍 Location: Seattle Convention Center

Join WhereScape at PASS Data Community Summit 2025, the leading event for database professionals, data engineers, and analytics experts. This week-long conference is packed with technical sessions, hands-on learning, and networking with industry leaders.

Whether you’re modernizing your architecture, adopting new platforms, or implementing Data Vault 2.0, we’ll show you how to deliver results faster—with confidence.

Featured Session: The Modern Data Warehouse: Foundation for Scalable, Intelligent Analytics 📅 November 21 | 11:30 AM–12:30 PM | Room 443–444 🎤 Speaker: Patrick O’Halloran, Principal Solutions Architect, WhereScape

🔗 Register Here!

Data Dreamland 2025

📅 Date: November 26, 2025📍 Location: Hannover, Germany

Join WhereScape at Data Dreamland 2025! Dive deep into data-driven business with a focus on Data Vault 2.0, AI, business intelligence, and more. Discover how WhereScape’s data automation solutions can help you unlock the full potential of your data and streamline your analytics processes.

🔗 Get your early bird ticket now!

Cut the Code. Speed Up Data Projects with WhereScape

In 2025, WhereScape celebrates 25 years of helping organizations automate and accelerate their data infrastructure—from design to deployment.

Trusted by thousands of teams worldwide, WhereScape reduces manual coding by up to 95% and enables faster delivery of data warehouses, vaults, lakes, and marts. Our metadata-driven automation ensures consistency, compliance, and scalability across platforms like Microsoft Fabric, Snowflake, Azure, and Databricks .

As AI initiatives demand accurate, trusted data, WhereScape helps organizations build high-quality, governed pipelines—so you can feed your AI systems with confidence and drive smarter insights.

Book a demo and see what 25 years of data automation expertise can do for your team.

#DataWarehouse #DataLakehouse #DataPipelines #Data #DataFabric #DataPlatform #DWA #DataVault2 #DataLifecycle #DataArchitecture #DataModeling #ETL #ELT #BigData #DataAutomation #DataMesh #DataFabric #MicrosoftFabric #MicrosoftAPIs #Databricks #AgnosticPlatform #DataLake #DataVault #Databricks