Astrato Analytics vs. erwin Data Modeler vs. IBM InfoSphere Information Server

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

Information Server is extremely useful to replace manual developments that require a lot of coding effort. It significantly increases the productivity of the initial development and the future maintenance of the processes since it has a visual development environment with self-documentation.

• 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

• IIS best for ETL ,not ELT , and many and diffrent source systems.
• It also can process big data , unstuctured data
• It is not only DWH , you can use infosphere for analys and see the bigger architecture of your OLTP systems

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

• I would be nice to have a new web development environment for DataStage.
• Connectivity Packs such as Pack for SAP Application are a little pricey.
• It is confusing for new developers the possibility of developing jobs using different execution engines such as Parallel or Server.

Incentivized

• Scale of implementation
• IBM techsupport

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

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

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

DataStage is more robust and stable than ODI The ability to perform complex transformations or implement business rules is much more developed in DS

• 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

• Productivity of the development of integration processes.
• Better documentation and governance.
• Reduce training costs of various technologies.