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 interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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 tool is simple to use."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"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."
"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."
"They've recently improved the ease of implementation."
"The replication of the data table is one of the best features."
"Since the world is going towards open source, the solution's heterogeneous data migration feature is very useful."
"This is a powerful solution provided by one of the most respected companies in the computer industry."
"The CDC feature is interesting."
"You can use Oracle GoldenGate as a DR for your system."
"The most valuable feature is data replication capability."
"Data migration is the most valuable feature of Oracle GoldenGate."
"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."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"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."
"When building the relationships there should be a little more flexibility."
"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"
"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."
"The screens are a bit outdated. They could use a new look and feel."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"The solution's performance needs improvement."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"I find the user interface to be difficult for non-technical people."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"The GoldenGate license is very costly."
"The tool's connections are disconnected at times. The tool needs to integrate other databases."
"In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting."
"Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time."
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.