Dundas BI is a business intelligence and data visualization software that includes customizable dashboards, reporting, and visual data analytics. Dundas BI can be integrated into users’ existing business applications and its visualization and reporting tools can be customized to their needs.
N/A
Jaspersoft Community Edition
Score 9.7 out of 10
N/A
Jaspersoft Community Edition is a free product that offers embeddable pixel-perfect reports for Java apps and small workgroups.
For all the scenarios I have so far worked on or I am currently working on, Dundas BI has proved to be more than adequate and apt to handle all of those. It is a very easy-to-use tool with quick shortcuts enabling you to prepare ad-hoc reports or dashboards in a matter of minutes.
Any scenario where you need to reach back into TIBCO support is something I would highly avoid. Most responses at the second round get you pointed to engaging their professional services. The general mentality seems to be "since our product acquisition cost is low, why don't you engage PS to get the value you need" If you are looking at enterprise scenarios, I would highly recommend looking at other more established products.
Project organization from Development to Production, you get a production and development license but I think the best way to do it is with DEV and Prod project in the Production box. Use the development box for testing updates and really crazy things. With the Dev and Prod projects on the same box, you just publish from Dev to Prod and you are done. Users only have access to the Prod projects so no one can mess up what you are working on.
Security - If you have a hierarchy (subsidiaries, divisions, department, teams) and you want each group to see only their data, then Security hierarchies are for you!
Dependent filters! What's this you ask? Here is an example of how it can be used, in your company you have departments and who works for what department is in your database. You make a dashboard that has a department filter (only show these departments), a managers filter, and employee filter. Not every manager or employee is in multiple departments usually only one. With dependent filters you can say that the manager and employee filter are dependent on what is selected in the departments filter so when you go to filter them they only show the managers or employees that are part of that department, and you can even it do so employees are not only dependent on department but on manager as well. Then it gets even better as it can be done in reverse as well so when you select a manager then go to the department it only shows the departments he works for (there are better situations where this is more useful).
It is scriptable! From calculate columns, null replacements, button actions, load actions, hover over events there a way to do what you want.
They are constantly improving and listens to your suggestions.
Very intuitive tool - An Advanced reporting user can figure out in a day on the end to end operations.
Easy customization - Simple changes in UI makes it less headache for the end user who maintains the tool. Being an open source product (offers Jasper web services) makes a lot developer friendly compared to SSRS, Cognos etc.
Easy Connectivity - Can connect to any data source (can connect to multiple data sources) for a single report - can be customized.
Community - A very strong community available online, videos - on basic how to questions, also provides assistance to use case specific scenarios.
Ease of Reporting - Can create a reports with in few clicks with out struggle.
Domain Designer - A very powerful tool you can create a dataset using clicks with out writing SQL code.
OnDemand Scheduling - A very good scheduling feature and a has got lot more simplistic compared to other popular tools like Cognos.
Jasper Studio - Very good programmatic tool (desktop tool) lets you customize the reports more company specific, can embed complex coding with 3rd party languages like Java, Groovy (scripting language).
Not too many cons for how we use the application. It really is easy and powerful. Very powerful.
Licensing is one thing that could be looked into. It is simple, but a little confusing. For example, if I get a license today, but a new release comes out tomorrow, it seems that the license doesn't work with the new release. Maybe that is by design, but it would be nice to clearly understand.
Easier to customize the Jasper Server GUI. More flexibility with the input controls look and feel and maybe more input control types to select from.
Have browser event functionality in the reporting itself.
An easier way to iterate through an object. Maybe an option that tells the report Java run-time to stop following the report sequential flow and first integrate through this stated object many times.
An easier way to create a list and add values to this list.
Maybe one could stipulate the process flow of what needs to be computed first in a given field.
The crosstab is a bit buggy on the Jasper studio side, so if that could be improved.
Better and more examples of custom components
The jive functionality on the tables needs an update. It looks so old and outdated.
Even though there are challenges with Architecture, sizing and other areas with Jaspersoft provided that Jaspersoft comes up with the right set of innovation, performance, scalability, and documentation in future it will be great expansion (win-win) situation for the clients and as well as Jaspersoft.
We are still in the implementation phase, but so far we are finding it to be easy to use and learn. The eLearning courses that they have made available for free, as well as User Forums and other training videos have made even difficult concepts easier to understand.
The overall performance of this platform has been excellent. It is easy to work with the user interface. Creation of digital content and publishing on our social media platforms during marketing has been easy. Running our applications and upgrading our system to meet international standards has been successful. The user dashboard displays reports and performance of all departments effectively.
We have bi-weekly calls with our Success Manager, as well as access to support as needed. Any question that I have had, multiple people have been willing and able to jump on a call to talk me through it, or send an email with the solution
We have only had a couple of tickets to be open while using Jaspersoft. Each time we have a very prompte responses that would meet our expectations. We always felt that our issues were being address in a timely manner
While the training was somewhat beneficial, a lot of what was taught to us was what we managed to figure out in the weeks prior. It did provide some useful tips and reference material, but overall something more tailored to our requirements would've been better.
New releases can be very buggy, also lacking when it comes to standard time zones and formats that are outside the US. As a company we never feel comfortable implementing a new release for at least 3-6 months due to errors that are found
Per dollar spent, it offers the widest range of features of the tools that we evaluated. It offers lots of options for how to configure your environment, though they are not always intuitive to figure out. Having an ETL layer was a must have for us, as well as the ability to host to secure HIPAA compliance. It is not a replacement for ad hoc reporting, but does a great job of creating parameterized reports and dashboards that look great.
Crystal reports is very expensive and does not integrate well with java based servers. Jasper also provides community edition, if we every want to downgrade the use, we always have the option of eliminating the server and using the reports as they are. Jasper also give you the opportunity to build BI on case by base basis including Dashboards.
Jaspersoft Community Edition has not had any significant impact on our ROI as we have purchased the commercial edition of the product.
The only impact on ROI is that when we bring on new developers, he or she can begin work using the community edition while awaiting the installation of the commercial edition.
