Re: Crack Erwin Data Modeler Price
Jalisa Landgren
One of the most compelling use cases for erwin Data Modeler lies in itsconnection to the increasingly important and evolving realm of datagovernance. erwin Data Modeler Workgroup Edition provides a controlledcentral repository of data definitions and visibility into where and howproperly defined data should be used.
erwin Data Modeler by Quest is an award-winning graphical data modeling solution helping leading organizations worldwide find, visualize, design, deploy and standardize high-quality enterprise data assets. As the gold standard for more than 30 years, erwin Data Modeler has helped thousands of organizations reduce costs and enable faster time to value when designing, developing and delivering the data sources their businesses rely on each day. By automating and standardizing model design tasks, erwin fuels business alignment, ensures data integrity, and simplifies downstream integration. Visualization of database schema, market-leading model comparison capabilities, and integration with semantic and governance detail ensure and accelerate data source understanding.
erwin Data Modeler provides cross-platform DBMS support with native connectivity, schema modeling, database design, migration and engineering support for Microsoft Azure SQL Database and Azure Synapse. Speed the adoption of the Azure Synapse with robust design, documentation and CDM driven semantic integration for data lakes, data warehouses and other applications, collaborative modeling governance and the automated transformation of legacy models to deployable Azure Synapse models.
We are trying to build a enterprise data model for commercial product which acts as a reference point for 7 different databases. It helps us analyze business requirement and the flow of data between multiple systems. I like the workgroup version of Erwin as it lets you work with multiple people on your team at the same time with the version control options and check-in and check-out option.
Its a great tool for generating ddl scripts which can directly be used to deploy to databases. Also can be used to compare multiple model and merge the files in multiple format like you can compare Erwin files, DDL files etc. It gives you lot of options for reporting like you can choose report designer to create reports on any level like at subject area level or entity level etc.I really like the reverse engineer option of Erwin which can help you generate data model from existing database.
I think the ability to generate larger model reports is little harder as it takes lot of time and some times the application crashes with which you might loose certain changes. For larger model to get the reports get little tough as the tool becomes slow and some improvement in that area would really help.
My review of ErWin might be a bit biased. Fresh out of University doing data modelling, designing and implementing Databases, ErWin was a Gift. My employer sent me on some courses. I think it was Computer Associates (CA) which was running the training that time. The training was so good, when I returned to work, I hit the ground running.
The Erwin data modeler is well suited for describing multiple levels of data abstractions. This includes modeling data layers from the logical layers of entity relationships down to the physical levels. Its ability to interact with other popular configuration management software allows versioning of the models to be tracked properly.
The most I like about Erwin Data Model is that its very easy to use to model a new data base, to modify a data base model already created and you can conect to a data base and generate a data model using reverse engineerig.
We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money.
We didn't go for a subscription. It was a one-time fee. I don't understand who does subscriptions on such solutions. PowerDesigner comes with yearly subscriptions, and I can't understand how that is possible. Who in the world keeps on changing the database engine? Once you have such an application, you cannot just upgrade it like your phone. So, I cannot understand how they're pushing this. erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee.
It has increased in price a fair amount over the years. It has always been expensive because it is a comprehensive product, and presumably, they have to do a tremendous amount of testing to make sure that everything works. It has always been dear because usually, a very specific target audience of data architects has the need for modelers, and not everyone in the organization would need to get a copy of it. Only people who are actually working in the database space need it. So, it has always been a very specialized piece of software, and it has been priced accordingly. I don't specifically know what we're paying now. 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. In the mid-2000s, it was something like 1,200 AUD a seat. 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. 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. That's what Microsoft does. They package a few things so that you have something, but if you want this extra stuff that has enterprise features, such as they talk to each other and have great bits and pieces, you have to pay more. I don't think there are any additional costs. It is per product, and there are different license levels.
We always had a problem keeping track of all the licenses. All of a sudden you might get a message that your license expired and you didn't know, and it happens at different times. At GM Finance, they engaged Sandhill to help us manage it. I was less involved because of the use of Sandhill, who was very helpful when we had trouble with our license. I remember you had to put in these long string of characters and be very careful that you didn't cut and paste it in an email, but that you generated it. It was so sensitive and really difficult until the upgrades. if there was a serious problem, then it was usually around the licensing, where there was some glitch in the licensing. Then, we would call Sandhill who would help us out with it. That's something where we had to invoke a third-party for any technical difficulties. I wish it wasn't so expensive. 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 would like to keep my ability to use the tool. 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. $3,000 is a big hit. I think you buy a block of users because I know the company always wanted to manage the number of licenses.
I don't think that the pricing for my office is horrible. However, from my home, there's absolutely no way I could afford erwin on my own as far as doing my own work. There have been discussions between my office and the actual company that I work for and trying to decide on who would actually pay the bill. I'm the person stuck in the middle saying that I can't do my work here and luckily, I've been able to get one or two extensions on my free trial license from erwin. However, I'm afraid that I won't be able to get my company to pay for it and fairly soon the trial license will end up expiring on me. I decided to build physical only but later on that kind of bit me and so I will start building logical first and then the physical. It would be nice to be able to build out my own set of tables and maybe a Model Mart type of situation but I don't see me being able to afford a copy at home for myself. I won't be able to continue keeping a trial copy forever and until COVID is over.
I don't deal with pricing or licensing here. I know that you can get a per-seat license. You can get concurrent licenses. To me, if you're a full-time modeler, you need a per-seat license. If you're a developer or a data steward, you use it a couple of times a day, maybe a couple of times a week, you can have concurrent licenses so that a group of five people will share one license. If someone's using it you can't, but if it's free then you can go ahead and use it, or you can lock it, or whatever. There are different ways of licensing it.
I think that the pricing is reasonable. It has called Concurrent licensing, where you can have a number of people share an erwin license. I think that that pricing is a little bit high, but that is a personal opinion.
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. This would not be to make any changes, but just to visually look at what exists. 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.
We pay maintenance on a yearly basis, and it's a low cost. There are no additional costs or transactional fees. The accuracy and speed of the solution in transforming complex designs into well-aligned data sources make the cost of the tool worth it.
7fc3f7cf58