Dec 2024
2 / 3
Dec 2024
7d ago
Sai_Ram_Bavireddy
Dec 2024

I am trying to connect Looker Studio (formerly Google Data Studio) to my MongoDB Atlas cluster. I have enabled the Atlas SQL Interface because I want to avoid using the BI Connector, as it is being deprecated. However, I am encountering difficulties in setting up the connection.

My Current Setup:
Atlas SQL Interface Enabled: Yes
BI Connector Enabled: No (intentionally not enabled).

Atlas SQL Connection Options Provided:

  • Power BI Connector
  • Tableau Connector
  • JDBC Driver
  • ODBC Driver
    I attempted to use all the Driver options but i am unable to connect

Steps I’ve Tried:

  1. Enabled the Atlas SQL Interface in my MongoDB Atlas cluster.
  2. Used the JDBC connection string provided by the Atlas SQL configuration.
  3. Configured SSL using the appropriate certificates from Let’s Encrypt
  4. All allow IP addresses in MongoDB Atlas
  5. Verified that my database user has readwrite permissions

Despite trying the above steps, I cannot establish a connection between Looker Studio and MongoDB Atlas via the Atlas SQL Interface. Looker Studio throws an error like this:
Sorry, we encountered an error and were unable to complete your request.
Alexi_AntoninoMongoDB Employee
Dec 2024

Hello @Sai_Ram_Bavireddy Welcome to the MongoDB community! I am the product manager for both the BI Connector and the Atlas SQL Interface. I am in communication with the Looker PM and Engineering team as they are currently building out an integration for Google Looker based on our JDBC driver. We expect this to be ready in Q1 of the new year. Until then, your best option would be to use the BI Connector.

We will send out notifications to Looker users when this new integration this complete and ready for use.

4 months later

Want to read more? Browse other topics in Drivers or view latest topics.