We're excited to announce the General Availability of the SQL Server connector from Lakeflow Connect. This fully managed connector is designed for reliable, production-grade ingestion with built-in Change Data Capture (CDC) and Change Tracking (CT). By removing the need for custom pipelines or complex tools, it simplifies ingestion, ensures data freshness, and reduces operational overhead to accelerate insights. Also, for BI-first migrations, built-in CDC support keeps analytics workloads continuously up to date, making it easier to bring SQL Server data into the lakehouse with the performance, security, and scalability that enterprises require.

Microsoft SQL Server powers some of the world's most business-critical applications, yet its data is often locked in a system purpose-built for transactions, not analytics. As organizations move these workloads to the lakehouse, reliable ingestion is critical. Traditional ingestion pipelines are complex to build, costly to maintain, and can overload production systems, while multiple instances and hybrid on-premises and cloud environments lead to patchwork solutions that are hard to govern. The SQL Server connector from Lakeflow Connect solves these challenges with a fully managed, streamlined and governed solution that unlocks SQL Server data for advanced analytics and AI.

Built-in data ingestion support for many SQL Server database environments

The SQL Server connector makes it easy to ingest data from various SQL Server environments into the lakehouse, where it can be used for analytics and business intelligence across the organization, including:

• Azure SQL
• Azure SQL Managed Instance
• AWS RDS for SQL Server
• SQL Server on GCP
• On-premises SQL Server deployments

The connector is easy to set up with a point-and-click UI or simple API and integrates seamlessly with your existing workflows and deep platform integration with Databricks. For example, you can align with your CI/CD practices via Databricks Asset Bundles or the Databricks Terraform provider.

It's also built for efficiency. The connector supports both CDC and CT for incremental ingestion instead of needing to run full refreshes. By capturing only new or updated records, customers can keep their lakehouse continuously up-to-date to deliver valuable business insights, accelerate decision-making, and reduce costs.

For organizations that need to manage data changes over time-like customer details, product attributes, or organizational structures-Lakeflow Connect also provides out-of-the-box support for tracking historical changes with Slowly Changing Dimensions (SCD) Type 2, reducing the complexity with a critical feature to track historical changes alongside current values.

Demo: Learn how to use Lakeflow Connect for SQL Server to analyze customer purchase behavior.

Enterprise customers drive impact with Lakeflow Connect

Since we launched a year ago, more than 2,000 customers have used Lakeflow Connect to ingest their most business-critical data to drive positive results.

For example, Cirrus Aircraft Limited, founded in 1984, designs, develops, manufactures, and sells premium aircraft around the world. An early adopter of the SQL Server connector, they needed to move data off multiple hybrid SQL Server environments into their lakehouse to deliver more valuable data back to their teams. With its simple setup and efficient incremental ingestion, the connector enabled Cirrus to shift from pipeline integration and maintenance to strategic initiatives that moved the needle for their business.

Another Databricks customer, the Australian Red Cross Lifeblood is funded by the Australian governments to provide life-giving blood, plasma, transplantation and biological products, including breast milk and FMT to deliver world-leading health outcomes with 10.5 million eligible donors. They use Lakeflow and the SQL Server connector to help build reliable, maintainable pipelines quickly and consistently. Learn more by watching their on-demand presentation, part of, "From Burnout to Breakthrough: A New Approach to Data Engineering," or watch their 2025 Data + AI Summit session, "From Datavault to Delta Lake: Streamlining Data Sync with Lakeflow Connect."

Ubisoft is a creator of worlds, committed to enriching players' lives with original and memorable entertainment experiences. Ubisoft's global teams create and develop a deep and diverse portfolio of games, featuring brands such as Assassin's Creed®, Just Dance®, and a lot more. For the 2024-25 fiscal year, Ubisoft generated net bookings of €1.85 billion.