search

timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
416 stars 17 forks source link

Errors in adding a MongoDB connection #58

Open jrca025 opened 3 weeks ago

jrca025 commented 3 weeks ago

I have a MongoDB on my local machine without authentication. qstudio is requiring it image

ryanhamilton commented 3 weeks ago

Hi @jrca025 I tried quite a few different combinations but none worked. Even once connected i was getting: Command failed with error 59 sqlGetResultSchema

Looking at the driver page https://github.com/mongodb/mongo-jdbc-driver it says:

The MongoDB Atlas SQL JDBC Driver provides SQL connectivity to [MongoDB Atlas](https://www.mongodb.com/atlas) for client applications developed in Java.
See the [Atlas SQL Documentation](https://www.mongodb.com/docs/datalake/admin/query-with-sql/) for more information.

MongoDB Atlas SQL JDBC Driver - I guess they only want to provide JDBC access to Atlas users :(

I had a look at alternatives but they don't seem great either. Unsure what to do. Is there another database tool you have seen solve this well?

ericschmar commented 3 weeks ago

I'll tag on here to say that a similar issue persists with using the Mongo Driver for Azure Cosmos DB. Using either a connection string (in the jdbc format) or manually entering everything times out for both options.