Mirroring Azure Database for PostgreSQL Flexible Server in Microsoft Fabric – Private Preview

today European Microsoft Fabric Community Conference A private preview has been released. mirroring Azure Database for PostgreSQL flexible server database on Microsoft Fabric. This groundbreaking capability allows you to seamlessly integrate operational data into Microsoft Fabric, effectively eliminating data silos and improving accessibility.

• Easy integration: Integrate your data into Microsoft Fabric with just a few clicks for advanced analytics and AI-driven insights.
• Real-time replication: PostgreSQL data is replicated incrementally in near real-time to Fabric OneLake in Parquet format so any analytics engine can access it without data movement.

Key features of Microsoft Fabric’s mirrored database include:

Start mirroring

• Go to Fabric->Data Warehouse Workloads and click Mirrored Azure Database for PostgreSQL (Preview).

• Create or select a connection to connect to Azure Database for PostgreSQL flexible servers and databases.

• When creating a new connection, specify the server and database names and user credentials with REPLICATION or administrator privileges.

• Select one, most, or all tables in the mirrored database that you want to replicate. Clicking on a table displays a preview of the data it contains.

• Once you click Connect and provide the mirrored database name to Fabric, an artifact will be created and you can check the replication progress by clicking the “Monitor Replication” button.

• From the mirrored database artifacts, you can switch to the “SQL Analysis Endpoints” panel. From here, you can start running SQL queries against data replicated continuously from Azure Database for PostgreSQL flexible server to Fabric OneLake for analysis.

• Even if you are not a SQL expert, you can also use the “Visual Query” option to build complex queries graphically.

From here, you can take advantage of all the great features of Microsoft Fabric, including building PowerBI reports directly from mirrored data or cross-joining PostgreSQL data with other data in OneLake via Lakehouse and Notebooks for data engineering and data science purposes.

When to use mirroring

If you’re an Azure Database for PostgreSQL flexible server customer and looking for analytics on your operational data but don’t want to set up a complex ETL workflow, mirroring can help you:

• Easily import data from a variety of sources into Microsoft Fabric OneLake.
• Open source Delta Parquet format and Delta features such as time travel
• Delta table optimization using v-order for very fast reads
• One-click integration with Power BI using Direct Lake and Co-Pilot
• Combine data from diverse sources to gain rich business insights.
• Richer app integrations with access to queries and views

If you are an existing Fabric user, you can benefit from consolidating your data assets by storing your Azure Database for PostgreSQL data and the rest of your organization’s data in OneLake.

How to sign up for private preview

If you would like to try the product in preview, please fill out this field. form.

Azure Database for PostgreSQL Flexible Server Information

Azure Database for PostgreSQL Flexible Server is a fully managed database service designed for app development and deployment. Deliver customizable performance with scalable compute and storage, automated backups, and high availability. Whether you need to develop new applications or migrate existing ones, this service provides the flexibility and security required for enterprise-grade applications. Try Azure Database for PostgreSQL flexible server for free here.. To stay updated on Azure Database for PostgreSQL flexible server: twitter and linkedin.