From SQL Server to Microsoft Fabric: Automating Your Migration Journey

Description

Migrating from SQL Server or Synapse to Microsoft Fabric can be complex. In this session, discover how automation simplifies schema conversion, dependency mapping, orchestration, and documentation to reduce manual effort by up to 80%. Learn step-by-step best practices for migrating to Fabric and integrating OneLake, Data Factory, and Purview for a governed, automated future.

Key Takeaways

My Notes

Action Items

Slides

2/16/2026
From Pipeline to Prompt:
Powering Fabric AI
for Conversational
AI/Analytics
Let’s Connect!
Kelly Kohlleffel
Sr Director
Global Partner Sales Eng
Fivetran
David Hrncir
Lead Partner Sales Eng
(Tech Partners)
Fivetran
CHECK OUT: fivetran.com/podcast
Your Perspectives from FCSC2026
Here’s what we are covering today
From Pipeline to Prompt:
Powering Fabric AI for
Conversational AI/Analytics
• Perspectives
• Fivetran Today
• Solution Context: Fivetran, Fabric & AI
• Architecture: Fivetran, Fabric & AI
• Demo Time
• Thoughts and Perspectives: The Build
• Q&A
• Wrap Up and CTA
Current Fivetran Today
Trusted by customers
Trusted by partners
7,000+ companies worldwide including:
Recognized by leading data and cloud platforms:
Databricks
Data Integration
Google Cloud
Data Ingestion
Microsoft Marketplace Americas
dbt Labs
Technology
Snowflake Data
Cloud Product EMEA
AWS Partner
Data & Analytics
Competency 2024
Looking at Fivetran by the numbers
500+ GB/hr
9.1+ Petabytes
22.2M+
Historical sync throughput speeds
Amount of data synced per month
Schema changes handled per month
37.7M+
156.5M+
10.1T+
Transformation models run per month
Pipeline synced per month
Rows synced per month
TRUSTED BY
OVER 4000
CUSTOMERS
Solution Profile
Fivetran makes all data AI-ready
for Microsoft Fabric
COMPUTE
DATA SOURCES
COPILOT
Microsoft Fabric
Warehouse
Microsoft Fabric
Lakehouse
Microsoft Fabric
Data Engineering
Real-Time
Intelligence
Databricks
Snowflake
PIPELINES
COPILOT in FABRIC
Fivetran moves all of your
data from any source system
Fivetran transforms the data
into enriched and governed
tables
Fivetran activates the data
into any of your applications
or workflows
Extract & Load
Transformation
Activation
Fivetran
● 750 data sources + CSDK
● High throughput & low
latency
● CDC
● All data types
Fivetran / dbt Labs
● Quickstart data models
● dbt packages &
orchestration
● Fabric trusted adapters
● AI column builder
Fivetran
● Activations and alerts
● rETL workflows
● Audience builder
● Drive actions for 200+ apps
Fivetran Polaris & OneLake
Agents
Teams
FIVETRAN DESTINATION: MANAGED DATA LAKE SERVICE
Catalog & governance
Industry Solutions
Storage
Fivetran MDLS
MCP
Demo time
Demo time
Building it out - thoughts and perspectives
Q&A
• Booth #501: Come talk data and AI with us!
• Solutions: https://www.fivetran.com/case-studies
Wrapping Up
• Test Drive: https://fivetran.com/signup
• Technical Webinar: April 1 @ 9 AM PT - Building
a scalable, governed data foundation with Fivetran,
ADLS, Microsoft Fabric and Copilot
From Pipeline to Prompt:
Powering Fabric AI for
Conversational AI/Analytics
Thank you!