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 are able to document the data lineage and data flows of our data from one system to another."
"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."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"The data modeling and reverse engineering features are most important to us."
"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."
"Data migration is the most valuable feature of Oracle GoldenGate."
"The solution is useful for data transformation."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"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."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."
"You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."
"What I like most about Oracle GoldenGate is that it supports cross-platform migrations. For example, Oracle GoldenGate could pump data from one type of system to another such as the data from Oracle DB to SQL Db2."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The only thing I had an issue with was licensing, and the support was very good."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"What needs the most improvement are semantic lineage and usability."
"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."
"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 product lacks some features and it's expensive."
"In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting."
"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."
"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."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
"I find the user interface to be difficult for non-technical people."
"Technical support for Oracle products needs to be more efficient (at least locally in Egypt)."
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 erwin Evolve by Quest, 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.