问题描述
Azure Databricks是否支持连接到本地SQL Server?
Does Azure Databricks support connecting to on-premises SQL Server ?
推荐答案
您可以按照scsimon建议使用JDBC驱动程序.
You can use the JDBC drivers as scsimon suggested.
但是，除非您的数据库可以通过Internet访问，否则将无法连接.
However, unless your database is accessible to the internet it will be unable to connect.
要解决此问题，您需要vnet将数据块工作区附加到具有VPN或ExpressRoute连接到本地站点(并已正确路由)的vnet.当前，这是一种预览功能，您需要与Microsoft联系以启用它.
To resolve this you need to vnet attach your databricks workspace to a vnet that has VPN or ExpressRoute connectivity to your onprem site (and correct routing in place). This is currently a preview feature that you will need to contact Microsoft to get enabled.
此处有完整详细信息: https://docs.azuredatabricks.net/administration-guide/cloud-configurations/azure/vnet-inject.html
Full details here: https://docs.azuredatabricks.net/administration-guide/cloud-configurations/azure/vnet-inject.html
这篇关于通过Azure Databricks连接到本地SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！