Try our new research platform with insights from 80,000+ expert users

SAS Enterprise Guide vs Toad Data Point comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Sep 10, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAS Enterprise Guide
Ranking in Data Preparation Tools
2nd
Average Rating
8.2
Reviews Sentiment
6.5
Number of Reviews
24
Ranking in other categories
No ranking in other categories
Toad Data Point
Ranking in Data Preparation Tools
6th
Average Rating
9.0
Reviews Sentiment
7.7
Number of Reviews
3
Ranking in other categories
Data Integration (32nd)
 

Mindshare comparison

As of February 2025, in the Data Preparation Tools category, the mindshare of SAS Enterprise Guide is 22.5%, down from 27.1% compared to the previous year. The mindshare of Toad Data Point is 8.1%, up from 6.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Preparation Tools
 

Featured Reviews

Karunakar Kankata - PeerSpot reviewer
A predictive data analytics that lacks support for advanced modeling techniques
I find it challenging when I need to use certain functions and predictive modeling techniques in SAS. The procedures and data steps for database analysis take longer, and I've noticed that the current version we are using, lacks support for advanced modeling techniques. We've requested support for these advanced algorithms, but it seems there have been challenges in implementing them. As a result, we are facing difficulties in developing advanced models. Another issue we've encountered is that the community support for SAS is relatively limited compared to open-source environments.
Aaron Payne - PeerSpot reviewer
Offers power developers the tools they need
I am not the end user of this solution. I am not close enough to it because I manage the platform that it runs against. The end users who use the Toad tool come against the database that my team manages, so it is hard for me to provide any area for improvement when it comes to the Toad tool. However, in the administration case, cost is a significant issue. The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version. Scalability is difficult when it is that costly.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Statistical functionality and basic database interaction can become very straightforward for business users that don't have a background in SQL and data analysis."
"One of the features of the SAS Enterprise Guide is that it has a server, and we can access the server."
"The Query Builder is very valuable."
"Filter and sort query builder is valuable. The ability to do advanced SAS programming is also a useful feature because we can do anything by using Enterprise Guide. It has a lot of functionalities. We can build ETL processes. There are clients who are using SAS Enterprise Guide to build ETL processes. They have a SAS-based program that is scheduled to run at a certain frequency to produce some reports for the business. It is a very useful tool for ETL unit tests and functional tests. You can also do data science projects in SAS Enterprise Guide by using different statistics. During my MBA, we used SAS Enterprise Guide for our statistic course. To query the data, there are many solutions such as SQL, but these tools are only a part of the integration. They are only useful for querying the data and require knowledge of SQL, so they are not suitable for business users. SAS Enterprise Guide can be very easily used by business users to filter and sort the data and build queries. It is not necessary to have coding skills to use SAS Enterprise Guide. For this reason, it is attractive for businesses."
"We do not bother any longer with some programs did not run, hence having to rerun them again."
"Enterprise Guide is much better at generating reports than many solutions. We often use it to generate reports, and people interpret them how they like. They often probably use Excel spreadsheets or something like that after they get our data."
"It has improved tremendously moving from providing an easy menu-driven system to also providing an excellent platform for developing and running full production systems, with minimal coding, which enabled increasing popularity among many non-programmers."
"The product has a drag-and-drop feature that is excellent for business users and that makes it easy-to-use."
"It provides better SQL development tooling than SQL Developer, which is not a sufficient tool for all development use cases. It offers power developers the tools they need."
"The most valuable features of Toad Data are you could write a parameterized query and it wouldn't error out, it would give you the parameters that you could input. The auto-formatting feature is useful because it was great for keeping your queries neat and understandable. The auto comment, and uncomment toggles that you could do were convenient."
"The Connectivity and Connection Manager supports a broad number of connection types, and it is trivial for end-users to set up their own connections to sources."
"We love it."
 

Cons

"The stability is not very reliable."
"For some of the advanced functions, you need to learn some SAS code to get what you want."
"Recently, we realized that SAS Enterprise Guide is not so stable and gives us some outputs which are not suitable...Sometimes it's quite hard to report its stability issues."
"I would like it to give more information rather than just a forever loop that forces you to shut down the system. Give you more error messages without stopping the entire project, or even the entire application. That it displays more error messages rather than terminating the application."
"They should provide more information for the errors or logs. Currently, it gives you just the error message without explaining anything."
"It is expensive."
"Setting up SAS Enterprise Guide is somewhat messy and complex."
"I would like to see better Charting in this solution."
"The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version. Scalability is difficult when it is that costly."
"On the scheduling server, some scheduled reports just sit there and never execute for the first time. After manually executing the first time, they run with no issues."
"Toad Data could improve by having additional features, such as query prediction. This could help someone who's not the strongest programmer. If the software could help them write queries correctly it would be very helpful, especially for small development teams or teams that lack the input skills necessary to write and program efficiently."
"The Mac license is incredibly expensive. It is 1,600 dollars each, which is more than the Windows version."
 

Pricing and Cost Advice

"The pricing and associated costs are substantial."
"In general, SAS has high prices, which is a reason why some clients don't use SAS solutions. The licensing is on a yearly basis."
"It is expensive. We get a different price based on our corporate rate. So, I'm not sure what the general cost is because we got a special rate for it."
"Management liked it a lot because the license per seat was cheaper than a traditional SAS environment."
"It is very expensive. We have a basic license, and there are many features that are not available with the basic version."
"I did look at the prices a few years ago, and I believe it was approximately $1,000 for a yearly subscription at that time."
"The price of Toad Data Point was approximately $500 annually."
"The cost of this product is reasonable."
"The Mac licenses are expensive, costing 1,600 dollars each. This is much higher than for the Windows version. I maintain a very limited number of licenses due to this cost."
report
Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
832,138 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Healthcare Company
12%
Computer Software Company
10%
Government
9%
Financial Services Firm
36%
Healthcare Company
12%
Government
9%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about SAS Enterprise Guide?
It streamlines our workflow involving multiple steps, from data extraction to modeling, and it is aimed at improving various aspects of banking operations, including customer retention and risk man...
What needs improvement with SAS Enterprise Guide?
I find it challenging when I need to use certain functions and predictive modeling techniques in SAS. The procedures and data steps for database analysis take longer, and I've noticed that the curr...
What is your experience regarding pricing and costs for Toad Data Point?
The Mac licenses are expensive, costing 1,600 dollars each. This is much higher than for the Windows version. I maintain a very limited number of licenses due to this cost.
What needs improvement with Toad Data Point?
I am not the end user of this solution. I am not close enough to it because I manage the platform that it runs against. The end users who use the Toad tool come against the database that my team ma...
What is your primary use case for Toad Data Point?
We primarily use Toad Data Point for end users where SQL Developer does not provide sufficient tooling. Toad Data Point offers better SQL development tools compared to SQL Developer, making it the ...
 

Overview

 

Sample Customers

Canary Islands Statistics Institute
Concordia University
Find out what your peers are saying about SAS Enterprise Guide vs. Toad Data Point and other solutions. Updated: January 2025.
832,138 professionals have used our research since 2012.