Skip to main content
G
Gizem_Turan1-Visitor
1-Visitor
August 11, 2020
Question

Thing Property used in SQL Server and SSRS

  • August 11, 2020
  • 1 reply
  • 3153 views

Hello,

 

we want to use SSRS Reporting to link the Reports in mashups in ThingWorx.

Therefore we want to Access property values of Things in SQL Server, to be able to create queries. Is that possible? Is there a SQL CLR Option for ThingWorx for example?

The data of the Thing properties will come from our PI Connector.

 

Thank you in Advance!

Regards,

Gizem

1 reply

R
rjanardan16-Pearl
16-Pearl
August 11, 2020

It seems SSRS can consume REST API. You can probably create a datasource utilizing the ThingWorx REST API to get the property values from TWX to SSRS. 

G
Gizem_Turan1-VisitorAuthor
1-Visitor
August 11, 2020

Hello,

 

thank you for the quick answer. I have found out that via a http REST call I can get the property values of a specific Thing. But how can I integrate this REST call into SSRS? I could not find a way to configure a datasource with a REST call.

 

And another question; does ThingWorx support something like SQL CLR? To create e.g. functions in SQL Server by using property values of ThingWorx Things?

 

Thank you!

R
rjanardan16-Pearl
16-Pearl
August 11, 2020

Probably on ThingWorx side you could write a service that compiles all the required property values and outputs it in the required format let's say xml or JSON. Then you could make rest calls to this service instead of fetching individual properties values.

Probably, this video(not  from PTC) could be helpful in configuring datasource with a REST call. 

Terms & ConditionsAccessibility statement