What is our primary use case?
My main use case for
erwin Data Modeler varies, but I use it for forward engineering and reverse engineering and documenting databases.
I work with something that requires forward engineering or data reverse engineering or some other use case, and I start the tool up. I begin to enter data in or I acquire DDL to reverse engineer or I sometimes will use Excel to import data into the tool.
What is most valuable?
erwin Data Modeler offers a wide variety of databases supported both in the cloud and on premises, and support for IDF1X.
The support for a wide variety of databases and IDF1X helps me in my work by allowing me the flexibility to go from Oracle in a legacy system or DB2 to the cloud in a modern system for Snowflake. IDF1X is helpful because it is a standard and I know it pretty well, so it is highly useful in that context.
erwin Data Modeler has positively impacted my organization by having a team of modelers who are using it.
What needs improvement?
erwin Data Modeler could improve in a few ways, starting with the ability to not have to go out to the external Maven files to import and export the metadata from a different format. It could also add support for Oracle modeling techniques in addition to IDF1X, and
finally, they could fix the views, as they do not use ANSI 92 views or ANSI 92 joins in the views.
For how long have I used the solution?
I have been using erwin Data Modeler since 1996.
What do I think about the stability of the solution?
erwin Data Modeler is currently stable.
What do I think about the scalability of the solution?
erwin Data Modeler's scalability is pretty good; the ability to create your own diagrams and figure out what is on each one makes it very scalable.
How are customer service and support?
I have not dealt with customer support in two or three years.
Which solution did I use previously and why did I switch?
I use whatever my employer uses and I have used other tools in the past, whatever the shop was using, I used.
How was the initial setup?
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous. The setup is okay, but there is room for improvement.
What about the implementation team?
My company does not have a business relationship with the vendor other than being a customer.
What was our ROI?
erwin Data Modeler is worth it; it is important to work and coordinate with the end users and with the development team and build a common logical approach to how you will implement or your approach will be with a system, otherwise it gets skipped.
What's my experience with pricing, setup cost, and licensing?
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous. The setup is okay, but there is room for improvement.
Which other solutions did I evaluate?
At this place, the current organization, there are not really any alternate solutions, but I have looked at Embarcadero's
ER/Studio, and that was pretty easy to use and fairly straightforward.
What other advice do I have?
I would rate erwin Data Modeler's overall an eight on a scale of one to ten. I gave it an eight because I could not give it an 8.5, as there is room for improvement.
I would advise others looking into using erwin Data Modeler that it can be worth it if you can afford it.
I have not used the AI capabilities of erwin Data Modeler yet, so I cannot comment on its governance and security. Regarding the accuracy and reliability of output in erwin Data Modeler's AI capabilities, I also have not used the AI yet.
My overall review rating for erwin Data Modeler is eight.