ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
N/A
erwin Data Modeler
Score 10.0 out of 10
N/A
erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.
N/A
Pricing
ER/Studio Data Architect
erwin Data Modeler
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ER/Studio Data Architect
erwin Data Modeler
Free Trial
Yes
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
Optional
Additional Details
Pricing for new customers only, first year maintenance included. Maintenance includes access to technical support and product updates for the defined period of the agreement.
If you have a database environment that gets frequent schema object change requests. erwin Data Modeler is a great tool for version control and release control. Also, it's very useful to communicate between database and application teams.
ER/Studio is great for dividing logical and physical design. A logical model can be used with different physical platforms.
Studio can a useful macro capability that allows me to apply the naming standards across the model with ease and consistency.
ER/Studio does a very good job at comparing the model with the actual database and generating DDL scripts for production deployments.
ER/Studio has an excellent reporting and model publishing capabilities allowing me to produce models in the HTML format and publish them for the team as needed.
Relationships are a bit on the weaker side. Many times I found orphaned relationships that I could not get rid of, or additional columns that were automatically created during the push to the physical model that appear to be due to key constraint bugs
There are a lot of bugs introduced when merging keys. I tend to model 2 tables for example logically, establish the relationship, and then merge the additional key column that is automatically created when establishing the relationship. This sometimes causes downstream issues with the physical model (creating duplicate columns with _1 appended)
Meta-data could be improved. I find it hard to keep descriptions and other meta information clean when copying and pasting from other sources due to formatting tags being introduced on each object (font, size, color, etc.). The attachment feature comes in handy, however I am looking for the ability to cleanly document and map multiple sources to a single target while providing searchability and traceability
erwin Data Modeler allows only 25 entities in a trial version. It really limits you when you want to try out the product before actually deciding to pay for licensing cost. It would be rather helpful if they limit the trial period by days instead.
The UI is pretty good but sometimes the large diagrams are hard to manage. A little improvement in that area would be helpful.
The product is well designed and intuitive to use. The number of buttons and options can look a bit overwhelming initially but they come very handy when you get used to product.
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.
ER Studio Data Architect is a global leader in the data modelling space and most other solutions that have support for third party data models include support for ER Studio Data Architect file formats. Many of the features are a bit more intuitive than the competitors and several of our vendors were already using Data Architect themselves which helped solidify the choice.
I have used few other data modeling tools like Toad Data Modeler and SQL Developer Data Modeler. erwin Data Modeler is easy to use and has additional features that make overall data modeling productive and easy to manage.
Using ER\Studio to create models and eventually the actual database schema allows for a picture that is understandable to the customer and saves significant time writing DDL to create the database objects (tables, indexes, relationships, constraints...)
A nice customer interface tool so you can create a web based interface to the metadata for a particular design.
The tool also supports sub-models so you can break a large project into smaller parts, I find this feature very helpful.
