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."Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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 tool is simple to use."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"Straightforward setup."
"The reverse engineering is the most important feature."
"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"The CDC feature is interesting."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"The product's initial setup phase was very simple."
"The replication of the data table is one of the best features."
"The most valuable feature is data replication capability."
"We use the tool to pull on-prem data."
"I am impressed with the tool's possibility of integrating different systems in a unified place."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"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"
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"What needs the most improvement are semantic lineage and usability."
"We would always like to see Repository performance improve, checking in and checking out."
"When building the relationships there should be a little more flexibility."
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
"We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
"Lacks the ability to become a full-scale ETL tool."
"I find the user interface to be difficult for non-technical people."
"There are a lot of bugs in the solution."
"Microservices Architecture is not user-friendly."
"You cannot put everything in Golden Gate for the license and large models."
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.