Azure Data Factory vs. KNIME Analytics Platform

Best scenario is for ETL process. The flexibility and connectivity is outstanding. For our environment, SAP data connectivity with Azure Data Factory offers very limited features compared to SAP Data Sphere. Due to the limited modelling capacity of the tool, we use Databricks for data modelling and cleaning. Usage of multiple tools could have been avoided if adf has modelling capabilities.

Incentivized

KNIME Analytics Platform is excellent for people who are finding Excel frustrating, this can be due to errors creeping in due to manual changes or simply that there are too many calculations which causes the system to slow down and crash. This is especially true for regular reporting where a KNIME Analytics Platform workflow can pull in the most recent data, process it and provide the necessary output in one click. I find KNIME Analytics Platform especially useful when talking with audiences who are intimidated by code. KNIME Analytics Platform allows us to discuss exactly how data is processed and an analysis takes place at an abstracted level where non-technical users are happy to think and communicate which is often essential when they are subject matter experts whom you need for guidance. For experienced programmers KNIME Analytics Platform is a double-edged sword. Often programmers wish to write their own code because they are more efficient working that way and are constrained by having to think and implement work in nodes. However, those constraints forcing development in a "KNIME way" are useful when working in teams and for maintenance compared to some programmers' idiosyncratic styles.

Incentivized

• Data Ingestion - it works very well with numerous data sources.
• Data pipeline orchestration: It is a generic, popular tool for orchestrating data pipelines.
• Works well in Azure ecosystem, Azure services and data platforms like Databricks.
• It is a serverless and scalable solution for cloud data integration.

Incentivized

• Summarize instrument level financial data with relevant statistics
• Map transactions from core extracts to groups of like transactions using rule engines
• Machine learning using random forests and other techniques to analyze data and identify correlations for use in predictive models
• Fill out sampling data from averages.

• Granularity of Errors: Sometimes, Azure Data Factory provides error messages that are too generic or vague for us, making it challenging to pinpoint the exact cause of a pipeline failure. Enhanced error messages with more actionable details would greatly assist us as users in debugging their pipelines.
• Pipeline Design UI: In my experience, the visual interface for designing pipelines, especially when dealing with complex workflows or numerous activities, can become cluttered. I think a more intuitive and scalable design interface would improve usability. In my opinion, features like zoom, better alignment tools, or grouping capabilities could make managing intricate designs more manageable.
• Native Support: While Azure Data Factory does support incremental data loads, in my experience, the setup can be somewhat manual and complex. I think native and more straightforward support for Change Data Capture, especially from popular databases, would simplify the process of capturing and processing only the changed data, making regular data updates more efficient

Incentivized

• It does not have proper visualization.
• Some other BI tools (QlikView) have much easier functions for data interaction.
• Some other BI tools (Tableau) can be set up much faster.
• It is not an easy tool to use for non-tech savvy staff.

Incentivized

We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end

So far product has performed as expected. We were noticing some performance issues, but they were largely Synapse related. This has led to a shift from Synapse to Databricks. Overall this has delayed our analytic platform. Once databricks becomes fully operational, Azure Data Factory will be critical to our environment and future success.

Incentivized

KNIME Analytics Platform offers a great tradeoff between intuitiveness and simplicity of the user interface and almost limitless flexibility. There are tools that are even easier to adopt by someone new to analytics, but none that would provide the scalability of KNIME when the user skills and application complexity grows

Incentivized

We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue

Incentivized

KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.

Incentivized

KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.

Incentivized

Azure Data Factory helps us automate to schedule jobs as per customer demands to make ETL triggers when the need arises. Anyone can define the workflow with the Azure Data Factory UI designer tool and easily test the systems. It helped us automate the same workflow with programming languages like Python or automation tools like ansible. Numerous options for connectivity be it a database or storage account helps us move data transfer to the cloud or on-premise systems.

Incentivized

Having used both the Alteryx and [KNIME Analytics] I can definitely feel the ease of using the software of Alteryx. The [KNIME Analytics] on the other hand isn't that great but is 90% of what Alteryx can do along with how much ease it can do. Having said that, the 90% functionality and UI at no cost would be enough for me to quit using Alteryx and move towards [KNIME Analytics].

Incentivized

• Facilitate better decision-making and improve business processes.
• Optimize business process outcomes by increasing internal efficiency and operational effectiveness.
• Boosts revenue growth while improving business process agility.

Incentivized

• It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node.
• Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product.

Incentivized