Hello everyone,
I have good news for you. With the next release of the KNIME Analytics Platform, which is planned for summer, the Microsoft SQL Server Connector will support disabling of transactions. Once disabled you can use it to connect to a serverless SQL pool in Azure Synapse. After the release you can disable transactions by unselecting the Enable flag in the Transaction section of the Advanced tab as shown here:
We will also add a section about this to the database documentation once it is released.
It would be great if you could give it a try and provide feedback. To do so download the nightly build and disable transactions in the Advanced tab.
Bye
Tobias