Skip to main content
C
cazares5-Regular Member
5-Regular Member
September 15, 2017
Solved

How can I configure the Manufacturing Apps, using data from a database?

  • September 15, 2017
  • 2 replies
  • 3649 views

I need to configure the Asset Advisors for one of our clients, but the data that they provide is comming from a SQL database. What should be the process to obtain and configure this data to the Manufacturing Advisors?

Best answer by vranganathan

Open up the PTC.Factory.StatusExpressionResourceProviderTemplate teample. You will see CustomizedQualityCalculation under services. You need to override this service. This will have reference to your asset as input. In this service you will query the external database for Good count and Total count during the given calculation window. Calculate the quality metric and return the calculated quality. I believe you need to return as fraction and underlying code will convert into percentage. I hope this helps.

Thanks,

Varathan

2 replies

V
vranganathan12-Amethyst
12-Amethyst
September 15, 2017

Hi Alan,

Can you be more specific on what data? Asset Advisor is targeted towards the Maintenance Engineer. The Machine status and alerts should come from the machine itself. If you are talking about Production Advisor, you can get the Quality data, ideal run rate, etc. from ERP system or another database.

There are services available which allows you to plugin your logic and overrides the OOTB behavior. The customization guide lists those services. I am more than happy to answer any follow up questions.

Thanks,

Varathan

C
cazares5-Regular MemberAuthor
5-Regular Member
September 15, 2017

Yes, I am talking specifically about the the "Good Parts", "Total Parts" and "Production rate" to configure OEE. They are found in one of the clients databases SQL and I would really like to understand what the process to get this data to the Manufacturing Advisors would be. I would really appreciate some help.

V
vranganathan12-AmethystAnswer
12-Amethyst
September 15, 2017

Open up the PTC.Factory.StatusExpressionResourceProviderTemplate teample. You will see CustomizedQualityCalculation under services. You need to override this service. This will have reference to your asset as input. In this service you will query the external database for Good count and Total count during the given calculation window. Calculate the quality metric and return the calculated quality. I believe you need to return as fraction and underlying code will convert into percentage. I hope this helps.

Thanks,

Varathan

S
stmarchessault5-Regular Member
5-Regular Member
October 4, 2017

Greetings Alan Cazares Sanabria,


Following up with you on the original question posted here, can you please indicate if the recommendations given by Varathan on 15 Sept answered this for you?


If this adequately answered your question, please mark the reply as the "Correct Answer."


Or, if you are still unresolved on your original question, let us know and we can continue troubleshooting this with you. This feedback is a key step toward ensuring Community users with a similar issue are able to locate the information they need.



Best regards,

Steven M

Terms & ConditionsAccessibility statement