Thingworx Reading Data from Azure SQL Database

[vieirac1]

Hello Team,

I have a very simple database configured at Azure SQL and want to read data from it in my TWX instance,

I have imported the Relational Database extension from Labs, created a MSSQLServer thing and configured my JDBC as below:

jdbc:sqlserver://vieiraserver.database.windows.net:1433;database=VieiraDB2;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

But no matter what, I can´t get to connect.

Please, any ideas?

Tks,

Chris

[PaiChung]

What messages are you seeing in the application log?

Also that db address is the address that Azure is providing for you?

windows.net vs. azure.com

[vieirac1]

Had to configure Azure firewall allowing my thingworx server to connect - all good now, thanks a lot