IDERA SQL Diagnostic Manager vs. Jaspersoft

SQL Server [Business Intelligence] Manager is useful for tracking performance across SSIS, SSRS and SSA and have the data represented in dashboards. It helps improve performance and helps end users. However, several features are redundant for smaller organization that can use the tools that comes with existing Microsoft products. These features also takes time to learn and use.

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

• SQLdm does a good job of providing information at a high level, but also allows me to drill down to specific queries and events if needed. I don't always need to sift through tons of details to get the information I need. It also gives a very wide range of information from SQL specific metrics, to OS metrics, to VM metrics, all the way up to host server metrics.
• I like how the alert and notification system can be customized. For example, if you know a certain server regularly has long-running queries, you can adjust the alert to not fire unless a query has been running for 30 minutes while the rest of the servers fire after 30 seconds. That is very helpful in not being bombarded at dinner with alerts from a server similar to, "I've been at 90% cpu for 26 milliseconds!!!!!!!...and now it's back down to 30%" Good information to know, but not something you need to literally lose sleep over.
• I like how you can configure different servers to be monitored differently. For example, you can have a group of servers called DEVELOPMENT that you can turn on heavier monitoring on so you can test how changes in applications might affect the SQL environment, but in the PRODUCTION group, you may only want to enable the heavier analysis and logging when performance issues are actively being reported.

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

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

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

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

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

• Allows us to quickly set up ETL processes as soon as we installed SQL Server.
• There's a lot of free/paid resources available online, decreasing development time.
• A tool with plenty of experienced developers.

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.