We performed a comparison between Informatica Data Archive 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."One of the most valuable features of Informatica Data Archive is its performance."
"The most valuable features of Informatica Data Archive are ease of use, and the flows from one layer to the next are simple to understand."
"Simply the best GUI software for administration is the most valuable aspect for me."
"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."
"The best product for working with Oracle databases for support, checking and loading data."
"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."
"It is very easy to manage all of the objects."
"The schema browser is the most valuable feature. The way it presents the objects in our database."
"The most valuable feature of Toad for Oracle is the fashion browser and the Schema browser. It is very complete."
"Toad has a lot of features that are very useful, fast, and well developed."
"The recovery features could improve in Informatica Data Archive."
"Informatica Data Archive could improve by providing training. Training is one area where we lack, there are not very many trained resources in the market for sales, GPM, proposals, new offerings, or new features that are being added to this solution. It would be really helpful for consultants, like me, to understand the new, cool features these solutions are constantly adding. Training is something, that should be in place."
"Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions."
"There could be a tool for automated SQL query functioning."
"Sometimes it works in some areas, but in others, it doesn't. Like when you copy, you find that it's blank and doesn't copy anything. So, there are some objects that do copy, and sometimes they don't."
"Query optimization is still very resource-intensive."
"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."
"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."
"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."
Informatica Data Archive is ranked 18th in Database Development and Management with 2 reviews while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. Informatica Data Archive is rated 8.6, while Toad for Oracle is rated 8.8. The top reviewer of Informatica Data Archive writes "Easy to understand layer flows, reliable, and excellent support". On the other hand, the top reviewer of Toad for Oracle writes "Advanced query optimization and tuning features ". Informatica Data Archive is most compared with IBM InfoSphere Optim, whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, Oracle Enterprise Manager, DbVisualizer and Redgate SQL Toolbelt. See our Informatica Data Archive 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.