cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Insert data into an on-premise SQL Server

wyzer
Contributor II

Hello,

Is it possible to insert data from Databricks into an on-premise SQL Server ?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

User16764241763
Honored Contributor

Hello @Salah K.​ 

Thank you for posting on Databricks Community forum.

It is possible to connect to On-premise SQL Servers

To resolve this you need to peer your databricks workspace VNET to a VNET that has VPN or ExpressRoute connectivity to your OnPrem site (and correct routing in place).

Please refer to this documentation

https://docs.microsoft.com/en-us/azure/databricks/administration-guide/cloud-configurations/azure/on...

image

View solution in original post

2 REPLIES 2

User16764241763
Honored Contributor

Hello @Salah K.​ 

Thank you for posting on Databricks Community forum.

It is possible to connect to On-premise SQL Servers

To resolve this you need to peer your databricks workspace VNET to a VNET that has VPN or ExpressRoute connectivity to your OnPrem site (and correct routing in place).

Please refer to this documentation

https://docs.microsoft.com/en-us/azure/databricks/administration-guide/cloud-configurations/azure/on...

image

wyzer
Contributor II

Hello,

Yes we find out how to do it by installing a JDBC connector.

It works fine.

Thanks.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.