I can’t connect to Tableau Prep Builder using MongoDB BI Connector from Atlas. I have the BI Connector and an analytical node enabled.
When I try to connect to Tableau Prep Builder I obtain the following error message:
“Can’t connect to
Detailed Error Message:
An Error ocurred while communicating with MongoDB BI Connector [MySQL][ODBC 8.0 (w) Driver][mysqld-5.7.12 mongosqld v2.14.3] This command is not supported in the prepared statement protocol yet Unable to connect to the MongoDB BI Connector server . Check that the server is running and that you have access privileges to the requested database.”
The user I’m using is an admin inside Atlas so I should have the privileges to connect to the DB. I configured the ODBC correctly because my databases are showing and when I press “Test” I obtain as a test result “Connection Succesful”.
I also tried to connect to Tableau Online but I obtain the same message. Because of this, I don’t think that the problem is in my version of MySQL driver or my Visual C++ Redistributable version.
I hope you can help me.