Skip to main content
O
ozclkonur14-Alexandrite
14-Alexandrite
December 13, 2023
Question

PLM Windchill: Locating the SQL Database Table for Attached PDFs

  • December 13, 2023
  • 4 replies
  • 1305 views

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.

    4 replies

    HelesicPetr
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    December 13, 2023

    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

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    December 13, 2023

    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
    Fadel23-Emerald I
    23-Emerald I
    December 14, 2023

    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 

     

    Buiꓘa
    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    December 14, 2023

    Marco_Tosin_0-1702562717426.png

     

    Marco
      Terms & ConditionsAccessibility statement