We performed a comparison between Azure Data Factory and SAS Data Management based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."We have found the bulk load feature very valuable."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"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."
"One advantage of Azure Data Factory is that it's fast, unlike SSIS and other on-premise tools. It's also very convenient because it has multiple connectors. The availability of native connectors allows you to connect to several resources to analyze data streams."
"Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
"The most valuable feature is the copy activity."
"I am impressed with the tool's ability to customize."
"The solution is very stable. We haven't faced any issues with glitches or bugs. We haven't had any crashes."
"The product offers very good flexibility."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"The tool is reliable, quick, and powerful."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The technical support is excellent."
"If you compare it to SQL, the memory and development times are very quick."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"Some of the optimization techniques are not scalable."
"I rate Azure Data Factory six out of 10 for stability. ADF is stable now, but we had problems recently with indexing on an SQL database. It's slow when dealing with a huge volume of data. It depends on whether the database is configured as general purpose or hyperscale."
"The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring."
"It can improve from the perspective of active logging. It can provide active logging information."
"There are limitations when processing more than one GD file."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."
"We find we often have to go back and re-train users when there are changes made to the solution because the changes are not intuitive."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"The solution could use better documentation."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"The solution is quite expensive and hard to install/configure."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"I would like the tool to include the ability to automate the modifications of the integrations."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while SAS Data Management is ranked 43rd in Data Integration with 15 reviews. Azure Data Factory is rated 8.0, while SAS Data Management is rated 8.4. 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 Data Management writes "A scalable solution with customer support that is responsive and diligent". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas SAS Data Management is most compared with Informatica PowerCenter, Tungsten RPA, Microsoft Purview, IBM InfoSphere DataStage and Palantir Foundry.
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.