topic Re: Insert data into an on-premise SQL Server in Data Engineering

Insert data into an on-premise SQL Server

wyzer — Thu, 17 Feb 2022 13:59:29 GMT

Hello,

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

Thanks.

Re: Insert data into an on-premise SQL Server

User16764241763 — Fri, 18 Mar 2022 15:17:33 GMT

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-prem-network

Re: Insert data into an on-premise SQL Server

wyzer — Fri, 18 Mar 2022 15:19:18 GMT

Hello,

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

It works fine.

Thanks.