Skip to main content
1-Visitor
March 9, 2022
Solved

Extensions/services for working with databases

  • March 9, 2022
  • 2 replies
  • 1848 views

Hi!

 

I have previously worked with ThingWorx Edge ADO Service and connected to Excel-spreadsheet to get some information.

 

Now this extension, as I understand it, is no longer available, so I can't download and install it on my new computer.

 

What other extensions/services can be used for the above task? That is, speaking more broadly - for remote access and collecting data from certain database (including Excel)?

Best answer by VladimirN

 Hi,

 

Have a look at these articles:

2 replies

VladimirN24-Ruby IIIAnswer
24-Ruby III
March 9, 2022

 Hi,

 

Have a look at these articles:

1-Visitor
March 21, 2022

Thanks!

24-Ruby III
March 21, 2022

You're welcome.

19-Tanzanite
March 21, 2022

Hi @Mr_Henry_M ,

While the generic approach to build an extension or edge implementation can be obviously used beware of two other paths:

-the Database ThingTemplate, which allows you to connect to any JDBC compatible DB - if you have network access from ThingWorx's direction

-the Kepware's ODBC client driver, which allows you to deploy Kepware to a (Windows) computer, connect it to ThingWorx, then configuring the ODBC driver via DSN to read an excel file, etc, basically whatever is defined through DSN.https://www.kepware.com/getattachment/5db91cc5-7a93-4979-87d6-947f75eb6b94/odbc-client-manual.pdf It's 500$/year, but still, configuration only, supported, and no coding 😉

1-Visitor
March 22, 2022

Hi!

Ok, thank you for information.