TIBCO Business Studio vs erwin Data Modeler by Quest comparison

"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."

"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."

"We can create mappings in erwin and possibly data dictionaries."

"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."

"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."

"The data lineage feature is very valuable."

"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."

"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."

"The setup cost is definitely reasonable."

"The product's initial setup phase is straightforward."

"The setup cost is definitely reasonable."

"The solution's model mark could be better because it crashes sometimes."

"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."

"One of the best aspects of the tool is its reverse engineering capability."

"As someone who has used it for a long time, I have seen stability vary from version to version."

"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."

"The interface must be improved."

"This is a very complex product."

"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."

"The interface is actually quite confusing."

"An artificial intelligence feature that evaluates the quality of the code developed with one click would definitely be good."

"An artificial intelligence feature that evaluates the quality of the code developed with one click would definitely be good."

"Pricing is very high compared to any other product."

"The solution is expensive."

"Likewise, the solution is a little pricey."

"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."

"There are no costs in addition to the standard licensing fees."

"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."

"The pricing of the solution is cheap. I rate the pricing a five out of ten."

"There are two license options and the pricing is reasonable."

"For my company, the tool costs about 2,0,000 Euros for three years...If one is bad and ten is good, I rate the price as one out of ten."