What is our primary use case?
We are using this solution for data modeling, data warehouses. We build the data models in the tool.
We are creating models, and working on workflows for creating the data models. There will be other teams that will change or modify them.
We are looking to have a process where other teams can change the data models and then their changes will be reviewed by the owners. Those are the workflows we are looking to link by using Sparx.
What is most valuable?
It is a very rich tool in terms of the functionality and the types of diagrams that you can create in this tool.
It gives us many options to create many other types of diagrams.
What needs improvement?
For data modeling, it is not very mature when comparing with other data modeling tools.
In terms of the workflows, we were initially thinking of having something automated where you have the options to check-in and check-out your data models. This would mean that you can get your data modeling changes reviewed by some of the team members.
The option to check-in and check-out option is not available in this tool. We are doing the steps manually to run the workflow that we defined.
Even with the changes that the other team members will make, the owners of these respective areas will have to manually identify those changes and then merge them back to the enterprise models. That is what is lacking with this solution, that we have seen so far.
In the next release, I would like to see an automated way to check-in and check-out your data models and with the review process, where multiple people can make changes to a model, and with the workflow, everything will be automated where the data models can request someone to review the modifications. This would be everything that is needed in the next release.
For how long have I used the solution?
We just started using this tool a couple of months ago.
How are customer service and technical support?
So far, the technical support has been great.
Support is a part of our license agreement.
They have helped us with setting up some of the initial support and workflows and that was very good.
Which solution did I use previously and why did I switch?
Previously, I worked with IBM data modeling, called Data Architect tool with a different company. My experience with Erwin was brief but not very extensive.
When I changed jobs, we were evaluating other data modeling tools and finally chose the Sparx Enterprise Architect.
How was the initial setup?
I wasn't a part of the initial setup.
What about the implementation team?
We had the help of the Sparx Enterprise consultants to set up this solution.
I am using Sparx as a client or a user of the tool, and as a user, I had to install the Sparx client on my machine. That was simple enough.
The configuration on these client machines is easy.
What's my experience with pricing, setup cost, and licensing?
The licensing is not as expensive as some of the other data modeling tools such as Erwin.
What other advice do I have?
Other than the manual steps we have to take, the product is pretty fancy and gives you a lot of options. I would rate this solution a seven out of ten.