Icon

Azure Cosmos DB REST API

Azure driver: You need JDBC driver minimum version 9.2 together with MSAL4J.mssql-jdbc. MS SQL JDBC: https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbcmsal4j. Microsoft Authentication Library for Java: https://mvnrepository.com/artifact/com.microsoft.azure/msal4jDownload via: https://jar-download.com/online-maven-download-tool.php OBS: msal4j 1.15.x versions was found NOT to work.Paste XML and click Submit.Next page, click "Download Project"--------------------------<dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>mssql-jdbc</artifactId><version>12.6.2.jre11</version></dependency><dependency><groupId>com.microsoft.azure</groupId><artifactId>msal4j</artifactId><version>1.14.3</version></dependency>-------------Unzip jar_files.zip to: C:\Program Files\KNIME\drivers\mssql_msal4jIn KNIME:File -> Preferences. Search for "Databases" located under KNIME. Click Add.* ID: mssql_msal4j* Database type: mssqlserver* Name: Azure SQL Server* URL Template: Keep: jdbc:sqlserver://<host>:1433;databaseName=[database]* Add file and point to mssql-jdbc-12.6.2.jre11.jar in C:\Program Files\KNIME\drivers\mssql_msal4j* Add directory and point to folder. C:\Program Files\KNIME\drivers\mssql_msal4j* Click "Find driver classes". Verify: "com.microsoft.sqlserver.jdbc.SQLServerDriver"Use the node: Microsoft SQL Server Connector:Select the driverAzure: Hostname: X.database.windows.netPower BI Fabric: x.datawarehouse.fabric.microsoft.com, Port: 1433Authentication: None/native authenticationFabric use USING SAM = JDBC Parameters: Name:Valueauthentication:ActiveDirectoryInteractiveOptional JDBC Parameters - Optional: Name:Valueencrypt:truehostNameInCertificate:*.datawarehouse.fabric.microsoft.com (or *.database.windows.net)loginTimeout:30trustServerCertificate:false Optimera_Recurrence_Integration_STG * https://learn.microsoft.com/en-us/rest/api/cosmos-db/access-control-on-cosmosdb-resources * https://learn.microsoft.com/en-us/rest/api/cosmos-db/query-documents * https://stackoverflow.com/questions/75595198/how-can-we-select-one-or-more-cosmos-documents-using-postman Azure Cosmos DB accountMaster keyGet DatabaseQuery DocsQueryNode 55 StringConfiguration StringConfiguration GET Request POST Request Generate Auth ContainerInput (JSON) Column Appender Generate Auth Azure driver: You need JDBC driver minimum version 9.2 together with MSAL4J.mssql-jdbc. MS SQL JDBC: https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbcmsal4j. Microsoft Authentication Library for Java: https://mvnrepository.com/artifact/com.microsoft.azure/msal4jDownload via: https://jar-download.com/online-maven-download-tool.php OBS: msal4j 1.15.x versions was found NOT to work.Paste XML and click Submit.Next page, click "Download Project"--------------------------<dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>mssql-jdbc</artifactId><version>12.6.2.jre11</version></dependency><dependency><groupId>com.microsoft.azure</groupId><artifactId>msal4j</artifactId><version>1.14.3</version></dependency>-------------Unzip jar_files.zip to: C:\Program Files\KNIME\drivers\mssql_msal4jIn KNIME:File -> Preferences. Search for "Databases" located under KNIME. Click Add.* ID: mssql_msal4j* Database type: mssqlserver* Name: Azure SQL Server* URL Template: Keep: jdbc:sqlserver://<host>:1433;databaseName=[database]* Add file and point to mssql-jdbc-12.6.2.jre11.jar in C:\Program Files\KNIME\drivers\mssql_msal4j* Add directory and point to folder. C:\Program Files\KNIME\drivers\mssql_msal4j* Click "Find driver classes". Verify: "com.microsoft.sqlserver.jdbc.SQLServerDriver"Use the node: Microsoft SQL Server Connector:Select the driverAzure: Hostname: X.database.windows.netPower BI Fabric: x.datawarehouse.fabric.microsoft.com, Port: 1433Authentication: None/native authenticationFabric use USING SAM = JDBC Parameters: Name:Valueauthentication:ActiveDirectoryInteractiveOptional JDBC Parameters - Optional: Name:Valueencrypt:truehostNameInCertificate:*.datawarehouse.fabric.microsoft.com (or *.database.windows.net)loginTimeout:30trustServerCertificate:false Optimera_Recurrence_Integration_STG * https://learn.microsoft.com/en-us/rest/api/cosmos-db/access-control-on-cosmosdb-resources * https://learn.microsoft.com/en-us/rest/api/cosmos-db/query-documents * https://stackoverflow.com/questions/75595198/how-can-we-select-one-or-more-cosmos-documents-using-postman Azure Cosmos DB accountMaster keyGet DatabaseQuery DocsQueryNode 55 StringConfiguration StringConfiguration GET Request POST Request Generate Auth ContainerInput (JSON) Column Appender Generate Auth

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: TESC
Created at: 2024-10-29
On NodePit since: 2024-11-01
Last update: 2024-11-21
Created with KNIME version: v5.2.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!