PLM Windchill: Locating the SQL Database Table for Attached PDFs

[ozclkonur]

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.

[HelesicPetr]

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

[Marco_Tosin]

How are Representations stored in the database and how are EPMDocuments linked to them in Windchill PDMLink

[avillanueva]

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

[Fadel]

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 

[Marco_Tosin]