Astrato Analytics vs. erwin Data Modeler vs. OpenText Magellan

Astrato Analytics provides a feature-rich application that it easy to use for the non-technical user yet robust enough to create a sophisticated SaaS application. Astrato Analytics provides native integration to all the major large cloud data platforms and the implementation is very straight forward. The value provided through their feature-rich platform and competitive pricing is unmatched.

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

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.

• Writeback to the database is simple and straightforward and allows us to build apps in the tool with a level of interation that is not possible with other BI tools
• Version control that is built into the workbooks allows us to quickly deploy changes without the fear of losing the older version and maintianing both a historcal updates and the ability to rollback
• Easy connectivity to a wide range of data platforms including Snowflake, Databricks, and Google Workspace within the same tenant allows us to leverage data from each of these platforms for specific use cases

• 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

• The report outputs can vary across different types such as HTML, PDF, and Excel
• Their open source offering is very sufficient
• There are great boards and blogs for developers and engineers to expand and use their features.
• The people from the company that I've worked with are professional and courteous.

Incentivized

• The product is still young, as a consequence, some features aren't as mature as competitors. Astrato has worked to catch up quickly, by rolling out new features regularly
• Better ability to control icons and themes from a central point, instead of having to add/change them on each report

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

• The documentation on all the available features, but most importantly on the scripting side, can be improved
• The standard look & feel of some basic options, like parameter selection or sorting and filtering, looks dated and can't be customized
• The server portal needs to provide better tools
• More integration is needed with other OpenText products

Incentivized

I am no longer working for the company that was using Actuate but I believe they would continue to use it because the stitching costs would be to high. It would require a complete rewrite of the reports and the never version of Actuate (BIRT) even required an almost complete report rewrite

Incentivized

It is a very intuitive system, a pleasure to use, practical and simple, for medium to advanced activities. BI supervisors are delighted with much of the functionality, but highlight some weaknesses that they still have, such as the loading speed in HEIC-type files.

Without a doubt, it is a tool that has become essential in our business routine.

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

It is quite intuitive to use. It is fit specifically for doing sentiment, emotion, and intention analysis as well as text classification and text summarization. I would have given 10 if it is fit for the purpose of doing image processing and analysis as well. There is a huge market to analyze video and image data.

Incentivized

Very friendly, with online help, blog and community. The template documentation could be more complete, however.

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

Always there on the front and backend for us and the client.

To scale PowerBi, we would have needed a staff of technical folks and a substantial budget, and we still probably could not have created the robust SaaS application we did with Astrato Analytics. Astrato Analytics allowed for a staff of two to create and rollout a SaaS Application in under 60 days and provided hands on support to us as needed. There really is no comparison.

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

It is vastly superior to these in many ways, for complex reporting it is a much more sophisticated solution. Visualizations are very good. Javascript extensibility is very powerful, others don't support this or as well. Pentaho and MS are both OLAP oriented. Pentaho is moving more toward big data, which was not our primary focus. Others are stuck in the Crystal Reports Band metaphor.

• The ability to unify multiple platforms in Astrato provides cost savings.

• 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

• Actuate can handle 50 to 60 sub reports inside a report very well.
• Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.