This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This node provides authentication to access Microsoft Azure and Office 365 cloud services.
It supports these authentication modes:
- Interactive authentication: Performs an interactive user login in your web browser, when you click on Login. In the browser window that pops up, you may be asked to consent to the requested level of access The login results in a token being stored in a configurable location. The token will be valid for a certain amount of time that is defined by your Azure AD settings. Technically, the login uses the OAuth 2.0 authorization code flow.
- Username/password authentication: Performs a non-interactive user login to obtain a fresh token every time the node executes. Since this login is non-interactive and you get a fresh token every time, this mode is well-suited for workflows on KNIME Server/ Hub. However, it also has some limitations: First, you cannot to consent to the requested level of access, hence consent must be given beforehand, e.g. during a previous interactive login, or by an Azure AD directory admin. Second, accounts that require multi-factor authentication (MFA) will not work. Technically, the login uses the OAuth 2.0 Resource Owner Password Credentials flow.
- Client/Application secret authentication: Performs a non-interactive application login to obtain a fresh token every time the node executes. Since this login is non-interactive and you get a fresh token every time, this mode is well-suited for workflows on KNIME Server/ Hub. Please note however, that Microsoft Azure/Office 365 cloud services are accessed on behalf of the application, not on behalf of a user (see here). Technically, the login uses the OAuth 2.0 client credentials flow.
- Shared key authentication (Azure Storage only): Specific to Azure Blob Storage and Azure Data Lake Storage Gen2. Performs authentication using an Azure storage account and its secret key.
- Shared access signature (SAS) authentication (Azure Storage only): Specific to Azure Blob Storage and Azure Data Lake Storage Gen2. Performs authentication using shared access signature (SAS). For more details on shared access signatures see the Azure storage documentation.
Options
Interactive authentication
Username/password authentication
Client/Application secret authentication
Before using this mode, (1) an Azure AD application has to be registered, (2) an application secret has to be created, and (3) an admin has to grant application permissions (not delegated) to the application service principal in the Azure AD tenant to access. In this mode, Azure/Office 365 cloud services are accessed with the application identity and not on behalf of a user. See here for more information.
Shared key authentication (Azure Storage only)
Shared access signature (SAS) authentication (Azure Storage only)
Advanced
Popular Predecessors
- Excel Writer10 %
Row Filter (deprecated)7 %- Column Filter5 %
- Wait...5 %
- GroupBy5 %
Column Rename4 %- Column Expressions (legacy)3 %
- Credentials Widget2 %
- Rule Engine2 %
- Table Row to Variable2 %
- CSV Writer2 %
- Missing Value2 %
- Credentials Input (legacy)2 %
- Rule-based Row Filter2 %
- Merge Variables2 %
- Joiner1 %
- String Manipulation1 %
- Concatenate1 %
- String Manipulation (Variable)1 %
- Variable Creator1 %
- Table Row to Variable Loop Start1 %
- CSV Reader1 %
- Duplicate Row Filter1 %
- Container Input (Table)1 %
- Table Column to Variable< 1 %
- Generic Loop Start< 1 %
- String to Number< 1 %
- Variable Expressions (legacy)< 1 %
- Local File System Connector< 1 %
- Try (Variable Ports)< 1 %
- DB Writer< 1 %
- Variable to Credentials< 1 %
- Column Resorter< 1 %
- Empty Table Creator< 1 %
- String to Path (Variable)< 1 %
- Python Script (legacy)< 1 %
- Create Date&Time Range< 1 %
- Chunk Loop Start< 1 %
- Variable Loop End< 1 %
- DB Query Reader< 1 %
- Reference Row Filter< 1 %
- Credentials Configuration< 1 %
- Date&Time Configuration< 1 %
- Table Creator< 1 %
Counting Loop Start< 1 %- Constant Value Column< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Math Formula< 1 %
- SharePoint Online Connector< 1 %
- String Configuration< 1 %
- String Input (legacy)< 1 %
- Refresh Button Widget< 1 %
- Container Input (Credentials)< 1 %
- Table Writer< 1 %
- Reference Column Resorter< 1 %
- GET Request< 1 %
- Loop End< 1 %
- Group Loop Start< 1 %
- KNIME Server Connector< 1 %
Cell Replacer< 1 %- Parquet Writer< 1 %
- Date&Time to String< 1 %
- String Manipulation (Multi Column)< 1 %
- Workflow Service Input< 1 %
- Cross Joiner< 1 %
- Credential Variable Extractor< 1 %
- Number to String< 1 %
- Path to String< 1 %
- Create Temp Folder< 1 %
- JSON to Table< 1 %
- Reset on Load< 1 %
- Mountpoint Connector< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
CASE Switch Variable (End)< 1 %- Date&Time Input (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
Table Row to Variable< 1 %- Java Edit Variable< 1 %
Generic Loop Start< 1 %- Table Validator< 1 %
- Sorter< 1 %
- Table Transposer< 1 %
CASE Switch Variable (Start)< 1 %- Create Temp Dir (legacy)< 1 %
- Microsoft Access Connector< 1 %
- Math Formula (Multi Column)< 1 %
- Excel Reader< 1 %
- SMB Connector< 1 %
- SSH Connector< 1 %
- Java Edit Variable (simple)< 1 %
- Create File/Folder Variables< 1 %
- Path to String (Variable)< 1 %
- String to Date&Time< 1 %
Views
- This node has no views
Workflows
01_Integrated_Deployment_ExampleKNIME Hub- 04_AmazonS3-MSBlobStorage_Census_DataKNIME Hub
- 05_Read_Data_from_Microsoft_Azure_CloudKNIME Hub
- 05_Read_Data_from_Microsoft_Azure_CloudKNIME Hub
- 05_Read_Data_from_Microsoft_Azure_CloudKNIME Hub
- Show all 79 workflows
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.