Hi All
I have trying to use Knime to get some data from our mongodb cluster, but I am getting more and more frustrated with my inability to get this working :-(
-In Knime 3.3, i was able to connect to mongodb and do simple search queries, but the implementation of the mongodb reader does not support filtering/searching for dates. I spend hours reading and trying jongo syntax before posting here by then, to learn that that MongoDB reader does not support queries like {"d": new Date("2017/01/01")}.
-After upgrading to 3.5, I am unable to connect to the mongodb database, due to socket error, which seems to be a huge step back, but again searching in google and this forum provided a good answer; there is a bug which prevent connect to mongodb databases if using SSL.
The suggestion I have got is just use the java snippet to connect and retrieve the info from mongo, but after searching for some examples, tutorials and so on, I have found nothing at all.
I am not a java developer and I have no clue about java (I know other languages but not java), can anyone point me to a working example for this? Just connect and retrieve one row or any query to a collection for anything? I can manage to do the rest.
Thanks! Knime is a great tool I am using with other DBs but for some reason, interacting with mongodb is getting extremely difficult and frustrating.