We performed a comparison between SAS Enterprise Guide and Toad Data Point based on real PeerSpot user reviews.
Find out in this report how the two Data Preparation Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"It has definitely improved our communication with senior management."
"Similar to Microsoft Access, you can drag and drop. You can simply drag and drop objects onto the page and create various flows to establish your query within the project. You can extract those queries from the preview as needed."
"SAS EG offers many excellent features, such as parallel execution on the same server, controlling output datasets in the process flow, and conditional processing."
"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."
"We are using SAS Enterprise Guide on a basic level and the Pro SQL and other procedures within it are the most useful right now. Additionally, it has a wide feature set and capabilities"
"The point and click makes it easy to transfer the knowledge to new employees."
"The query builder feature is the most valuable."
"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."
"Machine learning is not utilized and that could enhance the product."
"More bi-directional integration with the SAS Studio suite of tools is needed."
"The product is missing a visualization component so we have to use a separate tool for visualization."
"Now that I have experience with Tableau, I think the visualization part of SAS EG could be more user friendly and easier to use. Tableau is very easy to use. It's just does a lot of work by itself, including color schemes. I think that could be incorporated easily into SAS EG, which would make it a much better product. Then you would not need Tableau."
"I would like to see integration with schedulers when run from hosting environments such as Citrix."
"The stability is not very reliable."
"Setting up SAS Enterprise Guide is somewhat messy and complex."
"I would like to see better Charting in this solution."
"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 and Altair Monarch, whereas Toad Data Point is most compared with SSIS, Alteryx, Oracle Data Integrator (ODI), Azure Data Factory and Denodo. See our SAS Enterprise Guide vs. Toad Data Point report.
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.