cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

how data from devices is captured, stored, and searched?

YS_10134308
10-Marble
10-Marble
‎Jan 24, 2022 11:55 PM
‎Jan 24, 2022 11:55 PM

how data from devices is captured, stored, and searched?

Hello ,

I am new to Thingworx and exploring certain things , i want to know how data from devices is captured, stored, and searched , modified and then displayed on the mashups.

Also I am using Azure SQL as my external database. how to capture the data which is generated by device in a specific interval of time.

 

Regards

0 Kudos
Notify Moderator
3 REPLIES 3
PaiChung
22-Sapphire I
22-Sapphire I
(To:YS_10134308)
‎Jan 25, 2022 12:45 PM
‎Jan 25, 2022 12:45 PM

If you haven't gone through the ThingWorx foundation classes/learning paths yet, I highly recommend those.

In ThingWorx first you would define a model which can capture your desired information. That information can be brought into ThingWorx in a variety of ways, Edge Agent like Kepserver, Rest API or connectors to other systems.

Data can be stored in ThingWorx as Properties, DataTables, or Streams each of these would have their own way (services) to read/search/modify

Mashups are then created to interact with the Model through those services.

For external databases, you can install as an extension (or directly by adding the right jar) jdbc drivers to connect to them. Within ThingWorx there is a 'Database' ThingTemplate which can then be configured to use the driver to connect.

Data generated at a specific interval can either be pushed by the device to ThingWorx as needed, or fetched by ThingWorx using a Timer/Scheduler mechanism.

You are asking quite a lot of very good questions that I think will be better answered by going through the foundation classes. Please check www.ptcu.com 

Notify Moderator
PT_10116336
7-Bedrock
7-Bedrock
(To:PaiChung)
‎Jan 25, 2022 12:52 PM
‎Jan 25, 2022 12:52 PM

Thanks for the detailed answer , can you tell me how we can fetch data by thingworx using a Timer/ Scheduler mechanism?

0 Kudos
Notify Moderator
slangley
23-Emerald II
23-Emerald II
(To:PT_10116336)
‎Feb 02, 2022 02:45 PM
‎Feb 02, 2022 02:45 PM

Hi @PT_10116336

 

As Pai stated, it's recommended that you complete the trainings.  You will find there are multiple ways to handle the data push and you should develop an understanding of the options before jumping into a particular method that may turn out to be inefficient or error prone.  The training covers timers and schedulers, and device connectivity as well.

 

Regards.

 

--Sharon

Notify Moderator
Top Tags