I tried to use JDBC Connector extension in Thingworx to connect to an external MSSQL server (to read data into Thingworx) via Windows Authentication (Integrated Security = SSPI). On the configuration section, I have tried append the connection string with "Integrated Security = SSPI" and leaving the username and password as blank, but it didnt help.
JDBC Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection string: jdbc:sqlserver://localhost;databaseName=AdventureWorks2012;Integrated Security=SSPI
connectionValidationString: SELECT GETDATE()
Anyone can shed some light on how to connect via Windows Authentication in JDBC Connector?
*Have tried using MSSQL Relational Database Connector and still could not get it work.