QlikSense and ODBC With MongoDB

[#1]

Hi Folks,

I am trying to connect to MongoDB using Simba's ODBC driver and everytime I try to "save" the new ODBC connection in QlikSense, I get the following error:

An error occurred

You do not have access to a script data source

I am using a 64 bit System DSN that works perfectly with Excel, por example.

Best regards,

DAniel

[#2 · Accepted solution]

Hi Daniel,

Is the error message something that you're seeing from QlikSense or is it from the driver, do you know?

If you aren't sure, one way that you can check is to enable driver manager tracing as shown here:

How To Generate an ODBC Trace with ODBC Data Source Administrator

Turn on tracing, restart QlikSense and retry the operation which causes the problems. Then stop tracing and open the trace log file. Somewhere near the bottom of the log there should be an entry that returns SQL_ERROR if the driver is causing the problem, if there are no errors then it is likely related to QlikSense. If there are errors, copy them into the discussion to help the analysis.

Cheers,

Kyle

[#3]

Thanks Kyle,

I forgot to install the SIMBA ODBC license file... it became clear in the generated ODBC trace file.

[#4]

Hi Daniel,

Glad to help

Cheers,

Kyle