What is our primary use case?
My use case for erwin Data Modeler is to identify the objects and keep the business details and object details into one pictorial diagram. Whenever a business wants to understand their operations, it is easy to walk through them with the PDF we have generated, which includes the links between the objects and functionality of the business and description of each column with business context. This tool is helpful for storing all this information.
What is most valuable?
My favorite feature of erwin Data Modeler is that we can export and import tables directly from the databases. It is easy to map from table to table and column to column.
In managing data across different environments, we are not dealing with the data in erwin Data Modeler. We use it to describe the relationships between tables and define how the data flows from one environment to another. For example, if we talk about a customer table, we define how many columns should be there and the data types and characteristics of that particular column and table. While we can store structure information at the mapping level, we are not managing data within this tool.
What needs improvement?
I would rate the visualization feature in erwin Data Modeler a six out of ten because the visualization is somewhat poor and some of the features are not user-friendly. You need to spend more time to make it a framework. There are areas where erwin Data Modeler can improve, such as scrolling and zooming in and out to see any particular columns. The visualization is average to above average, but not great.
Erwin Data Modeler could improve in areas such as the interface, as there are features like copy and paste, creating duplicates, and the visualization elements and toolbars which feel quite old. The user interface resembles a 1998 Windows structure, so that can be enhanced.
What do I think about the stability of the solution?
I have experienced issues with stability in erwin Data Modeler because it does not have an auto-save feature. Whenever I do something and it crashes, I have to start from scratch. There is no automation such as in Word or Excel, where documents auto-save, and if something happens, they start from where they got saved. This lack of an auto-save methodology can be improved so that if a system crash occurs, work can be saved and rework can be avoided.
What do I think about the scalability of the solution?
Scalability in erwin Data Modeler is good as it connects with multiple databases to pull existing table structures. I believe we can read the table structure from any type of database.
How are customer service and support?
I have not contacted the technical support or customer support of erwin Data Modeler. Every product I have worked with captures business frameworks and detailed information. We have not encountered situations requiring customer care support. Erwin Data Modeler requirements function at a standard level, and when we seek something higher, we connect with the team for support.
How would you rate customer service and support?
How was the initial setup?
The initial deployment of erwin Data Modeler was easy. It is not overly complex. Those who can understand how Windows functions can easily complete the setup.
What's my experience with pricing, setup cost, and licensing?
Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations looking to store business information and relationship values may consider the pricing. I have never thought about that because we never tried to buy it. It is typically for those who need this tool on an enterprise level.
Which other solutions did I evaluate?
I have not used any alternatives to erwin Data Modeler extensively. I have used Data Vault, but it follows a completely different methodology and does not compare to this tool.
What other advice do I have?
I do not see any integration capabilities in erwin Data Modeler with any projects I have worked on. There are no particular environments such as development, testing, and production. Since there is no end product to place in production, we handle only one environment. The main purpose of integration would be if any output criteria exist. However, the output products are essentially for documentation purposes. So far, in the projects I have worked on, there has been no integration involved with this tool. My focus has been on documentation, which is metadata about the business strategy.
I do not recall how long it took to deploy erwin Data Modeler because there is no deployment involved in my projects. As mentioned, there is no end product for development and production activities. We are merely keeping the business information, and the application of this product serves that purpose. The end result is a PDF representing business data flow.
I am a user of erwin Data Modeler, and I do not have any partnership with them. Partnerships typically involve enterprise levels, but I am a customer. Whenever I start working with a client, they show me the tool, and I begin using it. I would rate my overall experience with erwin Data Modeler an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.