I have installed the Lite version for testing this scenario, get data from am mqtt broker and join data with a MS Sql Server table.
First I created the connection to the mqtt broker and it worked well, after I tried the same thing with an JDBC connection to MS Sql Server (2017) but it failed.
I wrote a simple Java code which tests the JDBC connection to MS Sql server and it works right.
I tried also the create a connection to a MySql istance with the same result. (failed)
Has someone tested the connection to Ms Sql Server? (or Mysql)