Hi,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)

Hi Sonam,I something is not clear.I did this:a) from the home page, I added a JDBC connection to MS Server. (as indicated in my first msg, the test failed)b) I created a workspace and into the workspace a message type to manage the MS Sqlserver query.c) I uploaded the jar file "mssql-jdbc-7.0.0.jre8.jar".d) I created the JDBC Channel which references the JDBC connection (created on the home page), the message type defined into the point b and the query to read data from MS Sqlserver. (i.e select * from table)into the JDBC wizard, I moved into the "view schema" tab but it returns "Given SQL Query either not valid or please specify schema/database Name along with table name in query"Here I stopped.

I suppose the issue is related the JDBC connection created (on the home page) which failed.