Hub
Pricing About
Collection

KNIME for Azure Users

AzureMicrosoftMicrosoft AzureCloudAzure Blob Storage
+14

Get the most out of your Microsoft Azure stack with KNIME workflows. From local Excel analysis to interacting with Azure-hosted databases and OpenAI models, KNIME Microsoft and KNIME Azure Cloud extensions make it very easy to expand your Microsoft technology value and footprint within the business. Keep in mind that executing KNIME workflows connected to any Azure cloud services may incur Azure costs.

KNIME Azure Integration User Guide
This guide illustrates how to connect to Azure and how to use the Azure Cloud extensions.
Aug 5, 2024 4:03 PM
Like

Getting Started with Azure Workflows

Utilizing Azure product connections within KNIME will always start with user authentication. Once you have authenticated, you can use that output to power the Microsoft connectors.
Node / Source
Microsoft Authenticator

Provides authentication for accessing Microsoft Azure and Office 365 cloud services. Learn more

Connecting to Data Stored in Azure and Sharepoint

KNIME supports importing different types of data from multiple different Azure products. Depending on the Azure product, you can incorporate KNIME frameworks for additional processing.
File Storage with KNIME File Handling
With the KNIME File Handling Framework, you can incorporate files stored in multiple different Microsoft and Azure cloud services into your workflows.
KNIME File Handling Guide
Node / Source
SharePoint Online Connector

Connects to a SharePoint Online site to access document libraries as a file system. Learn more

Node / Source
Azure Blob Storage Connector

The item connects to Azure Blob Storage, allowing downstream nodes to access data as a file system for various operations. Learn more

Node / Source
Azure Data Lake Storage Gen2 Connector

The item allows downstream nodes to access Azure Data Lake Storage Gen2 data as a file system for various file system operations. Learn more

Node / Source
List Files/Folders

Generates a list of files and/or folders within a selected directory. Learn more

Node / Source
Excel Reader

The item reads Excel files and converts the data into KNIME types, providing a preview of the file content and structure. Learn more

Node / Sink
Excel Writer

The item writes input data into an Excel file, creating new files or appending data to existing ones in either .xls or .xlsx format. Learn more

Node / Source
CSV Reader

Reads CSV files and can auto-guess the file structure. Learn more

Node / Sink
CSV Writer

Writes input data table to a file or remote location in CSV format. Learn more

Node / Source
Table Reader

Reads files written using Table Writer node, retaining meta information like domain, properties, colors, and size from various file systems. Learn more

Node / Sink
Table Writer

Writes a data table in KNIME’s internal format to a file for later retrieval. Learn more

Node / Source
Transfer Files

Copies or moves files from a source to another folder with various options including deleting source files after moving. Learn more

Node / Source
Transfer Files (Table)

The item copies or moves files from a source to another folder based on specified options. Learn more

Node / Source
File Reader

Reads common text files, auto-guesses file structure, supports changing file schemas, and can access various file systems. Learn more

Go to item
Workflow
Read Data from Microsoft Azure Cloud
AzureAzure CloudMicrosoft Azure
+7
Retrieves data files from Microsoft Azure Cloud.
Beginners Space01_Read05_Read_Data_from_Microsoft_Azure_Cloud
10
knime
Go to item
Workflow
Microsoft SharePoint Data Access
SharePointMicrosoftCsv reader
+4
Connects to personal SharePoint file system, lists files/folders, reads/writes xls/csv files, writes tables in pdf/html formats.
Examples01_Data_Access06_ZIP_and_Remote_Files07_Microsoft_Sharepoint_Data_Access
7
knime
Relational Databases with KNIME’s Database Framework
With KNIME’s Database Framework, you can incorporate database tables stored in Azure into your KNIME Workflows. This includes Azure database services like Microsoft SQL Server, SQL Pools in Azure Synapse Analytics, as well as databases provisioned on Azure resources.
KNIME Database Extension
Node / Source
Microsoft SQL Server Connector

Establishes a connection to a Microsoft SQL Server, Azure SQL Database, or Azure Synapse SQL pool using JDBC driver. Learn more

Node / Source
DB Connector

Establishes a connection to a JDBC database for data retrieval and manipulation. Learn more

Node / Source
DB Table Selector

Selects a table or view from a connected database and outputs database connection info and query. Learn more

Node / Manipulator
DB Row Filter

Filters rows from a DB Data table based on specified conditions. Learn more

Node / Source
DB Reader

Executes queries in a database and retrieves results into a KNIME data table. Learn more

Node / Source
DB Query Reader

Executes an entered SQL query and returns the result as KNIME data table. Learn more

Node / Manipulator
DB Joiner

This node joins two DB Data tables. The join is based on the joining columns of both tables. Learn more

Node / Manipulator
DB Concatenate

The item merges two database tables by concatenating columns with equal names. Learn more

Go to item
Workflow
Database - Simple IO
DatabaseIoSqlite
Executes DB Query Reader and DB Writer nodes using a file-based “sqlite” database for simple input/output operations.
Examples01_Data_Access02_Databases01_Database_Simple_IO_Example
2
knime
Go to item
Workflow
Databases - Advanced Usage
DatabaseSqlite
Executes database operations using KNIME nodes directly within a file-based “sqlite” database.
Examples01_Data_Access02_Databases02_Database_Advanced_Example
0
knime

Query Azure OpenAI

KNIME offers native connectors supporting OpenAI models hosted in Azure cloud. These can be used for text generation, translation, classification, and summarization tasks. For more information on utilizing Generative AI, refer to the KNIME for Generative AI Collection below.
Node / Source
Azure OpenAI Authenticator

The item authenticates Azure OpenAI models using valid API keys from credentials set in the workflow. Learn more

Node / Source
Azure OpenAI LLM Connector

Establishes a connection with an Azure OpenAI Large Language Model for generating text based on input. Learn more

Go to item
Workflow
1.6 - Simple Azure OpenAI Prompt
OpenAIAILLM
+2
Generates human-like text based on input using Azure OpenAI API key.
AI Extension Example Workflows1) Large Language Models1.6 - Simple Azure OpenAI Prompt
0
knime
Go to item
Collection
KNIME for Generative AI
AILLMChat
+3
Provides ready-to-use workflows for utilizing Large Language Models (LLMs) in tasks such as building chat apps and retrieval augm…
14
knime

Leveraging Azure HDInsight with KNIME’s Apache Spark Framework

With the KNIME Extension for Apache Spark, KNIME user’s can leverage data from spark clusters created using Azure HDInsight into their workflows.
KNIME Azure HDInsight Integration Guide
Go to item
Extension
KNIME Extension for Apache SparkTrusted extension
KNIME nodes for assembling, executing and managing Apache Spark applications. Supports Spark versions 2.4 and 3.

KNIME AG, Zurich, Switzerland

0
knime
Go to item
Workflow
Working with Azure services
AzureMicrosoftHdinsight
+6
Enables connection to Azure services like HDInsight clusters, Azure Blob Storage, and AzureSQL within KNIME Analytics Platform.
Examples10_Big_Data01_Big_Data_Connectors09_AzureExample
0
knime

Using the Azure SDK for Python in KNIME Python Nodes

On top of the dedicated connectors we have for different Azure products, we support connection to all services via the Azure SDK for Python. For this you would implement Python directly in KNIME via the KNIME Python Integration.
Go to item
Collection
Getting started with KNIME's Python integration
PythonPython ScriptPython Integration
+2
Provides an overview of KNIME’s Python integration and how Python scripts can be used in workflows.
4
knime
Azure SDK for Python (GitHub)

KNIME on Azure Marketplace

KNIME provides Azure Marketplace offerings for customer-managed instances of KNIME Business Hub and KNIME Analytics Platform. If you are interested in deployment of KNIME Business Hub via the Azure Marketplace, refer to the following links and documentation. If you need assistance on evaluation of this deployment, please contact KNIME Customer Care using the link below.
KNIME on Azure Marketplace
Docs: KNIME Business Hub on Azure Marketplace
Contact KNIME Customer Care

Additional Material

Section for additional resources and materials
Docs: KNIME Azure Integration Guide
Docs: KNIME File Handling Guide
Docs: KNIME Database Extension Guide
Docs: KNIME Big Data Extensions User Guide

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits