TrustRadius
https://dudodiprj2sv7.cloudfront.net/product-logos/XG/KK/6JBUVTXABML4.JPEGBest Data Modeling ToolWe are using erwin Data Modeler for initial design, development and deployment phases. We use it to design ER diagrams for our new databases or incorporate change requests into existing. We then forward engineer deployment scripts for erwin directly and deploy it to various database environments. This has helped us version control and release control in our database environments. It is also easier to discuss with functional team by presenting them with ER diagram block instead of talking to them in database language.,Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database. Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made. Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.,For large models, it gets tedious to print the diagram in a single pdf. I have to often make adjustment and if i use the fit model feature, it kind of changes the alignment of entities in my ER diagram. Erwin may let us make pdf of the model as is. I have used reverse engineering using for Oracle schemas. It will be very good if it supports reverse engineering for more vendors, so i can use erwin data modeler for database conversion activities too.,9,erwin Data Modeler had been a great tool for our database development and application DBA teams. The thorough data modeling and release control helps us to back trace any issues which are pointed to us at a later stage in the development cycle. Initially, some of the team members saw it as an extra effort to maintain data models while they can simply create scripts without models. But overtime, people have realized how it avoids problems and discrepancies over time.,Toad Data Point,Google Authenticator, Oracle Cloud Infrastructure Database, Cisco Webex Teams (formerly Cisco Spark),No,Price Product Features Product Usability Product Reputation Prior Experience with the Product,I don't really think I would change anything in the selection process. Well, would like to discuss a better corporate discount though :),Reverse Engineering: It sounds like a big term, but creating models from SQL scripts is super easy. Comparing two schema SQLs. This highlights the differences and helps you incorporate the differences in your model.,I haven't really had experience of anything to be classified as Cubersome while using this product.,9Best data modeling, database version control, and deployment managementWe are a big organization that supports multiple applications. We use erwin Data Modeler for database model design before it can actually make to the database. We build ER diagrams out of requirement documents and then use these ER diagrams to discuss in meetings with functional and DBA teams. Once the design is approved, we further use erwin Data Modeler to make both logical and physical data models, include triggers and constraints in the model, and forward engineer deployment scripts for the DBA team. erwin Data Modeler has greatly helped us maintain a SDLC for database changes and version control.,erwin Data Modeler helps generate deployment scripts for database deployments without the need to worry about programming syntax. It helps you compare different models pretty easily and identify any discrepancies induced due to human error during deployment cycles. I have a great experience of using erwin Data Modeler to generate database models straight out of database SQL file. This feature is called reverse engineering in erwin Data Modeler world.,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.,9,It has greatly improved version control of our database design and deployment part of SDLC. We have improved our productivity and reduced reworks caused by deployment errors. We have a way to track each database change back to requirements where the database change had originally originated.,,Oracle Linux, Red Hat Enterprise Linux (RHEL), Suse Linux, Veeam Backup & Replication, Oracle GoldenGate, ClickUp, Asana, Microsoft Office 365, HPE StoreOnce, HPE 3PAR StoreServ Storage, Red Hat JBoss Enterprise Application Platform, Oracle Database, Oracle Database 12c, Oracle WebLogic Application Server, Oracle Enterprise Manager Cloud Control, Veeam ONE, Control-M, Toad for Oracle, SQL Developer, Adobe Flash, Adobe Photoshop, Adobe Illustrator CC,No,Price Product Features Product Usability Product Reputation Prior Experience with the Product Vendor Reputation Existing Relationship with the Vendor Third-party Reviews,We are very pleased with the product and our evaluation process. I don't think we need to change something in that context.,Creating ER Diagrams. Generating SQL scripts from the data models. Comparing data model with another model or SQL script.,9
Windows, Linux, Mac
erwin Data Modeler
11 Ratings
Score 8.7 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

erwin Data Modeler Reviews

erwin Data Modeler
11 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101
Show Filters 
Hide Filters 
Filter 11 vetted erwin Data Modeler reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-2 of 2)

  Vendors can't alter or remove reviews. Here's why.
Ravinder Gupta profile photo
January 25, 2019

erwin Data Modeler Review: "Best Data Modeling Tool"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using erwin Data Modeler for initial design, development and deployment phases. We use it to design ER diagrams for our new databases or incorporate change requests into existing. We then forward engineer deployment scripts for erwin directly and deploy it to various database environments. This has helped us version control and release control in our database environments. It is also easier to discuss with functional team by presenting them with ER diagram block instead of talking to them in database language.
  • Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
  • Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
  • Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
  • For large models, it gets tedious to print the diagram in a single pdf. I have to often make adjustment and if i use the fit model feature, it kind of changes the alignment of entities in my ER diagram. Erwin may let us make pdf of the model as is.
  • I have used reverse engineering using for Oracle schemas. It will be very good if it supports reverse engineering for more vendors, so i can use erwin data modeler for database conversion activities too.
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.
Read Ravinder Gupta's full review
No photo available
January 31, 2019

erwin Data Modeler Review: "Best data modeling, database version control, and deployment management"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We are a big organization that supports multiple applications. We use erwin Data Modeler for database model design before it can actually make to the database.
We build ER diagrams out of requirement documents and then use these ER diagrams to discuss in meetings with functional and DBA teams. Once the design is approved, we further use erwin Data Modeler to make both logical and physical data models, include triggers and constraints in the model, and forward engineer deployment scripts for the DBA team.
erwin Data Modeler has greatly helped us maintain a SDLC for database changes and version control.
  • erwin Data Modeler helps generate deployment scripts for database deployments without the need to worry about programming syntax.
  • It helps you compare different models pretty easily and identify any discrepancies induced due to human error during deployment cycles.
  • I have a great experience of using erwin Data Modeler to generate database models straight out of database SQL file. This feature is called reverse engineering in erwin Data Modeler world.
  • 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.
I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
Read this authenticated review

erwin Data Modeler Scorecard Summary

Feature Scorecard Summary

Collection of first-party data (1)
9
Collection of third-party data (1)
9
Access to Third-party Data Providers (1)
9
Audience taxonomy (2)
8.0
Tag Management (2)
8.0
Data Analysis Dashboard (2)
8.5
Data Transfer (2)
8.5
DSP integration (1)
7
Campaign Analytics (2)
7.5
Audience Analytics (2)
7.0

About erwin Data Modeler

erwin provides a data management platform for managing both structured and unstructured data types. It is an open-standards data hub designed to allow customers to manage their data wherever it might be stored (in-house relational databases, or public or private cloud). The platform handles big data governance, control, customization and web-based publishing and reporting.

The vendor says erwin Data Modeler is used by more than 50,000 professionals in 60+ countries to get big results from their enterprise data initiatives. Additionally, the vendor says their solution is the #1 choice in virtually every industry, from government and healthcare to retail and finance.

erwin Data Modeler Screenshots

erwin Data Modeler Competitors

SAP PowerDesigner, Idera ER/Studio, Toad Data Modeler

Pricing

Has featureFree Trial Available?Yes
Does not have featureFree or Freemium Version Available?No
Has featurePremium Consulting/Integration Services Available?Yes
Entry-level set up fee?Optional

erwin Data Modeler Support Options

 Free VersionPaid Version
Phone
Email
Forum/Community
FAQ/Knowledgebase
Video Tutorials / Webinar

erwin Data Modeler Technical Details

Deployment Types:On-premise, SaaS
Operating Systems: Windows, Linux, Mac
Mobile Application:No