Greetings Community,
I want to connect MongoDB Atlas from Qlik Cloud and I was doing this using the BI Connector ODBC Driver on the Gateway server and connecting to it through ODBC (via Direct Access). But the BI Connector is being deprecated in a few months and they recommend using the MongoDB Atlas SQL Connector ODBC instead. While this ODBC DSN Test Connection is successful on the gateway server. I am unable to connect to this DSN through ODBC (via Direct Access) on the Qlik Sense App.
For the ODBC Connection String Properties for the BI Connector DSN I used 'uid' and 'pwd' to authenticate.
This doesn't seem to work for me with MongoDB Atlas SQL. I tried using 'User', 'Username' and 'Password' as well but that doesnt work.
I get the following the error:
Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: General warning - ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80")
Please let me know where I am going wrong with this one.
