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

[cazares]

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?

[vranganathan]

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

[cazares]

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.

[vranganathan · Accepted solution]

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

[stmarchessault]

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