Skip to main content
K
KBB_doodle1-Visitor
1-Visitor
October 27, 2022
Solved

Large data extraction (dump) from Windchill - for data cleansing to SAP BODS (data comparison)

  • October 27, 2022
  • 1 reply
  • 2854 views

Has anyone experience with extracting data from Windchill (WT.Parts/BOM Structures) and Attributes?   What tools did you use that could make this process of extraction streamline and/or efficient?   My company is in the process of migrating from our legacy MRP to SAP ECC/ERP/MRP.    This data dump will be in the hundreds of thousands of Material Masters/WT.parts and related BOMs.  

 

Thanks in advance.

Kayle Brock

Best answer by MarcoTosin

Kayle,
as Antonio said, through the query builder reports you can extract the data you need from Windchill.

 

As far as WTParts are concerned, you should not have big problems, while for BOMs it is more complicated because, without creating a Java method to be used within the report, you cannot extract a recursive BOM, but only at the first level.

 

This PTC support document lists a number of ready-to-use reports

 

https://www.ptc.com/en/support/article/CS328887

 

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
October 28, 2022
I did this via SQL but query builder could work since it’s easy to get to excel. Expect to have to do this many times with current data so hone your steps. Compare BOMs single level only not has multilevel structure. Do have a consulting partner?

Sent from my iPhone
K
KBB_doodle1-VisitorAuthor
1-Visitor
October 28, 2022

Thanks Avillanueva.   No, not yet - on consulting partner.   I have reached out to PTC for assistance.   Ideally,  a connector to our Windchill db would probably be even better - live feed.   This would require access and may be an uphill battle.

MarcoTosin
21-Topaz I
MarcoTosin21-Topaz I
21-Topaz I
October 28, 2022

Can you clarify more about the situation you are in now?

 

You write that you have an ERP system but want to import data from Windchill into the new SAP ECC system.

 

Have you been using BOMs from Windchill to produce until now?

 

Normally exactly the opposite is done.

 

We have been using SAP ECC since 2001 and Windchill since 2006, so we have imported the material master records, bills of materials, and process plans (in successive steps years apart) from the ERP to the PLM

 

The two systems are now connected together, one-way from Windchill to SAP, via Tibco

 

https://support.ptc.com/help/wnc/r12.0.2.0/en/#page/Windchill_Help_Center%2FESITechOverview_2.html

 

 

Marco
Terms & ConditionsAccessibility statement