10-Marble

Solved

Use Thingworx API to store data in InfluxDB

Forum|Forum|1 year ago
May 28, 2024
3 replies
1877 views

hello,

I have Thingworx platform in my work place that uses Kepserver layer to collect data from machines , store it in MSSQL DB and then use Thingworx web application to visualize data.

I have the idea of using Grafana as visualization tool instead thingworx mash ups (more convenient to business) . What is the architecture suited to this need? I'm thinking about using API calls to populate an influxDB and then querry this DB in Grafana.

Any ideas on this ?

Thanks

Best answer by pshashipreetham

Hi @Lo_ry96,

I have done this before for another use case. Below are the steps:

Add Influx as the Secondary Persistence Provider in Thingworx
Create a value stream, while the creation of a Value stream selects the Secondary Persistence Provider instead of "ThingworxPersistenceProvider":
Then assign the value stream you have created to a Thing
Create the Properties and check the log while creating the Property
Once the Log is checked, when data comes to the property it gets stored in the Influx DB

Thanks,

V

VladimirN

24-Ruby III

Take a look:

"ThingWorx Performance Monitoring with Grafana": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Performance-Monitoring-with-Grafana/ta-p/818800
"ThingWorx Monitoring and Alerting: Using Prometheus and Grafana, Part 1": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Monitoring-and-Alerting-Using-Prometheus-and-Grafana/ta-p/845804
"ThingWorx Monitoring and Alerting: Using Prometheus and Grafana, Part 2": https://community.ptc.com/t5/IoT-Tips/ThingWorx-Monitoring-and-Alerting-Using-Prometheus-and-Grafana/ta-p/845847
"ThingWorx Performance Monitoring": https://www.youtube.com/playlist?list=PL69Ma82gzaTx2JnbrRY8qOQsCZaQUGOgl

L

Lo_ry96

Author

10-Marble

Hi thanks for shared info. Any ressources/ides on how to perform GET requests to fetch data from Thingworx? i'm turning around since a while as i'm starter to Thingworx platform so any guidance is appreciated

Many thanks

V

VladimirN

24-Ruby III

Some tips:

"Use REST API to Access ThingWorx Part 1": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-1/ta-p/825305
"Use REST API to Access ThingWorx Part 2": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-2/ta-p/825684
"Use REST API to Access ThingWorx Part 3": https://community.ptc.com/t5/IoT-Tips/Use-REST-API-to-Access-ThingWorx-Part-3/ta-p/826227
"How to use REST API on ThingWorx Platform": https://www.ptc.com/en/support/article/CS329281
"Use Thingworx Service as REST API": https://community.ptc.com/t5/ThingWorx-Developers/Use-Thingworx-Service-as-REST-API/td-p/931464

V

vnamboodheri

Community Moderator

Hello @Lo_ry96,

It looks like you have a response from a community member. If any of these replies helped you solve your question please mark the reply as the Accepted Solution.

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Community Moderation Team.

pshashipreetham

Answer

18-Opal

Hi @Lo_ry96,

I have done this before for another use case. Below are the steps:

Add Influx as the Secondary Persistence Provider in Thingworx
Create a value stream, while the creation of a Value stream selects the Secondary Persistence Provider instead of "ThingworxPersistenceProvider":
Then assign the value stream you have created to a Thing
Create the Properties and check the log while creating the Property
Once the Log is checked, when data comes to the property it gets stored in the Influx DB

Thanks,

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded