This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

MySQL connector with SSL

Posted on 05-17-2024 02:34 AM
AleCalmanovici
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi everyone and thanks in advance for you support!

I am trying to connect Looker Studio to MongoDB using the BI connector from MongoDB.

I successfully connected my local machine to MongoDB using MySql via DBeaver. What I need for that is the host: xxxxx-biconnector.tx6ct.mongodb.net, the port: 27015, username and password. The connection requires SSL, and I use the following config:

Screen Shot 2024-05-17 at 11.17.43 AM.png

Require SSL is enabled, rest is not.

 

Now we come to my issue with Looker Studio. I try to connect using the MySQL connector. I already whitelisted the following IPs on MongoDB: 142.251.74.0/23, as per documentation. SSL needs to be enabled, and in that case I am forced to upload a server certificate, which on DBeaver is not needed. 

Is there a way to require SSL without uploading the server certificate (which I don't have)?

 

1 0 272
Topic Labels
0 REPLIES 0