dbForge SQL Tools vs. Hashboard (discontinued) vs. Jaspersoft

dbForge SQL Complete is well suited for professionals that have to write code all day. In my role in the business intelligence department we are writing SQL pretty much all day. Having a tool that helps us do that faster, in a cleaner way is pretty awesome and something that pays for itself quickly.

Incentivized

Glean.io is exceptionally well for creating automation data visualisation dashboards. Exploring the data is again highly effective. Visualisations are easily customisable to best suit the requirements of the team. Collaborating and commenting around the dashboards is very smooth. If there are any changes in the system or any feature requests, the support team takes some time to respond

Incentivized

It is well suited for the fact of scalability itself and the breadth of features this application has in order to make the migration from legacy systems to the newer different versions more seamless and effective. Data integrity and security are the main aspects of this tool which does not lose their value when doing day-to-day operations for data mapping.

Incentivized

• SQL complete allows you to create custom snippets that allow you to store frequently ran queries in shortcuts. The code can be populated within seconds!
• Another great benefit is custom aliases. If you frequently reference the same tables over and over again it gets tiresome to retype the aliases. Storing these can make your code more consistent and save time.
• SQL complete will also highlight the metadata within your database. For example, if you start typing an insert statement you populate code for all the field names by pressing the tab. This is a real-time saver for wide tables!

Incentivized

• Workflow is easy and clear due to clean and state of the art interface
• Model creation is easy
• Possibility for custom SQL code for database connection is very helpful

Incentivized

• TIBCO Jaspersoft allows you to embed reports into your own application, which gives users the feeling they are using a single product.
• TIBCO Jaspersoft Studio allows for more advanced report development, such as adding subreports, drilldown to detail reports, images, page headers, page footers, maps, and more.
• TIBCO's Jaspersoft Domain Designer is very easy to use and navigate.

Incentivized

• Sometimes it can be slow to retrieve the database metadata.
• Updating the software with the activation/deactivation of licenses could be further streamlined.

Incentivized

• Querying has to be done by users only. There can be ways to automate querying using templates
• Not able to clearly check the query run time
• The customer support team can be little more proactive while communicating any changes and resolving any queries

Incentivized

• One of the issues we found during our implementation was that the reporting software would work faster for certain data sources and not the others. Extracting CSVs and XML was slower in comparison to JSON in our experience.
• Jaspersoft Studio was the main IDE we used for development. Built atop the Eclipse IDE, we found that the tool was really resource intensive and generally take long time to initialize.

Incentivized

JasperSoft has been amazing. It is well documented, fast, and transparent in how it functions. We have been very confident in JasperSoft in every aspect of our business and offerings where we've used it. On top of that, their improvements to the product have been fantastic. I am really looking forward to seeing where they take their product and how we can leverage that to please our clients

Incentivized

I think it's a tool well suited for a software developer. Others with less coding skills could struggle somewhat with the tool. I find java a little unforgiving as a language for expressions and not very user friendly for the technically dis-inclined. Sometimes the numeric conversions cause issues (who knew that 0 and 0.0 would cause different things to happen). Previous experience with a reporting tool that used visual basic for its' expressions that I found much simpler to use. On the other hand, java is so widespread, you can easily google the syntax to accomplish what you need to do.

Incentivized

We've never had an outage of the software itself. If it was unavailable, it was due to a network outage, not a problem with Jasper.

Incentivized

Complex reports on heavy data load may take considerable amount of time. We have experinced some latencies/misfires regarding to this.

Incentivized

They have a great customer support ticketing system in which they always respond same-day. They offer conference calls with srcreensharing as well in order to better understand your issues.

I wish that the lower level support access came with more than just 12 cases per year though as this makes us less likely to reach out for questions on things that we then instead try to solve ourselves which results in loss of time in trying to acquire new features and or solve a problem.

Incentivized

It did the job of getting us to our deadline we set for ourselves for initial launch. The customer we launched the product for was also there to learn about it at the same in order to better understand the capabilities. This helped greatly so that the customer was on the same page on what was possible when using jaspersoft. I think most people would not want their customers aware the product they are using is third-party but in this case it was a new experience for us both and so as we learned more about jaspersoft, we both had better communication on what the future road map was for their business needs in BI.

Incentivized

Resources available in the TIBCO Knowledge Base are covering almost everything. They are well organized, and covering almost every possibility. There is always the change to get back to the TIBCO support or to the dedicated Customer Success Manager whenever something very specific or bound to a customization is not covered.

Incentivized

Having just completed an upgrade to the latest version of Jaspersoft, I am happy to say their support was very good. There were a couple of small challenges which were not easily resolved, but they were primarily related to the fact that we had skipped updates for a couple of versions. The current update procedures assumed we were upgrading from the prior latest version (6.4) to to the new version (7.1).

Incentivized

I am very satisfied after using this tool. It is a full-stack tool that includes rich features that can be customized set of functionality as per your need. by using this tool:-

• Increased our productivity rate.
• Provides speed up your development work so you can focus on other stuff.

For simple use cases, Glean.io is a lightweight alternative to SAP Analytics Cloud. Provisioning, testing, and documentation are easier and less intimidating in the Glean.io case. Thus, it is easy to explore without firing up the sales machinery of the big corporates. Thus, the process of looking into and testing it out was way more convenient. Further, the data ops features were new to use and seem to be unique with Glean.io.

Incentivized

When looking at the different features of these reporting engines, and what we were going to be using it for, the answer seemed clear. Jasper offered exactly what we were looking for, and did so for a price that we were happy with. For a scalable, feature-rich reporting engine that doesn't break the bank, Jaspersoft is the way to go.

Incentivized

We haven't really started to explore the scalability of the product as yet, but in terms of existing deployments it has done what we need it to do.

Incentivized

• Spending less time trying to figure out how tables are related thanks to the navigational help in dbForge SQL Complete, which means fixing issues takes less time.

Incentivized

• Optimised the DB management team by 30%
• Reduce in data visualisation dashboards TAT by 50%
• Increase in revenues and savings by 20%

Incentivized

• When we demo our Jaspersoft environment to potential clients, their eyes light up and they sit up in their chairs a bit more. A lot of our meetings have ended with with the client very interested in our product due to Jaspersoft.
• Our existing clients have been very satisfied with the adhoc features of Jaspersoft. We've been able to provide them better access to their data on their terms instead of ours. Of course this turns into a huge win for us.
• We've always used SQL Server Reporting Services to deliver our reports to our clients. Converting to Jaspersoft has allowed us to generate the reporting layer that our clients demand. They no longer feel like they are settling for what we offer.