Skip to main content
Mar 9, 2022 11:09 AM UTC
Solved

Extensions/services for working with databases

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)?

VladimirNAnswer
Mar 9, 2022 12:58 PM UTC

 Hi,

 

Have a look at these articles:

5 replies

VladimirNAnswer
Mar 9, 2022 12:58 PM UTC

 Hi,

 

Have a look at these articles:

Mar 21, 2022 8:10 AM UTC

Thanks!

Mar 21, 2022 8:50 AM UTC

You're welcome.

Mar 21, 2022 7:33 PM UTC

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 😉

Mar 22, 2022 12:06 PM UTC

Hi!

Ok, thank you for information.