Skip to main content
Aug 11, 2020 9:28 AM UTC
Question

Thing Property used in SQL Server and SSRS

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

8 replies

Aug 11, 2020 11:40 AM UTC

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. 

Aug 11, 2020 1:17 PM UTC

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!

Aug 11, 2020 2:30 PM UTC

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.