Skip to main content
S
szuo-21-Visitor
1-Visitor
November 8, 2018
Solved

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

  • November 8, 2018
  • 1 reply
  • 4575 views

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)...

Best answer by hchanana

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

1 reply

H
hchanana16-PearlAnswer
16-Pearl
November 12, 2018

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

S
szuo-21-VisitorAuthor
1-Visitor
November 12, 2018

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 .

Terms & ConditionsCookie settingsAccessibility statement