2 Replies Latest reply on Oct 21, 2018 9:19 PM by thomas.hoang.0

    Tableau query MongoDB data not authorized issue.

    Sylvan Ray



      I installed MongoDB and Connector for BI on my Linux server. When I use tableau desktop 10.5 on mac I can successfully establish a connection, but cannot update the data of collection.

      Here is the error information.

      [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.12 mongosqld v2.4.1]failed to execute aggregate: (Unauthorized) not authorized on test to execute command { aggregate: "log", pipeline: [ { $limit: 1000 }, { $project: { 1: { $literal: 1 }, test_DOT_log_DOT__id: "$_id", test_DOT_log_DOT_result: "$result", test_DOT_log_DOT_time: "$time", test_DOT_log_DOT_type: "$type", _id: 0 } } ], allowDiskUse: true, cursor: {}, readConcern: {}, $readPreference: { mode: "secondaryPreferred" }, $db: "test" }


      ./bin/mongodrdl --host --username test --password test --db testdb --authenticationDatabase admin --out schema.drdl
      ./bin/mongosqld --addr x.x.x.x:3307 --mongo-uri mongodb:// --mongo-authenticationSource admin --schema schema.drdl



      Has anyone encountered the same problem? Please kindly guide me.


      Thanks & Regards