Skip to main content
V
vieirac110-Marble
10-Marble
March 22, 2019
Question

Thingworx Reading Data from Azure SQL Database

  • March 22, 2019
  • 1 reply
  • 1292 views

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

1 reply

P
PaiChung22-Sapphire I
22-Sapphire I
March 22, 2019

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

V
vieirac110-MarbleAuthor
10-Marble
March 25, 2019
Had to configure Azure firewall allowing my thingworx server to connect - all good now, thanks a lot
    Terms & ConditionsAccessibility statement