We performed a comparison between IDERA ER/Studio and Toad for Oracle 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."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."
"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."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"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."
"We use the solution to create data models which describe our company's data architecture"
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"We are able to document the data lineage and data flows of our data from one system to another."
"Toad has a lot of features that are very useful, fast, and well developed."
"The schema browser is the most valuable feature. The way it presents the objects in our database."
"The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development."
"The best product for working with Oracle databases for support, checking and loading data."
"Simply the best GUI software for administration is the most valuable aspect for me."
"Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries."
"I like that it's very flexible and helpful in query accuracy, analysis, and data visualization. I also like the move facilities available in Toad for Oracle. Overall, I think it's a fantastic product for analyzing SQL queries and managing all kinds of queries."
"I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"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"
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"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."
"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."
"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 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."
"It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue."
"I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it."
"Toad for Oracle could improve code completion, it is very slow."
"An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections."
"The way the dialog boxes appear can be improved."
"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."
"There could be a tool for automated SQL query functioning."
"Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."
IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. IDERA ER/Studio is rated 8.4, while Toad for Oracle is rated 8.8. 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 Toad for Oracle writes "Advanced query optimization and tuning features ". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest, whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, Oracle Enterprise Manager, DbVisualizer and Redgate SQL Toolbelt. See our IDERA ER/Studio vs. Toad for Oracle 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.