Navicat Premium vs Toad for Oracle

• Access via standard html
• Alert notification

Read full review

• Toad is a de-facto standard tool for data developers and analysts. Generally speaking it provides almost every function needed to manage data in EDW with great performance and stability.
• The nature of clinical data is big-sized: one table may have billions of rows. Toad provides critical functions to manage SQLs, e.g. Top SQL that can monitor and manage SQLs using CPU power and network bandwidth, so that EDW administrator can optimize ETL operations in the best efficiency.
• Many of our data analysts are not computer science backgrounded (having clinical / nursing background). Toad provides great auditing tools such as Tuning Lab or SQL Scanner, so that data analysts can train themselves with guidance of the tool.

Read full review

• Navicat Premium's documentation can be hit-or-miss, as there are several versions available, and it's not always clear which documentation is current for the version at hand.
• Navicat Premium's query building interface is not as easy to use or feature-rich as standard IDE and text editor tools, and I've had some issues in the most recent release build with queries auto-running in the middle of making edits, causing a lack of responsiveness in the inbuilt editor -- however, Navicat offers users the ability to edit queries via an external editor, which mitigates these issues to some degree.
• In the data browser view, paged data navigation sometimes behaves unexpectedly or fails to work whatsoever, requiring a session restart to correct.
• The process of saving a data export file is cumbersome, requiring navigation through several windows, and I believe it could be significantly streamlined to improve user experience.

Read full review

• The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
• It seems to be updated too often. I get notifications very frequently about new versions being available.
• The export function is difficult to use.

Read full review

• Similar features to OEM provided very easy to use, out-of-the-box functionality.
• No large infrastructure changes were needed to deploy and install.

Read full review

• Quick and easy query development helps reduce man-hours in a project which converts to real dollars.
• Query analysis and tuning result in low database overhead and low latency, thus translating into real dollars because a system can thus handle more requests from customers.
• Ease of use makes it easy to deploy greenhorns in projects with minimal training, thus helping save money. Otherwise menial and simple jobs would have required experienced DBAs.

Read full review