Map connection host name with sql in the the server

[svisveswaraiya]

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.

[PaiChung · Accepted solution]

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.