We performed a comparison between IDERA ER/Studio and OpenText ProVision based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."We are able to document the data lineage and data flows of our data from one system to another."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"Straightforward setup."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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 reverse engineering is the most important feature."
"OpenText ProVision's best feature is the capability to attach a variety of attributes and extract and analyze that information."
"The stability of the product is very good."
"All the features come as part of a standard license."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"This solution needs more precise documentation."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"The only thing I had an issue with was licensing, and the support was very good."
"Lacks the ability to have your own in-house developments."
"Integrating with or interfacing with other tools like data management tools would be very helpful."
"OpenText ProVision's collaboration management is quite complicated and difficult to use."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while OpenText ProVision is ranked 24th in Enterprise Architecture Management with 3 reviews. IDERA ER/Studio is rated 8.4, while OpenText ProVision is rated 6.4. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of OpenText ProVision writes "Good attribute attachment but problems with collaboration". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas OpenText ProVision is most compared with Visio, ARIS BPA, SAP Signavio Process Manager and Sparx Systems Enterprise Architect.
See our list of best Enterprise Architecture Management vendors.
We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.