Skip to main content
5-Regular Member
April 30, 2019
Solved

How to retrieve Windchill data and store it in PostgreSQL tables with Operator Advisor?

  • April 30, 2019
  • 1 reply
  • 1590 views

Hello!

         I'm in the process of learning Operator Advisor. Now I can connect to  Windchill  through Odata Connector, but I don't how to  store MPMlink data in PostgreSQL tables ,maybe I misunderstood it.  I wonder how the data in postgresql datasheet comes . Could you give me some examples or demos about OA ?

        Thanks a lot.

Best answer by hchanana

Hi @Bacca ,

 

You can use the ConvertFromProcessPlanId service available under PTC.SCA.SCO.MPMLinkWorkDefinitionConverter. This service fetch all process plan definitions and their related information from a Windchill process plan identifier, and puts them into the Operator Advisor database.

 

Thanks,

Himanshu

 

If my response has answered your question, please mark as Accepted Solution, for the benefit of others who may have the same question.

1 reply

hchanana16-PearlAnswer
16-Pearl
May 1, 2019

Hi @Bacca ,

 

You can use the ConvertFromProcessPlanId service available under PTC.SCA.SCO.MPMLinkWorkDefinitionConverter. This service fetch all process plan definitions and their related information from a Windchill process plan identifier, and puts them into the Operator Advisor database.

 

Thanks,

Himanshu

 

If my response has answered your question, please mark as Accepted Solution, for the benefit of others who may have the same question.