We performed a comparison between IDERA ER/Studio and Oracle GoldenGate 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 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."
"The reverse engineering is the most important feature."
"The data modeling and reverse engineering features are most important to us."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We use the solution to create data models which describe our company's data architecture"
"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."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"The CDC feature is interesting."
"You can use Oracle GoldenGate as a DR for your system."
"It is quite scalable."
"The product is reliable for data integrity."
"It's very simple to configure, it's very simple to implement. In addition, the ability it has to capture data and transmit it with incredible speed is better than any of the product out there. It's extremely powerful."
"When we are replicating data between similar databases then it is straightforward."
"I am impressed with the tool's possibility of integrating different systems in a unified place."
"GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"The screens are a bit outdated. They could use a new look and feel."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"What needs the most improvement are semantic lineage and usability."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"We would always like to see Repository performance improve, checking in and checking out."
"This solution needs more precise documentation."
"The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it."
"The solution, in general, should be easier to use, with less need to perform workarounds within the system."
"The GoldenGate license is very costly."
"IBM CDC has one central control while Oracle GoldenGate has two controls. In IBM CDC we can do all things in frontend. The solution needs to incorporate a feature where we can connect it to a standby database."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"The process of transforming the data between two different databases is inefficient and needs to be improved."
"There are a lot of bugs in the solution."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 47 reviews. IDERA ER/Studio is rated 8.4, while Oracle GoldenGate is rated 8.2. 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 Oracle GoldenGate writes "Performs real-time replication without data loss, but we cannot do much automation". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and Aqua Data Studio, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and Oracle Data Integrator (ODI).
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.