Skip to main content
I
IanWexler1-Visitor
1-Visitor
March 20, 2014
Solved

Database Table Structure

  • March 20, 2014
  • 1 reply
  • 6544 views

Is there a mapping or list of the tables for Windchill 10? We are implementing an ERP system and want to have the system grab data from Windchill so as to enter the data only once. Any help in pointing me to some data would be appreciated.

Ian Wexler

Best answer by MikeLockwood

http://www.ptc.com/product/windchill/enterprise

Very mature software for communicating with ERP systems. Can use "open ended" to just output files if desired.

This takes care of all needed relative to extracting objects rather than database table info.

1 reply

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
March 20, 2014

Don't even consider going down that path. Use ESI instead.

D
dkahlon1-Visitor
1-Visitor
March 24, 2014

Why not?

We are also looking at 'interfacing' Windchill (as ready-only of course) with other systems - not just ERP.

Even reporting - being 'pressured' into purchasing Cognos (at extra cost of course!) when we could simply use our existing Crystal Reports if we knew Windchill table structures.

I too would like to know more about ESI - is it another option that comes at a cost?

We have Windchill 10.1 M030 by the way.

S
SimonHeath1-Visitor
1-Visitor
March 25, 2014

I agree a full db description would be great to have, it is painful to work it all out especially in the more complex areas such a change and effectivity which are often important in ERP interfaces. Another trick is to create your report in Query Builder (aka report manager) this has some in built knowledge of the db structure and then export the QML. The QML contains sort of readable information to help you trace it onto the real tables.

Terms & ConditionsCookie settingsAccessibility statement