Chartio (discontinued) vs. erwin Data Modeler

Chartio is a great tool for building presentable dashboards. It can export, you can add read-only access, and it has permissions levels by dashboard for users. There are other data analysis tools that help to analyze the data, but few allow for such a nice presentation

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

• Direct linkage to our databases. Abstracts away the visualization layer so we can focus on the data and the queries.
• Host of graphs and tools that permits all types of data visualizations.
• Haven't quite used this yet, but there is a new embedding feature that will be very helpful so that we can embed the charts into a company central dash.

• 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

• There is not a last full month date range option. You can still get the range that you need, but the dashboards will have to be manually updated to exclusively display one whole month.
• When building a chart, the area which displays your tables and fields is finite. You can't adjust the size to make it easier to see. They do allow a mouse-over to see the entire name of your table/field, but I would prefer to adjust the width.
• Once you modify a query in the Custom Query tab, there doesn't seem to be a way to go back to using the U.I.

• 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

Great customer support: You will receive an answer by email usually within 20-30 minutes. Not only that but our CSMs for Chartio go out of their way to help, they have even created charts for some of the less experienced users that wanted an example to work from. We have had nothing but great experiences with this team.

Incentivized

I really like using Chartio. I use it on a daily basis for pulling data from different sources and combining data (the explore tab was a great idea for this use). I think I would give it 8/10 because there needs to be more documentation or maybe blog posts about things people are doing with it. I only have my own ideas about what to do /how to graph things. I know there are some articles, but it would be awesome to have a section on the neat dashboards people are building or how they show data in different ways. Another complaint is how much time it takes to load. I know our databases aren't set up precisely for Chartio and I have been creating data stores. But the data stores have so many more limitations that adds a whole new layer of frustration. Love the product, keep up the good work and the fast fixes.

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

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

I use self learning materials. Pretty helpful. I find myself having to go back to the "drilldown" instructions though, and have a hard time finding hidden variables on a dashboard, so perhaps there is room for intuitive improvements (or maybe I'm just being lazy)

Chartio so far has been the easiest BI tool to setup and has also been the most affordable. There are some other, great, BI tools out there but they were a bit to heavy handed for what we needed. Also - despite the high cost per user in Chartio, the other tools were still more expensive.

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

Chartio has worked well as our datawarehouse has rapidly expanded, and the usability/performance hasn't seemed to have suffered. What we haven't yet realized is additional savings from additional users. We have some dashboard needs for users who truly just view of a few charts, and the licensing structure hasn't yet been structured in a way that would support that type of approach...having 50 "core" licenses, and then potentially several hundred view only licenses for partners that would use the application infrequently.

• 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