Skip to main content
S
ssadula1-Visitor
1-Visitor
September 16, 2016
Question

Regarding Windchill data storage and data models for CREO

  • September 16, 2016
  • 1 reply
  • 4275 views

Hi there,

I just need some info regarding the data storage and data models in Windchill.

since lone time, we have been using Windchill and CREO to save CREO part, assy and drawings.

now I need to migrate some of CREO models from another system to Windchill.

but I don't how to do that.

Is there any way to see the data models for CREO data?

For e.g.:

If I create 3d model and save it in Windchill, how it's being saved inside oracle database.

Assy-1

|------Part1

|------Part2

    |--------drawing2

|------Drawing-1

where metadat is stored?

What're the different connections? how they're stored in database

how physical files being stored?

I really appreciate if you would suggest something.

Also, let me know if there is any tool that I can use to see the data models in Windchill.

Thanks In adv.

1 reply

B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
September 16, 2016

The CAD files themselves are not stored in Windchill/Oracle unless it was configured improperly, in which case the CAD files are stored as BLOBs in the Oracle database.

The CAD files should be stored in external file vaults on your Windchill server and all metadata is stored in Oracle on another server. The Oracle data includes the relationship information between files as well as their physical location in the external vaults.

To import Creo models and drawings into Windchill is easy. Create and activate a new workspace in Creo and then Open the files from their disk location and save them. The save will be into your workspace. From there the files may be checked in to the Windchill common space. I would start by importing part files first, then assemblies and finally the drawings. Windchill files must be unique so be sure the imported files do not have the same name as the ones already in Windchill.

To learn more about the structure of Windchill, read the system administration manuals.

S
ssadula1-VisitorAuthor
1-Visitor
September 16, 2016

Hi Ben,

thanks for the reply.

Yes, the CAD files are saved in the physical locations in the external vault and meta data is saved in Oracle database.

Thing is, I need to import data from other system which has alomst 15GB CAD models, it's huge.

I can't save them manually one by one. I need to write some script by using Windchill API and create metadata for CAD models and checkin files into external vault.

but, I don't know anything about Windchill, that's why I need some guidelines to know how to proceed.

Also, I need to build some intgration to send CAD model attributes to ERP system from Windchill

So, I need to analyse complete data models in Windchill for parts, assy and drawings, so that I can write something by using Windchill API.

Could you please suggest?

I'm only concerned about below things in Windchill:

1) CAD models - Part, assy

2) drawings

3) Workspaces

4) attributes

5) links between parent and sub parts

Could you give some API methods and database tables how these data is stored?

Thanks In Adv

B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
September 16, 2016

I am not the person for doing scripts but there is a bulk loader module used to populate Windchill from other systems.

Here are some links that may help.

Consolidating Systems in PTC Windchill: Performing Bulk Data Migration

How-to use the Bulk Load functionality

Terms & ConditionsAccessibility statement