- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2022 05:59 AM
Hello,
Is it possible to insert data from Databricks into an on-premise SQL Server ?
Thanks.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2022 08:17 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2022 08:17 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2022 08:19 AM
Hello,
Yes we find out how to do it by installing a JDBC connector.
It works fine.
Thanks.