We performed a comparison between Azure Data Factory and SAS Access based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"For developers that are very accustomed to the Microsoft development studio, it's very easy for them to complete end-to-end data integration."
"Azure Data Factory became more user-friendly when data-flows were introduced."
"The data copy template is a valuable feature."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."
"Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"The most valuable feature is you have native access to the external databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"We require Azure Data Factory to be able to connect to Google Analytics."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."
"User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."
"Real-time replication is required, and this is not a simple task."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."
Azure Data Factory is ranked 1st in Data Integration with 79 reviews while SAS Access is ranked 38th in Data Integration with 3 reviews. Azure Data Factory is rated 8.0, while SAS Access is rated 9.0. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of SAS Access writes "The solution is stable, scalable, and flexible". Azure Data Factory is most compared with Informatica PowerCenter, Alteryx Designer, Informatica Cloud Data Integration, Snowflake and Microsoft Azure Synapse Analytics, whereas SAS Access is most compared with Delphix, SSIS and Zapier.
See our list of best Data Integration vendors.
We monitor all Data Integration 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.