且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

通过Azure Databricks连接到本地SQL Server

更新时间:2022-11-05 20:18:43

您可以按照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