We performed a comparison between IBM InfoSphere Optim and IDERA ER/Studio based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I feel the solution to be a bit faster than the traditional methods, which makes it easy to customize."
"We like that we can easily restore the database with just a few clicks. The database is linked as well."
"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"The data modeling and reverse engineering features are most important to us."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"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."
"Straightforward setup."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"While the solution is very supportive of Db2, it is not so friendly when it comes to IMS databases."
"We're looking for a solution that can be implemented on AWS. IBM InfoSphere Optim can be implemented on AWS, but it costs more than double what we're currently paying. So, it's not really of good value for us."
"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."
"We would always like to see Repository performance improve, checking in and checking out."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"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."
IBM InfoSphere Optim is ranked 17th in Database Development and Management with 3 reviews while IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews. IBM InfoSphere Optim is rated 6.6, while IDERA ER/Studio is rated 8.4. The top reviewer of IBM InfoSphere Optim writes "Can easily restore the database, but the cost needs to be reduced". On the other hand, the top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". IBM InfoSphere Optim is most compared with Solix Enterprise Data Management, Informatica Data Archive, Informatica Persistent Data Masking and Oracle Enterprise Manager, whereas 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. See our IBM InfoSphere Optim vs. IDERA ER/Studio report.
See our list of best Database Development and Management vendors.
We monitor all Database Development and 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.