General Availability of Mirroring Azure Database for PostgreSQL in Microsoft Fabric Is Here!

Unlock Real-Time Analytics on Operational Data—Now Enterprise-Ready

Few weeks ago at Microsoft Ignite 2025, we announced General Availability (GA) of Mirroring for Azure Database for PostgreSQL flexible server in Microsoft Fabric. This milestone marks a major leap forward in empowering organizations to seamlessly integrate their operational PostgreSQL data into the Microsoft Fabric analytics ecosystem—enabling near real-time analytics, machine learning, and business intelligence without the complexity of traditional ETL pipelines.

Why Mirror Operational Databases in Microsoft Fabric?

Accelerate Analytics Without ETL

Fabric Mirroring eliminates the need for complex, custom ETL pipelines. Data from your operational PostgreSQL databases is continuously replicated into OneLake as Delta tables, making it instantly available for analytics, machine learning, and reporting. This means you can:

• Run advanced analytics and AI on live data without impacting production workloads.
• Empower data scientists to experiment and innovate with up-to-date data.
• Create real-time dashboards and cross-database queries for comprehensive business insights.
• Unify governance and security under OneLake, reducing risk and operational overhead.

Enterprise-Grade Security and Compliance

With support for Entra ID, VNETs, and Private Endpoints, organizations can enforce strict access controls and network isolation. Mirroring is designed to meet the needs of highly regulated industries, ensuring data privacy and compliance at every step.

High Availability and Reliability

The new HA support ensures that mirroring sessions remain resilient to failures, delivering uninterrupted analytics even during server failovers. This is essential for mission-critical applications where downtime is not an option.

Cost Efficiency and Simplicity

Mirroring is offered at no additional cost, dramatically reducing the total cost of ownership for analytics solutions. By removing ETL complexity, organizations can focus on extracting value from their data rather than managing infrastructure.

What’s New in GA?

Building on the momentum of our Public Preview, the GA release introduces several enterprise-grade enhancements:

• Microsoft Entra ID Authentication: Secure, centralized identity management for all mirroring operations. Entra ID authentication streamlines access control and compliance, making it easier for organizations to manage users and roles across their data estate.
• VNET and Private Endpoint Support: Mirroring now works with PostgreSQL Flexible Servers deployed behind Virtual Networks (VNETs) and Private Endpoints, ensuring secure, private connectivity with no public exposure. This is critical for regulated industries and enterprises with strict security requirements.
• High Availability (HA) Support: Mirroring is now compatible with HA-enabled servers, delivering business continuity and seamless failover for mission-critical workloads. For PostgreSQL 17+, replication slot failover ensures uninterrupted mirroring even during planned or unplanned outages.
• Performance and Reliability Enhancements: The replication engine has been optimized for smoother onboarding, improved error handling, and higher throughput—supporting initial snapshot rates up to ~1TB/hour and change data capture (CDC) with minimal latency (as low as 5 seconds under optimal conditions).

For a full list of prerequisites and setup guidance, see the official documentation.

Microsoft Entra ID Authentication

Support for Entra ID database roles includes:

• Setting up initial replication
• Managing ongoing Fabric communications
• Enabling Entra ID authentication on Flexible Server
• Handling Entra ID roles within your databases
• Choosing your role type for Mirroring

VNET and Private Endpoint Support

This feature ensure secure and efficient connectivity for flexible servers within Microsoft Fabric. Connecting to a flexible server without public connectivity enhances security during both initial setup and ongoing operations. Establishing a Virtual Network Gateway on the target VNET facilitates encrypted traffic between networks, while subnet delegation allows specific resources within a subnet to be managed for specialized tasks. The system supports servers restricted by Virtual Network (VNET) and Private Endpoint configurations, enabling robust network isolation and protection from unauthorized access.

High Availability (HA) Support

Fabric Mirroring supports high availability by enabling seamless failover and enhanced fault tolerance for servers configured with HA. This feature requires PostgreSQL version 17 or later, as replication slot failover is only available in these versions. If you are using an earlier PostgreSQL version, you will need to manually reconfigure mirroring after each failover event to maintain replication.

Beyond PostgreSQL: Interoperability Across Azure Databases

Fabric Mirroring is not limited to PostgreSQL. The GA release also includes support for other databases like:

• SQL Server (2016–2025): Native mirroring for on-premises, Azure VMs, and non-Azure clouds, with secure connectivity and analytics-ready Delta tables.
• Snowflake: Mirroring for managed and Apache Iceberg tables, enabling high-performance analytics and open-format interoperability.
• Cosmos DB: Continuous change capture and mirroring for globally distributed NoSQL data, supporting real-time personalization, fraud detection, and IoT analytics.  

This interoperability allows organizations to consolidate data from diverse sources into OneLake, unlocking unified analytics and AI across their entire data estate. By leveraging shortcuts in Microsoft Fabric, customers can reference data stored in different mirrored databases and storage accounts as if it resided in a single location. This means users can build cross-database queries and analytics pipelines without physically moving or duplicating data, avoiding the need for complex ETL processes or data integration solutions. Shortcuts make it possible to seamlessly join, analyze, and visualize data from SQL Server, Snowflake, Cosmos DB, and more within OneLake, streamlining analytics workflows and accelerating time to insight while reducing storage costs and operational overhead.

Getting Started

Ready to experience the power of Mirroring for Azure Database for PostgreSQL Flexible Server in Microsoft Fabric?

• Step-by-step tutorial: https://learn.microsoft.com/azure/postgresql/flexible-server/concepts-fabric-mirroring#enable-fabric-mirroring-in-the-azure-portal
• Role-based access guidance: https://learn.microsoft.com/fabric/mirroring/azure-database-postgresql-tutorial#database-role-for-fabric-mirroring
• Monitor and troubleshoot: https://learn.microsoft.com/azure/postgresql/flexible-server/concepts-fabric-mirroring#troubleshooting
• Public documentation: Fabric Mirroring for Azure Database for PostgreSQL

Future Enhancements

Looking ahead to the next future, our focus will be on delivering a series of post-GA enhancements designed to make Mirroring for Azure Database for PostgreSQL Flexible Server even more robust, versatile, and user-friendly. Key advancements will be in the following areas:

• automatic replication for newly created database tables when operating in auto-mode, ensuring that your mirrored environments remain up to date with minimal manual intervention.
• enhanced support for advanced DDL operations, giving users greater flexibility and control when managing schema changes on mirrored databases.
• expanding compatibility with additional data types—such as JSON, arrays, ranges, and geometry—will open up new scenarios for analytics and data integration, accommodating a wider range of workloads and use cases.
• support for partitioned tables, TOAST tables, and views will allow organizations to mirror more complex database structures, further streamlining operational analytics.
• enable the ability to mirror databases hosted on Read Replicas, which will help organizations optimize their high-availability and scaling strategies without compromising data consistency.

Collectively, these planned features underscore our commitment to continuous improvement and to meeting the evolving needs of our users as they harness the full power of Microsoft Fabric for unified data analytics and AI.

Conclusion

The General Availability of Mirroring for Azure Database for PostgreSQL Flexible Server in Microsoft Fabric represents a significant advancement for organizations seeking to unlock real-time analytics, AI, and BI on their operational data—securely, reliably, and without ETL complexity. With new enterprise features, proven customer success, and broad interoperability, now is the perfect time to bring your operational databases into the Microsoft Fabric analytics era.

Learn more and get started today: Fabric Mirroring for Azure Database for PostgreSQL