Difficulty to connect on MongoDB BI Connector

[BIGlobal]

Hello,

I'm trying for a while now, to connect on my mongodb using the bi connector.

I've created an ODBC connection and configured the Direct Access Gateway on my computer too.

Everything is connection fine, but when I try to select a data to load and select a table, this error appears: 

"Status(StatusCode="Unknown", Detail="Exception was thrown by handler.")"

Someone could help me with that?

In another table when I try to load, appears this other error:

Command preview returned non-success: ERROR [42000] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.15]parse sql 'SELECT "_id", ConnectionId, DeviceType, IdPausa, Login, Logout, OrgId, Paused, Status, Token, Unpaused, UserAgent, UserId, UserIp FROM MyLoopDB."activity_history" LIMIT 50' error: syntax error: unexpected STRING at position 191 near activity_history

[diegozecchini]

Hi!

it seems to be related to SQL syntax issues and potential exceptions being thrown by the handler in your environment. 

The error: ERROR [42000] .. suggests that there might be a syntax issue in the SQL query being generated. Since MongoDB BI Connector translates SQL to MongoDB queries, certain SQL syntax might not be supported or could require adjustments.
Try to verify the SQL being generated. Specifically, check the structure of the query and make sure it's compliant with the MongoDB BI Connector's SQL syntax. Ensure that column names or table names do not conflict with reserved keywords or have unsupported characters.

Maybe you can try with simpler queries.

The Error Exception Thrown by Handler indicates that an internal exception was thrown within the BI Connector's processing pipeline, possibly due to an unsupported operation or data type mismatch.
Try to ensure data types are supported and correctly mapped.
Check the logs of the BI Connector for more detailed error messages that can give further insight into the issue.

[BIGlobal · Accepted solution]

Hello!
You're correct about the syntax, yesterday I was able to finally connect and load data, I've changed the syntax config, before I was using the Custom SQL Syntax, by changing to MariaDB Syntax the data loaded easily.
So, if someone is having trouble to connect the mongodb ODBC on Qlik Saas, try to use de MariaDB Syntax, it may work.

[diegozecchini]

That’s great! Good job! 💪