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 have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"We are able to document the data lineage and data flows of our data from one system to another."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"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."
"The data modeling and reverse engineering features are most important to us."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"Straightforward setup."
"It does the job."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"It works best with Oracle."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."
"For small databases, GoldenGate handles the migration well."
"This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"The solution is useful for data transformation."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"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 only thing I had an issue with was licensing, and the support was very good."
"Lacks the ability to become a full-scale ETL tool."
"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."
"In some cases, expectations were not met, especially when specific tables were expected to be disabled, and changes were anticipated in the target environment. We had to take backups from the source and refresh the address to address this."
"I would like to see the interface more graphical and easier to use."
"The solution's performance needs improvement."
"The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging."
"There are a lot of bugs in the solution."
"The product lacks some features and it's expensive."
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.