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."Statistical functionality and basic database interaction can become very straightforward for business users that don't have a background in SQL and data analysis."
"Scheduling downtime of some programs has been eliminated."
"Takes advantage of our Enterprise SAS Grid."
"The data cleaning part is valuable. SAS is a very powerful tool to work with and connect with different sources. We have several tables, and we are looking up tables from one place to another place. We are connecting with different data sources. The data is not coming from one source. There are several sources of data, and we have information coming from different sources. There are some flat files, and there is some information from the data warehouse."
"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."
"SAS EG offers many excellent features, such as parallel execution on the same server, controlling output datasets in the process flow, and conditional processing."
"Areas where SAS EG does a better job than regular SAS are in the realm of importing and exporting data. For instance, exporting a SAS data set in Unix to an Excel spreadsheet on a PC is a simple task compared to doing the same task with Base SAS."
"It is also compatible with other softwares, such as Excel."
"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."
"I see no reason for limiting the process to sequential all the time."
"We don't use SAS Enterprise Guide that much here because we haven't explored some of the statistical modeling capabilities. However, I do not think SAS Enterprise Guide provides all the machine learning features that we want. Those would be separate products from SAS, such as SAS Buyers or any of the other solutions, which will give us the capabilities that we are looking for."
"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."
"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."
"Machine learning is not utilized and that could enhance the product."
"I would like to see integration with schedulers when run from hosting environments such as Citrix."
"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."
"It would be very useful if EG could be enhanced to automatically file and clear the project log to ensure non-stop running of the project."
"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."
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 and Altair Monarch, whereas Toad Data Point is most compared with SSIS, Alteryx, Oracle Data Integrator (ODI), Azure Data Factory and Denodo.
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.