I have a database hosted on mlab and I would like to report against it using Knowage. Based on some googling, I learned that I needed to download the java driver for mongodb into my lib folder of the project. I went here: https://mvnrepository.com/artifact/org.mongodb/mongo-java-driver/3.4.2 and download the JAR. I placed the JAR in my installation folder in the lib secion. Some of the examples I read about included modifying the server's config files, some didn't. I've tried it both ways and can't get it to work. For the purposes of this question, I haven't made any modifications to the server.xml or the context.xml files in the conf folder of the installation.
When I go to add a datasource, I specify the following:
Label: Company Data
Dialect: MongoDB
Multischema (unchecked)
Read Only
Type: JDBC
URL: ds147441-a1.mlab.com:47441/companydb
User: mongodbuser
Password: mongodbpass
Driver: mongo
When I click test, it says "Tested Parameters are correct"
When I move in to the Data Set, I click "new", fill out the display info and scope, and under type I specify the following:
Type: Query
Data Source: Company Data
Query: db.collectionname.find({})
When I click preview, I get the following error: No authentication available yet.
I'm sure I'm missing something - I have very limited experience with Java based programs and no experience with Catalina / Tomcat. I'm attempting to get this going on my local windows system. Please help!!
Austin
