MongoDB data source
MongoDB data source
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.
.
Re: MongoDB data source
Hello,
We made some improvements and fixes in that direction. Please check the latest build.
If the issue still present, please send us a sample which reproduces the issue for analysis.
Thank you.
We made some improvements and fixes in that direction. Please check the latest build.
If the issue still present, please send us a sample which reproduces the issue for analysis.
Thank you.
-
- Posts: 3
- Joined: Tue Jun 12, 2018 3:44 pm
Re: MongoDB data source
.
Last edited by t3rminator on Wed Jun 20, 2018 7:44 am, edited 2 times in total.
-
- Posts: 3
- Joined: Tue Jun 12, 2018 3:44 pm
Re: MongoDB data source
Hi,
I use Stimulsoft Designer 2018.2.2, try to connect to mongodb 3.6, but data collection not shown after doing the instruction shown in above videos. but no any data collection shown in select data page Can any one help?
the mongodb.cfg :
"
systemLog:
destination: file
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
net:
bindIp: 127.0.0.1
port: 27017
"
I use Stimulsoft Designer 2018.2.2, try to connect to mongodb 3.6, but data collection not shown after doing the instruction shown in above videos. but no any data collection shown in select data page Can any one help?
the mongodb.cfg :
"
systemLog:
destination: file
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
net:
bindIp: 127.0.0.1
port: 27017
"
Last edited by t3rminator on Thu Jun 14, 2018 6:51 am, edited 1 time in total.
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB data source
Hello,
We need some time to investigate the issue. We will let you know about the result.
Thank you.
We need some time to investigate the issue. We will let you know about the result.
Thank you.
-
- Posts: 3
- Joined: Tue Jun 12, 2018 3:44 pm
Re: MongoDB data source
Hi,
not found any solution?
not found any solution?
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB data source
Hello,
We are working on the issue. We will let you know about the result.
Thank you.
We are working on the issue. We will let you know about the result.
Thank you.
Re: MongoDB data source
Hi Team,
Even I am facing the same above issue for 2019.1 version downloaded yesterday. MongoDB connects successfully, however does not show the list of collections. Does the issue still remains unresolved?
Thanks,
Vani
Even I am facing the same above issue for 2019.1 version downloaded yesterday. MongoDB connects successfully, however does not show the list of collections. Does the issue still remains unresolved?
Thanks,
Vani
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB data source
Hello,
There are some problems with MongoDB adapter. We are working on this problem.
Thank you.
There are some problems with MongoDB adapter. We are working on this problem.
Thank you.
Re: MongoDB data source
Hi Team,
Any update of the above issue? Will there be a new release with this fix?
Regards,
Vani
Any update of the above issue? Will there be a new release with this fix?
Regards,
Vani