How to connect Thingworx with Mathcad

[Janaki.Raman]

Hi,

I have a requirement for integrating Thingworx and Mathcad, mathcad has some fixed calculations, for that input should be passed from Thingworx mashup and result should also get captured back to mashup.

do we have any available solution at PTC?

how can i start with this?

thanks,

John

[VladimirN]

Similar discussion - "Adding Mathcad to TW": https://community.ptc.com/t5/ThingWorx-Developers/Adding-Mathcad-to-TW/td-p/505233 

[Janaki.Raman]

Hi @VladimirN 

Is there a document available for this? which can tell us the available methods to understand more.

We don't want to open the worksheet window, instead we are looking for option that could directly apply inputs to the sheet and retrieve the results. Because, the operation possibly be executed parallelly by users, if one opens the sheet then others may fail with their operation(calculation).

What is the other approach was mentioned in the above post?

thanks,

John

[VladimirRosu · Accepted solution]

Hi @Janaki.Raman 

Applying the inputs directly to the worksheet is not possible, because the worksheet itself does not contain the calculation engine.

That engine is entirely in Mathcad, so you'd need to open the worksheet in it to perform the actual calculation.

In your situation (parallel users), the solution is to open a different worksheet file, but which.

Instead you can consider the original worksheet as a "template" of sorts, based on which you create temporary copies that would be deleted after results are being sent back to ThingWorx. These copies would have a very limited lifetime - seconds. These temporary copies should have as filename a sort of unique identifier: "1233-13232-abacdef-34343OriginalWorksheet.mcdx".

Hope it helps.

[vnamboodheri]

Hello @Janaki.Raman, 

It looks like you have some responses from some community members. If any of these replies answered your question please mark the appropriate 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,
Vivek N.
Community Moderation Team.