erwin Data Modeler vs. SAP LeanIX

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

SAP PowerDesigner allows our team of data modelers to work and collaborate from a single repository and single data dictionary. This helps enforce consistency as data elements are referenced in other objects. Prior to our use of PD, we might have an element named "ppt" in one table, "participant" in another table and "part" in a third table. By forcing everything to be used from the data dictionary, we avoid these situations because everyone has to go to the dictionary. And we are able to easily do peer reviews on models before they are released because we are collaborating through the use of the repository.

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

• User friendly
• Configurable
• Relations between fact sheets
• Lifecycle management
• Self build reports

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

• Licensing cost is based on user count
• Free licensed competitors exist, and they perform similar functions
• New database structures could be implemented more easily

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

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

We did have to reach out to support to learn how to properly utilize the repository feature and share the data model across many developers. Support was able to help us get this set up correctly. The downside was it took us several weeks before we gave up and contacted support. We should have done that earlier. I would say, however, the documentation wasn't clear on how to do this. So support was a great big help!

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

We did not do a comparisson

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

• Standardization of models
• Impact Analysis
• Graphical User Interface
• Ease of deployment

Incentivized