Skip to main content
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

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

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

 

3-Newcomer
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 

 

1-Visitor
Dec 14, 2023 2:05 PM UTC

Marco_Tosin_0-1702562717426.png