<p>Hi,</p>
<p>I'm having serious problems to get a report from a mongodb. I've got this process that's inserting data into a mongo collection and I want to render it in a report using BIRT community</p>
<p> </p>
<p>With Eclipse Neon2 and with mongo server 3.2 and later 3.4 I was finally able to render in design view (I had to do the trick substituting the mongo driver as in this topic (<a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/topic/39354-birt-45-unable-to-load-collections-from-mongodb/'>http://developer.actuate.com/community/forum/index.php?/topic/39354-birt-45-unable-to-load-collections-from-mongodb/</a>) but I wasn`t able to generate the report using the runtime.</p>
<p> </p>
<p>After many combinations of mongo servers (2.6, 3.0, 3.2 and 3.4) and eclipse runtime (4.4 and 4.6) I finally got to Oxygen 4.7 and here the problem with the datasource is that some bson/SimplePool class is missing so you cant'e even ping the server.</p>
<p> </p>
<p>So I will appreciatte some advise:</p>
<p>1.- How to overcome this bson problem (I have already tried differnetr bson.jar with different results although no one OK)</p>
<p>2.- regarding mongo server what would be the ideal combination between mongo and birt to:</p>
<p>a.- Design time </p>
<p>b.- Runtime (what jar files do I need)</p>
<p>3.- Regarding the previous just in case someone has noticed it I switched server so often because I found that some IsoDate fields in mongo where not able to be converted to java date type (all of then where output from mongo as DSL date time Strings (CEST/CET)) I wasn`t able to found the cause and its quite anoying as it makes me treat everythings as a string and i have to do explicit conversion in birt to date calculations. With 3.4 it's not happening so often ....</p>
<p> </p>
<p>Well, advise on 1 and 2 would be great</p>
<p>Regards</p>