You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "ChristopheBear (via GitHub)" <gi...@apache.org> on 2023/06/12 05:48:05 UTC
[GitHub] [superset] ChristopheBear opened a new issue, #24352: (Superset 2.1.0)Database connection driver issues: Unable to connect to mongobi database
ChristopheBear opened a new issue, #24352:
URL: https://github.com/apache/superset/issues/24352
Our team was able to connect to the mongobi database without any problem in the old version, however, when we upgraded to superset version 2.1.0, we had a problem that we could not connect to the mongobi database(Not mongodb database).
#### How to reproduce the bug
1. Go to settings -> databases -> edit(choose an existed mongobi database which was connected successfully before in the old version of superset)
2. Click on Test Connection
3. See error
### Expected results
Mongobi database can be successfully connected.
### Actual results
After starting the local debugger, the front-end tests the mongobi database connection and finds the error message.
#### Screenshots
### Environment
(please complete the following information):
- browser type and version:
- superset version: `superset 2.1.0`
- python version: `python --3.9.12`
- SQLAlchemy version: `SQLAlchemy 1.4.24 `
- sqlalchemy-mongobi version:`sqlalchemy-mongobi 0.2.1`
- PyMySQL version:`PyMySQL 1.0.3`
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Additional Information about mongobi(MongoDB Connector for Business Intelligence):
Traditional business intelligence tools work with flat, tabular data. These tools aren't sophisticated enough to understand three-dimensional data stored in MongoDB databases.
The MongoDB Connector for Business Intelligence (BI) allows you to create queries with SQL to visualize, graph, and report on your three-dimensional MongoDB data using relational business intelligence tools such as Tableau and Power BI.
For more information, please see https://www.mongodb.com/docs/bi-connector/master/what-is-the-bi-connector/
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] (Superset 2.1.0)Database connection driver issues: Unable to connect to mongobi database [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24352:
URL: https://github.com/apache/superset/issues/24352#issuecomment-1971918079
I just realized that driver hasn't been updated in over 5 years. I'm not sure if it's rock-solid-stable (unlikely) or unsupported (more likely). I'll close this Issue since the thread is stale anyway, but we can re-open it if there's more to work on here. I'd suggest we move toward natively SQL-speaking Mongo tools like Atlas (linked above) or an intermediary like Presto/Trino, unless there's a better-supported SQLAlchemy driver for mongo.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] (Superset 2.1.0)Database connection driver issues: Unable to connect to mongobi database [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #24352: (Superset 2.1.0)Database connection driver issues: Unable to connect to mongobi database
URL: https://github.com/apache/superset/issues/24352
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] (Superset 2.1.0)Database connection driver issues: Unable to connect to mongobi database [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #24352:
URL: https://github.com/apache/superset/issues/24352#issuecomment-1971903310
Looking at the [docs](https://pypi.org/project/sqlalchemy-mongobi/) you'd want to specify a dbapi, like `mongobi+mysqldb://user?source=auth_db:password@url:port/database` or `mongobi+pymysql://user?source=auth_db:password@url:port/database` - have you tried that?
Also, is this still the case in Superset 3.x? We're closing most 2.x or earlier issues since that version is no longer suported.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org