部署Superset BI(四)连接sql server数据库

发布于:2025-05-10 ⋅ 阅读:(18) ⋅ 点赞:(0)

sqlserver没有出现在Superset的连接可选菜单上,这一点让我奇怪。既然没有那就按着HANA的配置方式,照猫画虎。更奇怪的是安装好还不能出现,难道superset和微软有仇?
--修改配置文件
root@Nocobase:/usr/superset/superset# cd docker
local.txtroot@Nocobase:/usr/superset/superset/docker# echo "pymssql">> requirements-local.txt
root@Nocobase:/usr/superset/superset/docker# cat  requirements-local.txt
pymssql
启动容器后,在数据库连接下拉列表中没有出现sql server

--进入容器安装驱动
其实设置了requirements-local.txt就不需要进入容器安装,但是列表里面不显示只好手工再安装一次试试。

root@Nocobase:/usr/superset/superset/docker# docker exec -it superset_app bash
root@2492c7c8cca8:/app# pip install pymssql
Collecting pymssql
  Downloading pymssql-2.3.1-cp310-cp310-manylinux_2_28_x86_64.whl.metadata (7.1 kB)
Downloading pymssql-2.3.1-cp310-cp310-manylinux_2_28_x86_64.whl (4.6 MB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 4.6/4.6 MB 16.1 MB/s eta 0:00:00
Installing collected packages: pymssql
Successfully installed pymssql-2.3.1
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager, possibly rendering your system unusable.It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv. Use the --root-user-action option if you know what you are doing and want to suppress this warning.
root@2492c7c8cca8:/app# quit
bash: quit: command not found
root@2492c7c8cca8:/app# exit
exit
root@Nocobase:/usr/superset/superset/docker# docker exec -it superset_app bash

--配置连接

连接数据库类型中还是没有出现sql server,但选择其它数据库中的其它,按连接字串的格式设置配置连接字符串。mssql+pymssql://name:password@db_host:1433/db_name

连接成功。虽然连接成功,但感觉自己弄得微软太掉面子,在superset里面连个名分都没有捞到。


网站公告

今日签到

点亮在社区的每一天
去签到