Please try launching MongoDB with --auth then it will also need to be used by mongosqld in order to pass through the credentials. Using the --auth argument when launching mongosqld should resolve the issue.
Hope this helps!
1 of 1 people found this helpful
Just to add onto that, when running mongosqld in command line, use:
mongosqld --schema schema.drdl --auth --mongo-username <USERNAME> --mongo-password <PASSWORD> --mongo-authenticationSource <collection_name> --mongo-uri <mongo host:port>
tableau username should still be: user?source=collection_name
without the --mongo-authenticationSource, the table names would appear but trying to show the data will throw that error