Hi All,
I am experiencing issue while connecting mongodb with auth in tableau using mongo dB BI connector and getting following error.
handshake error: unable to authenticate conversation 0: sasl conversation error: unable to authenticate using mechanism "SCRAM-SHA-1"
Use Case:
- We have tableau server hosted on Ubuntu 18.04 64 bit in AWS cloud.
- We have mongo dB hosted in AWS in other VM with authentication enabled
- Have installed mongo dB BI connector in Tableau server and configured according to the need of mongo dB server. BI connector is able to reach to server easily.
Note: due to security reason we cannot share the full screen shot but last row is important which shows that BI connector reached to mongo dB server
4 . When we are trying to connect using Tableau Desktop or Tableau Server directly we are getting following error in BI connector and Tableau.
BI Connector
Note: There is no issue with the user ID and password as we are using the same cred in BI connector which is working fine.
@Ciara Brennan : I am able to solve this issue after lots of struggle, finally got to know that Mongo obdc drive (Latest one 1.4) has some issue in supporting SCRAM-SHA-1 SSL. Tried using different driver (1.1) it started working.
