1 Reply Latest reply on Apr 5, 2018 3:06 PM by patrick.byrne.0

    Tableau query MongoDB data not authorized issue.

    Sylvan Ray

      Hi

       

      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 127.0.0.1:27017 --username test --password test --db testdb --authenticationDatabase admin --out schema.drdl
      ./bin/mongosqld --addr x.x.x.x:3307 --mongo-uri mongodb://127.0.0.1:27017 --mongo-authenticationSource admin --schema schema.drdl
      

       

       

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

       

      Thanks & Regards

       

      Sylvan.