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 use the solution to create data models which describe our company's data architecture"
"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 have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"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 does the job."
"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."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"The product's initial setup phase was very simple."
"When we are replicating data between similar databases then it is straightforward."
"Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
"One feature that stands out for me is the data center capability."
"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."
"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."
"Data migration is the most valuable feature of Oracle GoldenGate."
"The solution's existing SaaS platform for data integration gives us an edge."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"What needs the most improvement are semantic lineage and usability."
"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."
"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"
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"Some issues regarding stability need to be resolved."
"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."
"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."
"You cannot put everything in Golden Gate for the license and large models."
"GoldenGate is expensive. It's costly because this solution is unique in our market. The GoldenGate Cloud Service is cheaper than the on-premise solution."
"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."
"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."
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, 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.