SQL2Fabric Mirroring is a new fully managed service offered by Striim to mirror on premise SQL Databases.
It’s a collaborative service between Striim and Microsoft based on Fabric Open Mirroring that enables real-time data replication from on-premise SQL Server databases to Azure Fabric OneLake. This fully managed service leverages Striim Cloud’s integration with the Microsoft Fabric stack for seamless data mirroring to Fabric Data Warehouse and Lake House.
Microsoft Azure Fabric is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It offers a comprehensive suite of services including Data Engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, and Databases. Operating on a Software as a Service (SaaS) model, Fabric brings simplicity and integration to your solutions. Striim Cloud is fully integrated with the Fabric stack and runs natively in Azure next to Fabric services making it a simple, secure, fast solution to replicate data to enable Data engineering, Data science, Real-time Intelligence and Data insights through PowerBI etc.
Key Benefits
- Simplified Setup: Quick and easy deployment with a user-friendly interface.
- Real-Time Data Replication: Seamlessly transfer data from SQL Server to Fabric for immediate insights.
- Automated Data Pipelines: Benefit from automated initial load and real-time CDC pipelines, ensuring efficient data transfer.
- Automated Schema Management: Simplify data migration with automatic schema mapping and evolution.
- Robust Security: Protect your data with advanced security measures and compliance standards.
- High Performance and Scalability: Handle large volumes of data with ease and ensure optimal performance.
Getting Started
Striim’s SQL2Fabric-Mirroring is a purpose-built solution for replicating on-premises SQL Server data to Microsoft Fabric. With a few simple steps, you can automate the entire process, from initial data load to continuous replication in a few minutes.
Step 1: Signup to SQL2Fabric-Mirroring service 30-day trial
Signup for SQL2 Fabric-Mirroring service through Azure Marketplace or Striim’s product page to avail 30 days free trial. Lets you create an Striim Cloud account and login
Step 2: Create a Striim Cloud service
To get started, create a Striim Cloud service in a region close to your SQL Server. Establish a secure connection (e.g., VPN or Azure Private Link) between your on-premises environment and Striim Cloud. Then, use the intuitive interface to configure your data pipeline, specifying source and target details. Striim automates the rest.
Step 3: Create a Data pipeline
Striim’s user-friendly interface allows you to easily connect your SQL Server source and Microsoft Fabric target. The platform automatically creates an optimized data pipeline with smart defaults for SQL Server and handling initial load, continuous replication, and schema mapping using SQL server reader and Fabric Mirroring writer that is integrated with Fabric Mirroring service to offer end to end experience. This streamlined approach eliminates the need for managing multiple solutions, complex configurations and enables you to quickly start leveraging your data for real-time analytics and insights.
Step 4: Monitor high throughput data streaming
Simply monitor real-time and continuous streaming of data from SQL Server to Fabric on Striim’s intuitive monitor screen or directly on Fabric Mirroring monitor. While Striim does the heavy lifting of ingesting Initial load (Historical data) and seamlessly switching to CDC mode (Change data capture) with low latency and high throughput data performance. Striim enables users to just focus on building business decisions by consuming real-time PowerBI dashboard insights
Easily access and create Power BI Reports on the data mirrored by Striim in Fabric.
