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."It does the job."
"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."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"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."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"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."
"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."
"This is a powerful solution provided by one of the most respected companies in the computer industry."
"Oracle GoldenGate helps to select and target specific tables for replication. Any changes or operations on those tables are immediately reflected in the source and target environments."
"What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."
"The product is reliable for data integrity."
"The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios."
"One feature that stands out for me is the data center capability."
"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."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"The only thing I had an issue with was licensing, and the support was very good."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"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."
"I would like to see the interface more graphical and easier to use."
"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
"Oracle GoldenGate could improve the price."
"It would be better for Oracle Golden Gate Studio GUI to include other licensed products (i.e. Veridata or others)."
"The solution's performance needs improvement."
"There are a lot of bugs in the solution."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 2 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 27 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 "Great for migrating data from Oracle platforms and is extremely scalable". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, erwin Evolve by Quest 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.