Quick connect to Oracle database, Strong code base, bugs rectified in major patches Review collected by and hosted on G2.com.
interface, sometimes speed for cloud db connections Review collected by and hosted on G2.com.
Toad is a sql database just like the any other database connectors. It's great tool to pull data. The benefit of this connector in comparison to squirrel is the ability to pull more records and exporting to a csv. Review collected by and hosted on G2.com.
There's no differentiator that I have encountered. I noticed this connector is very slow to extract data and there's limitations to the number of records it can extract. Review collected by and hosted on G2.com.
1. Either you are developer or BA / tester its easy for everyone. Non technical people can use this software with same ease as technical user.
2. The dataset is in very easy and understable format. It looks same like excel table sheet and you can easily view SQL data.
3. There are some good features where you can just see the tables without writing any sql commands. Thats possible by just right click and describe. Similarly you can actually see all table , procedure , functions, views name
just by expanding the database with single mouse click.
4. When you write big functions and procedures you want your SQL query to look good and easy to understand for other developers and its editor is brillant for that. you can see the number of lines as well for good formatting.
5. Import and Export feauture helps you to get data in/out in different easy formats like CSV. Review collected by and hosted on G2.com.
Not to forget as it has so many good features it is end of the day connecting to the database (most of the time remotely) so it defientely needs good connectivity good amount of system memory.
Sometimes it use way more resources than it needs to use and leads the System crash or it will freeze your servers or system completely. Review collected by and hosted on G2.com.
The best part is we can easily connect different schemas with databases.
It' easy user interface shows all the saved schemas in an proper arranged ways so that user can switch between schemas very easily. Review collected by and hosted on G2.com.
After loading so many schemas it becomes slow to see different queries in different tabs. Review collected by and hosted on G2.com.
Toad is one of the most functional editors. It's really nice to create practical shortcuts and use them over and over again. Toad, it's nice to have low system requirements. Review collected by and hosted on G2.com.
Sometimes I have problems with the past. For example, the Sqls that I wrote in the past do not practically come to me. Toad, the sound it makes when it opens sometimes scares me. Review collected by and hosted on G2.com.
It is very easy to write queries using toad, especially intellisence option is very helpful during query writing. Data import, export, monitor, optimize, diagnose and debuging are the some of good features provided by toad. Review collected by and hosted on G2.com.
Sometimes it hangs during output of a query, also update query take much time to be completed Review collected by and hosted on G2.com.
the session browser is fantastic, it's a life saver when you have locks and badly tuned sql , nothing easier than session browser to catch them. Review collected by and hosted on G2.com.
the sql editor is not doing the auto complete for the object names (tables, columns , ..) which make writing the sql statment a bit diffecult specially in the huge schemas where you have thousands if objects. Review collected by and hosted on G2.com.
It has easy access to different and variable instances and schemas, one of the most striking points from my point of view, which makes it one of the ones I like the most, regarding its storage functionalities, including its storage capabilities. Monitoring during the execution of a particular project, I like that its interface design transfers emotion and charity, it is implicit to want to offer its innovative information in every aspect that occurs internally in the development of the platform. Review collected by and hosted on G2.com.
The toad is high cost, which implies that it operates only with high-performance companies that can be medium-sized companies, since obviously small companies cannot because they are not at the limit of their budget, we can highlight that not all Tools are not easy to understand and navigate in the online web application, and lastly, error handling is not as accurate as it should be for spelling and grammatical deficiencies in schemas or other designed system operations. Review collected by and hosted on G2.com.
The best part of this tool is that it provide a lot of feature to generate automated queries. Different formats of reports can be exports based on data in oracle without any complex queries. Easily determine the error in scripts. Review collected by and hosted on G2.com.
The hanging problem bothers a lot. It consume a lot of resources. But it's an obvious problem as this tool has a lot of feature. Review collected by and hosted on G2.com.