Coming October 25: PeerSpot Awards will be announced! Learn more
Buyer's Guide
Architecture Management
September 2022
Get our free report covering SAP, IDERA, Microsoft, and other competitors of erwin Data Modeler by Quest. Updated: September 2022.
634,775 professionals have used our research since 2012.

Read reviews of erwin Data Modeler by Quest alternatives and competitors

User at a non-profit with 1,001-5,000 employees
Real User
Top 20
Easy to set up and had no issues with stability, but it's not a very friendly tool, and its database modeling and entity-relationship modeling functions need improvement
Pros and Cons
  • "Sparx Systems Enterprise Architect was easy to set up and it took just twenty minutes."
  • "One room for improvement in Sparx Systems Enterprise Architect is that it's not very friendly. Another room for improvement in the tool is that it doesn't enable you to import the metadata from a database very easily, so reverse engineering of a database was very difficult. Its database modeling and entity-relationship modeling functions need improvement."

What is our primary use case?

My company uses Sparx Systems Enterprise Architect for data modeling, but it's not being used very much because it's not a suitable tool. It's a UML-based toolset, and my company was looking to do entity-relationship modeling, so Sparx Systems Enterprise Architect is not as suitable. My only involvement with Sparx Systems Enterprise Architect was to try and do some data modeling on a MySQL database based on AWS.

How has it helped my organization?

Sparx Systems Enterprise Architect didn't improve my company. I'd rather use Visio to do my diagramming because it's a tool that's easier to use.

What is most valuable?

I didn't find any valuable features in Sparx Systems Enterprise Architect because you cannot use it for re-engineering. I wanted to re-engineer the database, and it was almost impossible. I couldn't find a way.

I didn't have any problems in terms of the stability of Sparx Systems Enterprise Architect. I also found the tool easy to set up.

What needs improvement?

One room for improvement in Sparx Systems Enterprise Architect is that it's not very friendly. Another room for improvement in the tool is that it doesn't enable you to import the metadata from a database very easily, so reverse engineering of a database was very difficult. Its database modeling and entity-relationship modeling functions need improvement.

An additional feature I'd like to see in the next release of Sparx Systems Enterprise Architect is the re-engineering of databases into logical models, if that feature's not yet there, because I haven't checked.

For how long have I used the solution?

I've used Sparx Systems Enterprise Architect on and off for about two years now.

What do I think about the stability of the solution?

The stability of Sparx Systems Enterprise Architect is fine. I've never had any trouble with it breaking down.

What do I think about the scalability of the solution?

I never tried to scale Sparx Systems Enterprise Architect, so I'm unable to comment on its scalability. I'm a single user only.

How are customer service and support?

I never contacted the technical support for Sparx Systems Enterprise Architect.

Which solution did I use previously and why did I switch?

I used ER/Studio and erwin Data Modeler in the past, and I had stopped using them and instead used Sparx Systems Enterprise Architect because I moved companies. erwin Data Modeler and ER/Studio were very expensive tools, and their costs couldn't be justified.

How was the initial setup?

The initial setup for Sparx Systems Enterprise Architect was okay. I downloaded it from the internet, and I had to put a key in. The tool was really easy to set up. On a scale of one to five, the initial setup is a five for me, particularly once I got the key in. Deployment took twenty minutes once I got the key.

What about the implementation team?

Sparx Systems Enterprise Architect was deployed through a reseller.

What was our ROI?

I have not seen ROI from using Sparx Systems Enterprise Architect.

What's my experience with pricing, setup cost, and licensing?

The license for Sparx Systems Enterprise Architect is paid yearly, but I don't handle that area. It's good for its price, so I'm rating it a five out of five, but I'm not using it much. I also don't have information regarding additional costs apart from the standard licensing fees.

Which other solutions did I evaluate?

I didn't evaluate other options because Sparx Systems Enterprise Architect was imposed on me. It was what my company was using when I joined.

What other advice do I have?

I'm not sure about which version of Sparx Systems Enterprise Architect I'm using. My company has a corporate license, and I get updates, but I don't know which version I have at the moment.

I currently have a desktop version of Sparx Systems Enterprise Architect, but there are two or three other people who have the server version, and a repository was supposed to be set up for sharing among myself and the others, but there isn't much success with that. I believe the tool is deployed on-premises, but I don't know what the repository is, because I have a standalone version that runs on my Windows desktop.

There are five users of Sparx Systems Enterprise Architect in my company, and they're into enterprise architecture. For deployment and maintenance of the tool, only one person is required because of the small volume of users. Personally, I don't have plans of increasing usage of Sparx Systems Enterprise Architect because it's not the tool for me. I'm not a person who likes UML, but I do know that my company is looking to build a server-based version of the tool and extend its use. My company is looking at other tools as well, such as LeanIX, Visio, and Lucidchart.

My advice to others looking into using Sparx Systems Enterprise Architect is to make sure it meets all their requirements, and that it has all the capabilities they need. I would recommend looking at some training, because the tool is not very intuitive for data modeling.

My rating for Sparx Systems Enterprise Architect is a five out of ten. It's an average solution, so it's a five for me. It's in the middle. What would make it a ten out of ten for me is if they improve their data modeling capability because I do data modeling and Sparx Systems Enterprise Architect is not a very good data modeling tool.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
Real User
Scales easily and the support is good, but the performance for large models should be improved
Pros and Cons
  • "Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
  • "The model diagram because very clumsy when you save it on the team server and the models are very big."

What is our primary use case?

We maintain all of our enterprise models within ER Studio. This includes our data marts and our local systems. We have multiple people who use the web interface to look at the models.

How has it helped my organization?

Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface. Essentially, it has helped a lot because we have everything in one place

What is most valuable?

The feature that we like best is the model publishing.

The web interface allows everybody to view models that are stored on the team server.

What needs improvement?

The model diagram because very clumsy when you save it on the team server and the models are very big. It becomes difficult to enlarge and difficult to print.

Although they say that it supports concurrent users, we have issues while branching, merging, and performing check-in or check-out. It's not as seamless as it should be.

Now that we are all working from home and our repository is on the cloud servers, we are experiencing issues with performance.

In general, support for big data should be improved.

For how long have I used the solution?

I have been using this product for the last three to four years.

What do I think about the stability of the solution?

I would say that it is 70% stable, with the remaining 30% having room for it to be more stable.

What do I think about the scalability of the solution?

It is scalable, given that we are on the cloud. We are able to scale it up whenever we need, especially with the team server, without any issues.

We have at least 50 users who are actively working on models and using the web interface. We also have at least 30 different users who log in and look at our models, as guests. We haven't added them as users within the repository because they don't need access to it. Rather, they just use the web interface to see the models. These users intermittently come in, perhaps once or twice a week, instead of on a daily basis.

How are customer service and technical support?

The technical support people are pretty good and I would rate them a nine out of ten. Whatever the tool is capable of, they are able to let us know about it.

Which solution did I use previously and why did I switch?

Prior to IDERA, we were using erwin. We switched for several reasons, starting with the fact that we did not find the erwin web interface allowed us to see the models as well. The team server in IDERA is better and erwin did not have a very good method available for working with models concurrently between multiple users. Overall, we found that ER Studio is much better.

How was the initial setup?

Initially, when we started with the 2016 version, we found that there was a learning curve but ER Studio support helped us with it. The 2018 version upgrade was very quick and nice. The 2017 version took longer than the 2018 upgrade, although it was fine.

What other advice do I have?

My advice to anybody who is considering ER Studio is to look at the size of their models. If they have very large models then it may not be suitable because we are having performance issues in this case. On the other hand, if they have midsized models then I think it is pretty good.

Overall, this product is pretty good. It can certainly be better but it still has features that are quite good.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Gil Sabado - PeerSpot reviewer
Senior Data Architect at ManuLife Financial
Real User
Difficult to operate, long process to publish, but scalable
Pros and Cons
  • "The initial setup was very easy."
  • "I have found the solution not easy to use. When publishing you have to download the HTML, make adjustments against the updated HTML, convert it to HTML, then finally paste the HTML. There is not an on-the-fly function available to bypass the step-by-step converting process that other solutions have."

What is our primary use case?

We are using this solution for architecture management.

What needs improvement?

I have found the solution not easy to use. When publishing you have to download the HTML, make adjustments against the updated HTML, convert it to HTML, then finally paste the HTML. There is not an on-the-fly function available to bypass the step-by-step converting process that other solutions have.

The versioning system could be improved. We have to identify the connections and there are lots of limits in certain areas, such as the JDBC driver. I do not have a computer able to do the versioning system because we do not have a database to use. We do not have the budget for that. They should use something, such as GitHub, it would be helpful.

For how long have I used the solution?

I have been using this solution for five years.

What do I think about the stability of the solution?

Sometimes the server goes down and I am not able to use the tools. The solution could be more stable.

What do I think about the scalability of the solution?

The solution scalability is good.

How was the initial setup?

The initial setup was very easy.

Which other solutions did I evaluate?

I have evaluated erwin, it has some enhanced features, such as easy publishing.

What other advice do I have?

We plan to migrate to erwin solution in the near future. I would not recommend it.

I rate SAP PowerDesigner a five out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Architecture Management
September 2022
Get our free report covering SAP, IDERA, Microsoft, and other competitors of erwin Data Modeler by Quest. Updated: September 2022.
634,775 professionals have used our research since 2012.