MongoDB data source
Posted: Wed Apr 20, 2016 9:49 am
Hello,
I wanted to create some reports from MongoDB data, so I followed these Stimulsoft tutorials on youtube:
http://www.youtube.com/watch?v=8d00pQ7hpmE
http://www.youtube.com/watch?v=oCfpMlAbkXY
http://www.youtube.com/watch?v=VAj1KySNhCc
I tried that on version 2015.3 (fresh install) and had several problems:
1) error while trying to download and install mongodb driver via Designer.exe (it told me that something was wrong with URI) - ok, I did that manually (and was able to see my MongoDB database's structure).
2) error while trying to use query syntax shown in the videos - it always said "some lexemas remain unprocessed".
I rollbacked to version 2015.2 then (uninstalled 2015.3 completely, installed 2015.2) and there were no problems with the above two steps, so I think you should recheck the changes you made in 2015.3.
So now I can query MongoDB data source, but I have a question: how can I use aggregation functions? What syntax should I use? I need to be able to group, sum and count data on MongoDB's side. I can't pull 20 GB of data to the client for that (obviously). Please, help.
.
I wanted to create some reports from MongoDB data, so I followed these Stimulsoft tutorials on youtube:
http://www.youtube.com/watch?v=8d00pQ7hpmE
http://www.youtube.com/watch?v=oCfpMlAbkXY
http://www.youtube.com/watch?v=VAj1KySNhCc
I tried that on version 2015.3 (fresh install) and had several problems:
1) error while trying to download and install mongodb driver via Designer.exe (it told me that something was wrong with URI) - ok, I did that manually (and was able to see my MongoDB database's structure).
2) error while trying to use query syntax shown in the videos - it always said "some lexemas remain unprocessed".
I rollbacked to version 2015.2 then (uninstalled 2015.3 completely, installed 2015.2) and there were no problems with the above two steps, so I think you should recheck the changes you made in 2015.3.
So now I can query MongoDB data source, but I have a question: how can I use aggregation functions? What syntax should I use? I need to be able to group, sum and count data on MongoDB's side. I can't pull 20 GB of data to the client for that (obviously). Please, help.
.