Dell VMAX vs. Kaminario K2 (discontinued) vs. Toad Database Developer Tools

Dell EMC VMAX All-Flash Storage is a very powerful storage that easily manages huge data transactions with high IO processing speed. This Storage is well suited for critical production environments because response times are much better. This storage enables direct data backup. It's always up and running during updates because it creates a redundant connection from the controller.

Incentivized

K2 works well in our mixed-use virtual environment. I would not hesitate to place any workload on K2, it has always performed well. We use fiber-channel connectivity as it replaced our large legacy storage array, replacing one rack of spinning disks with 4U of flash.

Incentivized

Toad for Oracle is very well suited for all Oracle implementations, be it single instance or RAC. It is best suited for use of Oracle DBA, Developer and Database Engineers. I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.

Incentivized

• It creates a fully redundant connection from multiple controllers that are always up even during updates.
• Once setup there is little to no adjustments that need to be made to the storage array. All that's needed is volume updates.

Incentivized

• Great performance
• Great support
• Super-simple to use

Incentivized

• 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.

Incentivized

• Initial configuration are bit difficult need some experience resource to manage it.
• We faced issue with vendor support during major impact.

Incentivized

• Not well known, so third-party support is lacking
• Data reduction is good, but not as good as expected (actual 2.7:1)

Incentivized

• The power and control it gives is at the same time kind of a negative thing. There's too many options available, even when you don't need them. For simple database operations it's sometimes easier to just use SQL Developer since navigation is way more intuitive and easy.
• Related with the above: there is a steep learning curve. However, since this is the main tool for any Oracle developer, this is not that much of a problem.
• If I remember well, Toad used to be free, some 20 years ago. Or at least had a free version. It would be nice to have a free version. The dedicated Oracle developers and DBA's won't use the free version, but all the rest of us developers might use it instead of SQL Developer. It would make communications between everybody somewhat easier.

Incentivized

It is the preferred tool for our organization.

Incentivized

I give is an 8 because nothing is a 10 and there is always room for improvement. I believe the user who is not as technologically inclined would be better suited with an easier way to identify the options for setting the layout up for Toad's GUI. To some it is very cumbersome and confusing.

Incentivized

The best part about this array is that once you have it configured it is pretty much done. There is little to no other configurations to be done other than normal volume adjustments. Support is great as they understand this array very well. The updates are very hands-off and are done solely by support. You contact them and then there are no other changes done on the end-user's side.

Incentivized

I give the overall support for Toad for Oracle a 10/10. This is because whenever there has been an issue with this software, our team has got an immediate response. The same can not be said for similar software. The most recent example of this is when we needed to renew our licenses. Some employees were unable to log in to code with the given license key. Support was able to resolve the issue quickly.

Incentivized

Incentivized

We performed a bake-off with K2 and one other vendor and they performed identically. K2 pricing was aggressive, performance was great, and it offered the features that we needed at a price that we could afford

Incentivized

Toad is much better than Tableau query writer. Tableau is not intuitive and requires knowledge of proprietary database language to fully implement. Tableau does not perform as quickly and accurately as Toad. Toad is very easy and slim to install. Additional hardware is often required to run Tableau smoothly. Support for Tableau is even more expensive than Toad support.

Incentivized

• Dell EMC VMAX All Flash Storage provides the hybrid cloud solution
• Dell EMC VMAX All Flash Storage provides the great storage capacity with data security
• Data Migration from other storage, data compression, stability

Incentivized

• Installing K2 reduced runtime of one of our batch processes, freeing up one employee for other tasks.
• Less time managing storage.

Incentivized

• 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.

Incentivized