Question

Which Managed MongoDB BI Tool is possible to connect, and how do I connect?

Hi guys, I was really happy to see that the Managed MongoDB is right not available at DigitalOcean. One important point for us is to have BI quite easy set up. So we thought the ManagedDB might be a good option.

I’ve tested several tools:

  • Qlik Sense (Need to get .pem)
  • Tableau (Only enterprise with MongoDB BI Connector)
  • PowerBI (Only enterprise with MongoDB BI Connector)
  • Knowi (Login without certificate, or only with atlas)

Do I have a wrong understanding of that topic? Or do you know I nice tool, just to connect, build up some alarms and thats it?

BR Christian

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev • December 18, 2021

Hi there,

I have personally believed Metabase should be working as expected as they have native support for MongoDB.

You can start Metabase with a single Docker command:

docker run -d -p 3000:3000 --name metabase metabase/metabase

Or if you would like to persist the data you could also specify a volume:

docker run -d -p 3000:3000 \
-v ~/metabase-data:/metabase-data \
-e "MB_DB_FILE=/metabase-data/metabase.db" \
--name metabase metabase/metabase

While setting up Metabase, you need to make sure that you enable Use DNS SRV when connecting.

Also, make sure to click on the Server SSL certificate chain and paste the content of the CA certificate in there.

Hope that this helps. Best, Bobby