We performed a comparison between KNIME and Microsoft Azure Synapse Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Knime, Weka, IBM and others in Data Mining."We have found KNIME valuable when it comes to its visualization."
"It's a coding-less opportunity to use AI. This is the major value for me."
"I've never had any problems with stability."
"It provides very fast problem solving and I don't need to do much coding in it. I just drag and drop."
"Usability, and organising workflows in very neat manner. Controlling workflow through variables is something amazing."
"Overall KNIME serves its purpose and does a good job."
"One of the greatest advantages of KNIME is that it can be used by those without any coding experience. those with no coding background can use it."
"Clear view of the data at every step of ETL process enables changing the flow as needed."
"The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"-"
"One central workspace to manage everything for your data warehouse including visualization."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"Technical support is okay in terms of the help they provide."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"Its scalability and ease of use are valuable. It is fairly simple for a tool that's that powerful. If you have a background in Microsoft SQL Server, it is a very easy-to-transition path."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"To enhance accessibility and user-friendliness, there is a need for improvements in the interface and usability of deep learning and large-scale learning languages."
"Not just for KNIME, but generally for software and analyzing data, I would welcome facilities for analyzing different sorts of scale data like Likert scales, Thurstone scales, magnitude ratio scales, and Guttman scales, which I don't use myself."
"They should look at other vendors like Alteryx that are more user friendly and modern."
"It needs more examples, use cases, and MOOC to learn, especially with respect to the algorithms and how to practically create a flow from end-to-end."
"The dynamic column name feature could be improved. When attempting to automate processes involving columns, such as with companies, it becomes difficult to achieve the same result when we make changes."
"System resource usage. Knime will occupy total system RAM size and other applications will hang."
"I'd like something that would make it easier to connect/parse websites, although I will fully admit that I'm not as proficient in KNIME as I would like to be, so it could be I'm just missing something."
"I would like it to have data visualitation capabilities. Today I'm still creating my own data visualtions tools to present my reports."
"The performance needs to improve in future releases."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"Comes with a pretty steep learning curve."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"The product could be more feature-rich."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
KNIME is ranked 1st in Data Mining with 50 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews. KNIME is rated 8.2, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of KNIME writes "A low-code platform that reduces data mining time by linking script". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". KNIME is most compared with RapidMiner, Microsoft Power BI, Alteryx, Weka and Dataiku Data Science Studio, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata.
We monitor all Data Mining 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.
I know you're looking for someone who's done research for you but realize that's actually something people get paid to do.
That said, what you're asking about is a mix of quite different tools when you throw KNIME in the mix. I don't know that tool but sounds like its for specific purpose and it's not an Azure tool. Realize there's endless ETL tools out there. I've used about 1/2 dozen in my career. I currently use both ADF and SSIS. I only use ADF when I have to as it's overly complicated to do version management and deal with ARM templates and is very very slow in comparison to SSIS. ADF can however be a good orchestrator for running SSIS - there's an Azure/PaaS version of SSIS called SSIS-IR that can run from ADF. Synapse Analytics pipelines which is actually ADF technology but stripped down. And now there's Fabric Data Factory which is again ADF but even more stripped down. Fabric is also bleeding edge.
ADF has been around for long time now. Anything Azure is cloud based and integrates with Azure services. KNIME is not that. I advise first on understanding fundamental requirements such as, what are the skill levels of your staff with ETL? Are you an Azure shop? What kind of data volumes are you talking about? What sources do you need to connect to (that's a biggy because not all tools talk to all sources!) What are you trying to do - build a datamart or EDW or just copy some data from a source or ? Do you use PowerBI? These will help drive what kind of tool you're looking for. If you want SAAS like as possible tool due to minimal requirements, low data volumes and low staff expertise and starting from scratch, I'd give Fabric a try especially if you want low tech and already into the Power platform. Hope that helps
I believe Synapse is not an ETL tool. ADF is one optional ETL tool for a Synapse Data warehouse.. What Are the Top ETL Tools for Azure Data Warehouse? | Integrate.io
I'd like to step back and pose a bigger option. You see, ETL means making a copy of data you have already. Have you considered a data fabric or mesh, where the data is used where it lies now? Consider this if your data is already used by some systems, but you need to do a more comprehensive analysis of it.
I always want to reduce the replication of databases. The concept of build yet another database to "replace" all the others rarely works out that way. I'd rather beef up the origination system, or use a replica than build a huge portfolio of ETL programs and an army of ops, data governance, and system support to keep them in sync.
Finally, if you really need an ETL tool, i.e. copies of all that data... look for existing talent in your staff. Otherwise, expect to hire some people experienced with the new tool that can advise on design and development and mentor existing staff.
A couple of questions before starting the feature comparison: i. Are you fine with an open-source solution? ii. Any specific reason you have listed ADF? iii. Who will be using these tools and how much learning curve is involved within the team? iv. What kind of data you are dealing with? v. Is data privacy an important factor? vi. Are you looking for only a cloud-based solution or open to a hybrid solution also? vii. What is the maturity level of the team when it comes to working on the cloud ........ These are just a few of the many questions basis which we do self-assessment or measure our preparedness. Let me know if you need more insights. Happy to help!!