Skip to main content
Nov 8, 2018 4:02 PM UTC
Solved

How to include a remoteDatabase thing to Asset Adviosr equip list?

How to include a remoteDatabase thing to  Asset Adviosr equip list?

 

How to put a RemoteDatebase Thing , to be showed in the equipment lists in Asset Advisor, Production Advisor?

The background is, the remote thing is an equipment with Microsoft Access Database, and we can get all necessary OEE parameters from it easily.

 

I have tried Kepware to connect to the access database , but it has a lot of issues on SQL query and datetime calculation logic. ------> Kepware is not OK here.

so I established a RemoteDatebase thing, resp this equipment ,based on Thingworx EMS ADO services solution. And finally I can get the properties of the equipment in Composer.-----> OK to get properties with EMS solution.

 

However, the only issue now is,  I can't get this equipment showed in the Asset Advisor, Production Advisor, because it is based on the RemoteDatebase ThingTemplate(not PTC.ISA95.PhysicalAssetThingTemplate)...

hchananaAnswer
Nov 12, 2018 8:27 AM UTC

Hi @szuo-2,

 

You could implement same ThingShapes that are on the PTC.ISA95.PhysicalAssetThingTemplate .

This would also give you fine grained control over what data you want on the Remote database.

 

Thanks,

Himanshu

4 replies

hchananaAnswer
Nov 12, 2018 8:27 AM UTC

Hi @szuo-2,

 

You could implement same ThingShapes that are on the PTC.ISA95.PhysicalAssetThingTemplate .

This would also give you fine grained control over what data you want on the Remote database.

 

Thanks,

Himanshu

szuo-2Author
Nov 12, 2018 9:43 AM UTC

Thank you.

Is this solution Thingworx version based? The Thingworx MFG APP version I used is 8.1.x. I have tried a customized remote database template, with all PTC.ISA95.PhysicalAssetThingTemplate Thingshape, however,  I didn't get the expected new asset type in the drop down list when I create the asset in MFG APP's Administration page...

 

Now my solution is, i create two things for this approach: One is created based on remoteDatabase template, one is created by MFG APP(based on PTC.ISA95.PhysicalAssetThingTemplate) .And then I bind the properties of them... it seems a solution, but maybe not a good option .