Extensions/services for working with databases

[Mr_Henry_M]

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

[VladimirN · Accepted solution]

 Hi,

Have a look at these articles:

• "Unable to find ThingWorx ADO Service for download": https://www.ptc.com/en/support/article/CS349617 
• "ThingWorx Edge ADO Service": https://www.ptc.com/en/support/article/CS360171 

[Mr_Henry_M]

Thanks!

[VladimirN]

You're welcome.

[VladimirRosu]

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

[Mr_Henry_M]

Hi!

Ok, thank you for information.