ipazin
October 5, 2020, 9:54am
3
Hello @jvthomas21 ,
seems you have to use the official Microsoft SQL Server driver (that you need to install separately in KNIME due to license restrictions) in order to connect to Azure SQL Database.
Hello Haystack,
you can use the Microsoft SQL Server Connector node also to log into an Azure SQL Database which is basically a standard SQL Server in the cloud. Once connected you can use the standard DB nodes such as the DB Writer, DB Insert or DB Update node to push data into the database.
To obtain the JDBC connection information log into the Azure portal and select the database you want to connect to. Once the database is selected click on the Connection strings option in the left menu ba…
Br,
1 Like