Skip to main content
4-Participant
February 22, 2024
Question

data extraction from external system.

  • February 22, 2024
  • 2 replies
  • 3893 views

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.4

We need to extract part structure and associated EPMDocument and content from structure though external system.
We saw that we can retrieve information from structure through WebService but we cannot extract primary content of EPMDocument (we are using Creo CAD Data). Is there a way to do it without customization of Windchill ?

2 replies

16-Pearl
February 22, 2024

Hello,

 

So there are following ways to extract EPMDocuments data from Windchill.

 

1. Use Windchill bulk migrator 

2. Using creo to manually download it

3. Use Windchill extension https://windchill-extensions.ptc.com/get-view?wex-id=com.wincomplm.wex-cadquick.release&wc-version=WIND112 

 

Hope this helps. 

lvl_cap4-ParticipantAuthor
4-Participant
February 23, 2024

Hello,

 

Thanks for the answer, but unfortunately, all theses way require manual action. The aim there is to automate the extraction.

HelesicPetr
22-Sapphire II
22-Sapphire II
February 23, 2024

Hi @lvl_cap 

So you need some customization to automate your work. 

 

Also keep in mind, that any changes to a CAD Attributes, file names, names that are done in Windchill needs to be updated in the model by Workgroup manager. 

So if you download directly some CAD Model, it can contains not up-to date information. 

 

PetrH

18-Opal
February 23, 2024

The short answer is NO.

How would it ever be possible for an external application to pull data from Windchill without a customization? 🤷‍♂️
Think about it, you have some (unnamed) application. It has zero knowledge that Windchill is even a thing, let alone the ability to pull data.

 

Isn’t this a customization of the external app that’s pulling the data from Windchill. Not a Windchill customization.



lvl_cap4-ParticipantAuthor
4-Participant
February 23, 2024

Here my constraint is to not impact, customize the existing Windchill system, the external application is a fully customized app, so odata Web services was an option to retrieve data, but for the CAD elements we can't do it through Web Services for example so I need to find another solution.

 

Let's say the only way is to customize Windchill, what your recommandation ?

 

Thanks in advance for your answer.

18-Opal
February 23, 2024

You need to hire someone who knows Windchill and the Windchill database inside and out.

And also knows how to connect to database.

From there a JDBC to the Windchill database can be made from the external app with sql calls to get whatever you want.


 Find someone who knows what they are doing and pay them to set this up.