erwin Data Modeler vs. Jaspersoft vs. Mode Analytics

I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.

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

Mode is a clear category winner for how it easy it is to go from interactive analysis to professional quality reporting. You can easily do all your SQL and quite a bit of R/Python. If you want to quickly go from your database to simple charts, this is your pick. If you need to do heavier data modeling, scheduling jobs, or ML, you'll need something else, like Databricks. In my opinion, the quality of visualizations and some developer/analyst features make Databricks an unacceptable substitute.

Incentivized

• Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
• Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
• Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.

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

• It allows me to undertake data visualization tasks by creating really insightful charts and dashboards
• It allows for easy sharing and work collaboration on data analysis tasks
• Mode has an easier to use SQL editor as well
• I love how it organizes all our SQL data tables into easy-to-view data we can draw insights on

Incentivized

• Cost is the single largest barrier to entry with this tool.
• Would like to see a greater variety of export options available for use outside of the tool, for example as a vector graphic.
• Support has been uneven at times.

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

• Date ranges aren't always the most intuitive to set, strangely
• Faster refresh rates would be ideal
• Would love more dynamic mobile device integration (alerts, etc)

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 had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.

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

For the advanced user already familiar with Python. It is just the same tool, already managed and connected to the data.

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

CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.

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

Mode has dedicated agents who are online in a chatroom, ready to take on any questions and provide helpful feedback.

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

Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.

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 used both Qlik and Mode at our organization. The mode was used a quick analysis SQL tool while Qlik was our enterprise BI solution.

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

• It is difficult to assign a monetary value to it. The initial learning curve was fairly long.
• It allows us to have better support documentation.
• It allows ease of communications between functional units.

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.

• Extremely positive. It's a key feature in our application.
• Were it not for the account management bit, Mode would be hands-down our recommendation for anyone looking for cloud BI.

Incentivized