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."The most valuable features are... those that enable me to represent the database to the development community and the business users."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"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 data modeling and reverse engineering features are most important to us."
"Straightforward setup."
"The tool is simple to use."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"The reverse engineering is the most important feature."
"It is quite scalable."
"It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."
"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."
"When we are replicating data between similar databases then it is straightforward."
"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."
"I like that the product transforms data and provides real-time applications."
"GoldenGate can connect and collect data from multiple sources, such as SQL Server."
"The most valuable feature is data replication capability."
"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."
"What needs the most improvement are semantic lineage and usability."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"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 model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"I would like to see the interface more graphical and easier to use."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner."
"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."
"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
"The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging."
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.