Skip to main content
1-Visitor
Jul 20, 2016 8:10 PM UTC
Question

extracting values from an SQL database to feed BOM table in CREO

Hello,

I am trying to extract information from information that will reside in an SQL database.  I want to get specific values (material information, inventory number & description information) to populate categories in a BOM table.

I'm know that is what WindChill is for, but my company is committed to a different ERP program, and the same is true for its PDM system.

I assume its something like a config file option to extract the information, but I am hoping someone can help me out with the specifics.  I know this is a 100,000 foot question, but I am a noob to the admin side, I've always been the user; I am in a setup role and trying to learn how to make this work.

We have CREO 3.0 M090.

My ERP system is from ABAS (German company?), called EKS

My PDM system is from PROCAD, call PRO.FILE (it is not a PTC product, rather from some company called PROCAD)

Any help anyone can offer would be greatly appreciated.

Thank you,

Brian Williams


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

10 replies

2-Explorer
Jul 21, 2016 12:28 AM UTC

Sounds like you need to check this out: SQL Tutorial

Translate
1-Visitor
Jul 21, 2016 5:55 PM UTC

OK, I will check that out.

Is there another tutorial on how to get CREO to pick up the SQL stuff?  I'm thinking it must be a relation you have to create.

Thank you for your help David.

Translate