We performed a comparison between SAS Enterprise Guide and Toad Data Point based on real PeerSpot user reviews.
Find out what your peers are saying about Alteryx, SAS, Quest Software and others in Data Preparation Tools."One of the features of the SAS Enterprise Guide is that it has a server, and we can access the server."
"Scheduling downtime of some programs has been eliminated."
"The point and click makes it easy to transfer the knowledge to new employees."
"An excellent tool for data manipulation and analysis."
"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."
"The query builder feature is the most valuable."
"We are able to work on the server, and I can copy a data set and share it with someone in my team. Similarly, if I want some data from them, I can get it. Being able to work on the server and being able to switch from one user to another is a good thing. It is reliable and powerful, and its community is very wide."
"Enabled us to remove PC SAS, which reduced risk."
"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."
"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."
"Our data warehouse is built on the Netezza database. We have SAS BI, and we populate the Netezza database. When we have tables with, for example, a hundred million rows in Netezza, SAS Enterprise Guide doesn't work. It doesn't return any results. It works for around 30 to 40 million rows, but it is not working for anything more than that. This issue is only with the Netezza database. With Oracle, it is quite good. They can improve its performance with the Netezza database. There should be one unique tool that includes SAS Data Integration Studio and SAS Enterprise Guide for more integration capabilities. With SAS Enterprise Guide, it is not possible to create connections and libraries and build transformations that can be used for other projects. This tool should have all capabilities that SAS Enterprise Guide does not have. Such a tool would be perfect because it will be used by developers and business users at the same time. In addition to the integration capabilities, they should also provide more deployment capabilities. There should be an option to easily create SAS packages and export them from one environment to another. There could also be a possibility to connect with R and Python. Open-source tools are hot in the market nowadays, and it would be good to extend its capabilities."
"More bi-directional integration with the SAS Studio suite of tools is needed."
"I would like to see better Charting in this solution."
"There needs to be a community of SAS Enterprise Guide users for assistance. For example, as they do for Python or SQL."
"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."
"A log belongs to each program. I have experienced a situation where when I run just the exec files, it replaces the whole log and I wanted to see the earlier log, then this was not possible."
"Setting up SAS Enterprise Guide is somewhat messy and complex."
"Machine learning is not utilized and that could enhance the product."
"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."
"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."
SAS Enterprise Guide is ranked 2nd in Data Preparation Tools with 24 reviews while Toad Data Point is ranked 3rd in Data Preparation Tools with 2 reviews. SAS Enterprise Guide is rated 8.2, while Toad Data Point is rated 9.0. The top reviewer of SAS Enterprise Guide writes "Easy to use, drag and drop interface, with good built-in help facilities". On the other hand, the top reviewer of Toad Data Point writes "Easy to learn, good connectivity to multiple data sources, and helpful supprt". SAS Enterprise Guide is most compared with Alteryx, Altair Monarch and Trifacta Wrangler Enterprise, whereas Toad Data Point is most compared with SSIS, Alteryx, Oracle Data Integrator (ODI), Azure Data Factory and Informatica PowerCenter.
See our list of best Data Preparation Tools vendors.
We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.