cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

On Prem MS sql to Azure Databricks

KKo
Contributor III

2 weeks ago

Hi all
I need to ingest data from on prem MS sql tables using Databricks to Azure Cloud. For the ingest, previously I used notebooks, jdbc connectors, read sql tables and write in unity catalog tables. Now, I want to experiment Databricks connectors for the same purpose but not sure if this is robust and easy enough to use. If you have used this approach, could you help me understand the advantages/disadvantages of it please. Thanks in advance!

0 Kudos
1 REPLY 1

AbhaySingh
Databricks Employee
Databricks Employee

2 weeks ago

This is feature is good to go... I can't think of any disadvantages. Here is a guide. 

https://landang.ca/2025/01/31/simple-data-ingestion-from-sql-server-to-databricks-using-lakeflow-con...

 

0 Kudos

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now
Announcements