Idera just released another er/Studio to erwin head-to-head comparison with the title “er/Studio 2016 vs. erwin 9.64 Comparison Guide,” which is now available for download.
The paper is authored by Dr. Nicholas Khabbaz and François Cartier of e-Modelers, the preferred partner of Embarcadero Technologies (now part of Idera). Not exactly an impartial opinion. Keep that in mind when giving it a look.
Nonetheless, I want to thank Idera for coming out with a paper that actually compares current releases of each product, as the previous paper I read used a 5+ year old release of erwin DM that’s not even supported anymore. Thanks also to Nicholas and François for their efforts.
In my exciting new role heading up products at erwin, Inc., I lead a global group committed to growth and excellence. I am fortunate to have a team with decades of experience with the product, so I looked forward to their feedback on this new comparison. After all, we already know that our 64-bit erwin Data Modeler release is blazing the trail with the best performance in day-to-day usage and that we’re developing, selling, and supporting the #1 product in the market.
So, I was curious if they would come back with any inaccuracies. Surely there must be one or two, right?
I received 14.
Within an hour or two of the paper going out.
I was originally planning to provide a quick summary of each point, but in the interest of allowing you to do your own research, I’m providing more detail. Apologies in advance for the length.
Not a technical user? Short on time? Feel free to skip ahead to the summary and the 15th point.
Fourteen reasons why Idera has got it all wrong:
- While most of the info regarding semantics is mostly correct (with some omissions/inaccuracies on the erwin DM side) erwin DM has a much more logical and generally accepted organization:MODEL – SUBJECT AREA – MODEL OBJECTSDIAGRAMS (which can exist at the MODEL and SUBJECT AREA levels) are strictly a vehicle for visualization and not a construct of the model itself. er/Studio does not have a comparable feature. erwin DM users have a much more flexible and richer capability for constructing and displaying model metadata for specific goals and/or purposes.So, the paper is wrong.
- An erwin DM model is comparable to an er/Studio DIAGRAM, not an er/Studio MODEL. It represents either a Logical Only, Physical Only or Logical/Physical abstraction of metadata. There is no limitation (as in er/Studio) as to how erwin DM models can be related (e.g., 1 logical to many physical, 1 physical to many logical, many to many – can be logical or physical).Again, the paper is wrong.
- Section: Data Model Organization, Model/Submodel Organization – this is incorrect. Metadata contained in Subject Areas in erwin DM are automatically synchronized. There seems to be some confusion between the concept of Subject Areas and Diagrams within erwin DM, most likely due to a lack of understanding of these erwin DM specific concepts. Auto-populate is a visualization function and not a synchronization function.Wrong again.
- Despite statements to the contrary, erwin DM does provide a fully user configurable and flexible “reverse” naming standards capability (Physical to Logical).Yup, wrong.
- Whilst the opinions detailed in the Section on Attachments / UDPs are factually correct, there is little to no compelling value (our opinion) in the er/Studio approach vs. the erwin DM approach. We’re not alone in this opinion, although we do acknowledge that it may be relevant to some people in some specific cases.Wrong to assume this is a true differentiator.
- Despite statements to the contrary, erwin DM does support ALTER statement generation within Complete Compare.Wrong? Yes, wrong.
- erwin DM fully supports reverse engineering of a database schema (or DDL) into a Physical-only model to which any number of defined naming standards can be applied in the derivation of a Logical model (from the existing Physical model) thereby automatically generating the desired logical names. No manual process involving spreadsheets, CSV files and the Bulk Editor is required.The paper is wrong as erwin DM supports this.
- Automatic synchronization of model object mappings is accomplished using Design Layer models in erwin DM. Once established, these mappings are saved and synchronized via Complete Compare.So, wrong again.
- Despite statements to the contrary, erwin DM maintains and manages a complete log of model changes at all levels entered by all modelers. As this log is a feature of an erwin DM model, this information is available within the mart.The statements are wrong.
- Unlike er/Studio (and the lack of functionality described in the document), erwin DM can roll-back changes made to any model version saved in a mart – not just a Named (or Marked) version. Additionally, erwin DM has the ability to compare two model versions and to dynamically select metadata from either of the compared versions for inclusion/exclusion from a new version of the model. Although there is no specific branch/merge functionality, use of model versions, complete compare functionality and mart storage provides equivalent capability.Wrong. erwin can do this and more.
- It appears that e-Modelers is not current with erwin DM functionality. For instance, our API supports .NET Basic and not the deprecated capabilities of Visual Basic. Furthermore, many of er/Studio’s macros are used to provide capabilities equivalent to “built-in” erwin DM functionality. erwin DM provides automation capabilities via our API as well as from within our product (e.g., FETs, user-defined reporting capabilities) using our well documented TLX macro language.Wrong as we provide more than what was written.
- Section on Data to Business Process Alignment is misleading. It leverages a comparison of erwin DM to er/Studio’s Business Architect (a separate product with an additional cost) – which is truly a comparison of apples to asparagus. A better comparison, of course, would be their lackluster business process capability and ours when combined with our partner product (“Powered by erwin”) from Casewise. Our no-cost metadata bridges also provide the capability for erwin DM users to integrate their model metadata with best of breed products from vendors across the industry. Misleading, so wrong.
- Despite statements to the contrary, erwin Web Portal provides a full range of flexible advanced search capabilities, metadata tagging, shared bookmarks, user defined comments to facilitate stakeholder collaboration, ability to provide attachments to managed metadata, a web-based data modeling feature (Data Documenter) and the Universal Data Model Harvesting capability which allows the inclusion of non-erwin DM modeled metadata (i.e., er/Studio models, relational database schemas, unstructured “Big Data” data sources). erwin Web Portal models may be viewed in a wide variety of user-selected modeling notations (IE, IDEF1x, UML, etc.).Wrong with respect to erwin Web Portal.
- The list of databases supported (Appendix 3) is incorrect in that most databases left “blank” on the erwin DM side are supported via ODBC for FE and RE. Also, Microsoft SQL Azure is a natively supported database (NO “extension” is required although it is a separately licensed item.) Finally, the er/Studio side of this list is artificially enhanced by listing many databases that are no longer supported by the database vendors themselves. If you’re still running 1992’s SQL Server 4.2 on OS/2 1.3, please feel free to give me a call as I want to hear from you!Old news. And wrong.
To summarize (or TL;DR if the above was too much to read):
We found 14 things wrong with the analysis. In reality, some of these points have multiple facets so it’s more than 14, but that’s a minor point. Let’s just say 14.
Don’t take my word for it, please feel free to check it out for yourself.
As we’re busy developing our new release of erwin DM, we don’t have the time to dig for more, but if you can find something else that we missed, please bring it to my attention and I’ll send you a Starbucks gift card for your effort.
One last, and 15th point from me:
When judging the best solution for your business, you should look towards the leading solution on the market today.
The solution with #1 market share and used by more than 50,000 data management professionals in 60 countries around the world.
The one where the product name is also the company name. Where increasing investment in data management reflects 100% of its focus, not just a side business.
That solution isn’t er/Studio. It’s erwin.
And that’s why there are at least 15 reasons why Idera has got it all wrong.
Thanks to Neil Buchwalter, Danny Sandwell and the rest of the erwin product organization for their efforts here.