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."Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"We are able to document the data lineage and data flows of our data from one system to another."
"The tool is simple to use."
"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."
"We use the solution to create data models which describe our company's data architecture"
"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."
"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."
"The reverse engineering is the most important feature."
"With Oracle GoldenGate, you can easily sync the tables and put them into the ODS database."
"I like that the product transforms data and provides real-time applications."
"The CDC feature is interesting."
"GoldenGate enables us to merge and transform data from various sources in real time. It's a powerful tool that can read and load most data sources."
"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."
"Oracle GoldenGate features work fine, which is what I like about it. I also like that it's scalable, easy to set up, and has good technical support."
"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."
"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"The screens are a bit outdated. They could use a new look and feel."
"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 number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"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."
"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."
"A clean and user-friendly graphical interface based on common design principles would be beneficial."
"Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one."
"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."
"Some issues regarding stability need to be resolved."
"The solution's performance needs improvement."
"The product lacks some features and it's expensive."
"Lacks the ability to become a full-scale ETL tool."
"There are a lot of bugs in the solution."
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.