Skip to main content
ozclkonur
14-Alexandrite
Dec 13, 2023 7:22 AM UTC
Question

PLM Windchill: Locating the SQL Database Table for Attached PDFs

When I attach a PDF to a CAD document in PLM Windchill, I need to find out in which table of the SQL database it is stored. I want to directly add PDFs to that table using my own interface program. Can someone who knows where the PDFs attached with Attachment are stored in PLM's SQL database tell me? This way, I can retrieve that table in SQL and use it.

5 replies

HelesicPetr
22-Sapphire II
Dec 13, 2023 7:32 AM UTC

Hi @ozclkonur 

 

The table is ApplicationData but it is not so easy as you think 😄

There are many connections linked to EPMDocument(ContentHolder),ApplicationData, DataFormat and FileVault 

 

PetrH

Translate
avillanueva
23-Emerald II
Dec 13, 2023 3:39 PM UTC

Is this part of a data load? PDFs can be generated off CAD data which is preferred process. 

Importing is documented here:

https://support.ptc.com/help/wnc/r12.1.1.0/en/index.html#page/Windchill_Help_Center/WVSLoader/WindchillVisualizationServerLoader.html

 

Translate
Fadel
23-Emerald II
Dec 14, 2023 2:02 PM UTC

take  a look at the SQLs in https://www.ptc.com/en/support/article/CS302063 , they will give an idea  on joins between applicationdata , holdertocontent and wtdocument 

 

Translate
Buiꓘa
MarcoTosin
21-Topaz II
Dec 14, 2023 2:05 PM UTC

Marco_Tosin_0-1702562717426.png

 

Translate
Marco