Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
March 22, 2019
Solved

Map connection host name with sql in the the server

  • March 22, 2019
  • 1 reply
  • 1163 views

Hi,

Is it possible to connect the thingworx in one server with the sql in another server? And is it possible to upload files like excel/images from other server to our local system?

 

Thanks,

Shalini V.

Best answer by PaiChung

To directly connect to databases we use jdbc drivers. You add those as extensions and the database to connect to is defined as an IP so yes it is possible to connect to databases on different machines.

 

For uploading files, we have File Transfer between Thingworx Servers and Thingworx Agent to Server.

There is also client to server file upload widget

You can use a REST API call (not as efficient)

You can install extensions like the FTP extension.

1 reply

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

To directly connect to databases we use jdbc drivers. You add those as extensions and the database to connect to is defined as an IP so yes it is possible to connect to databases on different machines.

 

For uploading files, we have File Transfer between Thingworx Servers and Thingworx Agent to Server.

There is also client to server file upload widget

You can use a REST API call (not as efficient)

You can install extensions like the FTP extension.

Terms & ConditionsAccessibility statement