If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything.
This is despite the fact that we are clicking to bring objects from one place to another. Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. We are unable to find the exported files in our workstations at times. For example, the save known changes as snapshot does not work as expected. What needs improvement?Ĭomplete Compare is not user-friendly. We are able to use the templates to apply things like Naming Standards, casing on names, and colors to all our data models without having to be on top of it. We quite heavily use the templates that exist to apply our standards to the data models created by our data modelers. For the most part, we have been able to get any database to work with our data model format. The Reverse Engineering functionality is good and easy to follow.
With the help of the Bulk Editor, we were able to form those names with a few Excel formulas to follow our standards. There were times where we had a set of entities which were not following our standards. We find the text manipulation through the Bulk Editor to be extremely helpful. The Report Designer is extremely useful because we can create reports to share with our business users and have a business discussion with them on how things work.E.g., getting a database into a data model format or vice versa. We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand.The Bulk Editor lets us easily make a lot of similar changes within our data model.We find a few of erwin tools most valuable: "There are no costs in addition to the standard licensing fees.".There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool." This would not be to make any changes, but just to visually look at what exists. "An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it.Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. I would like to keep my ability to use the tool. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite." I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. In the mid-2000s, it was something like 1,200 AUD a seat. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. "I don't specifically know what we're paying now.