Toad Data Point Reviews & Product Details

I like that Toad offers a variety of products with different levels of access. We can use one product for end users trying to get information not found in the front end product, while another provides access to DBA tools that separates our reliance on another group for simpler DBA tasks. Review collected by and hosted on G2.com.

It's a little difficult to get going without instruction. Review collected by and hosted on G2.com.

Generating simple queries was not too complicated. Review collected by and hosted on G2.com.

The connection interface was a little awkward. When generating more complicated queries I found it easier to just write my own. Review collected by and hosted on G2.com.

Helpful tool for creating complex queries, joins, extract data and model at same place. Have been using it from last few years. Review collected by and hosted on G2.com.

Probably quest need to add few more features now. I really would like to see a tool which shows database changes with the date the change happened Review collected by and hosted on G2.com.

We are using this Toad data point 3.6.1 from the year of 2013 and this is very well used for the analytical research for our recovery applications.

Some of the key features which intends to use are:

1. Import/Export function where we can able to export the data in any of the format like .csv, xlsx, .txt etc., accordingly the number of rows required.

2. Database comparison wizard - Used to compare the version of components between databases in one stretch rather than manually downloading and doing the comparison. This saves developer time for comparison using the wizard.

3. Transform function and cleansing the data.

4. Database diagram - Easily able to generate the database diagram which will shows the relationship between objects.

5. Toad automation scripts and formatting SQL scripts for developer. Review collected by and hosted on G2.com.

Dislikes are some of the few:

1. License Key is costly since we have to pay rather than open-ended tool.

2. Some of the SQL commands are still not recognized by Toad like (NOSQL), PIVOT etc., Review collected by and hosted on G2.com.

I am using this TOAD software from the year of 2008 and particularly toad data point for the US Healthcare Projects. Most of the features are very Good one and below are the highlighted one:

1. Cross-connected with Any databases like SQL Server, Sybase, Oracle and DB2 for Mainframe.

2. Export wizard functionality is easier in order to transport the data to .txt, csv, xml & other types quickly.

3. Easier to export the log values during the query exeecution in parallel. Particularly it will save the .txt format for all values generated during query running which is helpful for the developer. This functionality is called "Execution Trace"

4. Ability to open multiple cross databases and saved in the connection editor. This will be helpful for the developer during analytics execution.

5. Ability to save FTP connection for exporting the file directly from FTP or other protocol for transferring data files.

6. Toad can be configured according to the developer need for cross databases.

7. Show estimate plan is another option for showing the query execution plan in details which can be exported quickly for analyzing the tables.

8. Ease of usability. Review collected by and hosted on G2.com.

1. Some of the functions are not recognized in TOAD. Best examples are (NOLOCK) function. Due to this, we need to edit SQL queries manually before executions.

2. Since TOAD is used for cross-linked databases, we will not able to see partition function execution and presence of data.

3. Reporting will not be exact since this is not owned by database production. An example is SSRS reports run by Microsoft.

4. TOAD will not be used by DBA's and this is only an analytical tool for data's to research with.

5. One or another this is not a free tool and need to procure the licenses. So company's are forcing free tool like SQL developer for any items on analytics :). Review collected by and hosted on G2.com.

Toad allows me to connect to several different sources, including Excel files, to analyze data and create reports in one spot using intuitive, drag and drop tools. I no longer need to ask someone from IT to write an SQL query or try to limit myself to what I can fit into Excel to be able generate valuable insights and reports to share with leadership. Review collected by and hosted on G2.com.

Some of the data sources I connect to are very primitive and still use pipe delimited flat files. I have figured out a way to connect to these but it was very difficult. Review collected by and hosted on G2.com.

The #1 benefit is being able to connect to many different types of data sources and aggregate data into one product and aggregate data from many different sources into one dashboard.

I built my entire division's performance data reporting around Toad Data Point. Review collected by and hosted on G2.com.

Bugs. Frequently, between Toad Data Point version releases, automation script processes that worked in a previous release will not work in the next version creating a lot of work to either work around it or to communicate with the Toad technical team to get the bug fixed for the next release. Review collected by and hosted on G2.com.

Toad saves up to 5 result tabs, so when you run a query and then change something, it'll save both runs so you have something to compare Review collected by and hosted on G2.com.

Toad isn't too intuitive at first and you have to spend some time exploring before figuring out how to use it Review collected by and hosted on G2.com.

I love the code formatting and how it shows me when I've made an error. I like how easy it is to how others how to write sql with toad. Review collected by and hosted on G2.com.

When I do make an error in my code - there are times that it pops up a help screen. I would prefer that it would only pop that up if I requested it. Review collected by and hosted on G2.com.

Cross platform use, and in the Pro version able to access noSQL such as Cassandra.

Ease of use. Much prefer to use Toad for Data Point Pro over Microsoft SQL Server Management Studio. Review collected by and hosted on G2.com.

Not much really. It isn't cheap and I have to create a good argument to my boss to get it over using the MS SQL Management Studio, which is free. What saves me is my time at the company, 17 years, and that I also work on Datastax Cassandra noSQL and it works better than dBeaver noSQL, which is also free. Review collected by and hosted on G2.com.