Skip to main content
J
Janaki.Raman11-Garnet
11-Garnet
May 16, 2024
Solved

How to connect external SQL database from Thingworx

  • May 16, 2024
  • 1 reply
  • 1483 views

Hi,

 

My Thingworx is cloud hosted 9.x version and am trying to connect a SQL database which is in our organization network, I failed to connect after all configurations. Do I need to create a tunnel access here to connect to the database? How can I connect?

 

Transaction has been marked as a failure for request /Thingworx/Things/RDBMSAccess_TH/Services/GetPropertyValuesAsMultiRowTable

 

thanks,

John

 

Best answer by Surya_Tiwari

Hi @Janaki.Raman  If you want to establish a connection from their PTC-hosted cloud environment to an on-prem resource, like a DB, they would need to log a cloud service request.  They will then be asked by the cloud team for the relevant connection details and from there, the cloud team will create the appropriate network security rules to allow the connection.

1 reply

S
Surya_Tiwari16-Pearl
16-Pearl
May 16, 2024

Hi @Janaki.Raman  

Kindly check the below article, and let us know your feedback on it.

https://www.ptc.com/en/support/article/CS318728

J
Janaki.Raman11-GarnetAuthor
11-Garnet
May 16, 2024

Hi @Surya_Tiwari 

 

My only question is, as am using Thingworx cloud which is hosted and managed by PTC and my database server is in our organization network, will this configuration still work even there are two different networks? without tunnel? or Do I need tunnel to be created?

 

 

thanks,

John

S
Surya_Tiwari16-PearlAnswer
16-Pearl
May 16, 2024

Hi @Janaki.Raman  If you want to establish a connection from their PTC-hosted cloud environment to an on-prem resource, like a DB, they would need to log a cloud service request.  They will then be asked by the cloud team for the relevant connection details and from there, the cloud team will create the appropriate network security rules to allow the connection.

Terms & ConditionsCookie settingsAccessibility statement