Skip to main content
R
RS_99630791-Visitor
1-Visitor
June 14, 2021
Solved

Transfer data collected from value stream over to Analytics Builder

  • June 14, 2021
  • 1 reply
  • 10855 views

Hi, I'm pushing data from a device up to Thingworx and storing it in a value stream. I'm able to display this data in a mashup widget through using the QueryPropertyValue service and was wondering if there was a way to utilize this service in order to send this value stream data straight over to the Analytics Builder.

I want to perform analytical models on this dataset, but don't know any other ways to upload data to analytics other than uploading a CSV file from my PC

Best answer by nsampat

@RS_9963079 ,

 

1. You will need to note the model ID or Dataset ID returned when you create the dataset or model. You access the data/model through the services which will output in JSON. You can retrieve the dataset using the services. You wont se the CSV in the Builder either, as we ingest the dataset and transform it to fit the storage method (in the latest version of ThingWorx Analytics its stored in Apache Parquet on the server File System)

 

You can read more about the ThingWorx Analytics Architecture here: https://www.ptc.com/en/support/article/CS243525

 

2. This is dependent on which version of ThingWorx Platform Server, and ThingWorx Analytics you are using. I have provided documentation for 9.0/9.1 above

 

I should mention that we are now entering a solutions discussion which is not something I can assist you with from Technical Support process.

 

Have you leverage the training modules on PTC Developer Zone? You can find the ThingWorx Analytics Modules here: https://developer.thingworx.com/en/platform/analyze

 

Regards,

 

Neel

 

1 reply

N
nsampat17-Peridot
17-Peridot
June 14, 2021

Hello @RS_9963079 ,

 

Can you provide some more information regarding the streaming of data? Typically Analytics Builder requires the use of the flat file, but there are means to score against streaming data using the PredictionThing services or creating Analysis Events

 

https://support.ptc.com/help/thingworx/analytics/r9/en/#page/analytics%2Fanalysis-services%2FAnalysisServices_AnalysisEventsManage.html%23

 

Is this something you are sending as a Time Series / Real-Time Scoring use case?

 

Regards,

 

Neel

R
RS_99630791-VisitorAuthor
1-Visitor
June 15, 2021

I'm taking data (not necessarily time series) from a sensor and pushing that up to ThingWorx through an API call where I'm able to update property values in real-time. The idea is to collect x amount of data into a value stream/infotable, move it over to Analytics, and then create a model. 

It would be great if I could score future data against the model I create. 

N
nsampat17-Peridot
17-Peridot
June 15, 2021

@RS_9963079 ,

 

Create a model via services for your use case is possible, but will require use of the ThingWorx Analytics APIs or Analytics Manager with some additional setup.

 

By default, ThingWorx Analytics Builder expects a CSV file.

 

We have another Community Topic around Real-Time Scoring that may work for your use case:

 

https://community.ptc.com/t5/IoT-Tech-Tips/How-to-score-new-data-with-ThingWorx-Analytics-8-3-x/td-p/571051#realTime

 

Please note, even though this is for an older version of ThingWorx Analytics, the method and principles have not changed significantly. Also, ThingPredictor has since been deprecated and its functionality has been rolled into Predictive Scoring Microservice in ThingWorx Analytics Server.

 

Please let me know if that topic helps.

 

Regards,

 

Neel

Terms & ConditionsAccessibility statement