×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ERP and PDM

ERP and PDM

ERP and PDM

(OP)
I read a post from DSI on the thread "Design Tables and How to Customize them" started by Scott Baugh.  I didn't want to get that thread off on some tangent, so I started this one.

My company has purchased WTC ProductCenter for our PDM solution (not implemented yet), but we are being forced to maintain several bits of information in multiple locations due to our seperate ERP system.  

Part Numbers
Raw Materials
Nomenclature
BoM Data
Process/Routings
Ect...

I was wondering what ERP systems are out there that are also Partners with SolidWorks?  Or, if none exist, how are you or your company dealing with this issue if you also have to maintain multiple bits of the same info.

"Happy the Hare at morning for she is ignorant to the Hunter's waking thoughts."

RE: ERP and PDM

MadMango:

Unfortunatly, the ERP system that is being implemented is not partnered with SolidWorks. They are an engineer to order manufacturer, so the data is actually driven from the design. They are not going to incorporate the design calculations into the ERP system because there are way too many exceptions that would cause problems. So, we have decided to keep the design automation separate. There is a separate database that stores the input data and calculated results for each design. I am going to develop several applications that will transfer the data from the model (SolidWorks and AutoCAD) into the ERP database.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: ERP and PDM

(OP)
We are currently using MK Manufacturing's ERP system, but it is very old (circa '96) in terms of software.  

Are you planing to export model data to your ERP system?  If so, it would be interesting to know what software you use, as the little research that I have done leads me to belive that our ERP system cannot import any data (though it will export some).

If my company could tie SWX data to the ERP system, it would save many man-hours for everyone. = )

"Happy the Hare at morning for she is ignorant to the Hunter's waking thoughts."

RE: ERP and PDM

I am going to write custom programs to extract and convert the BOM data from SolidWorks and AutoCAD drawings. The ERP system has an application called Transaction Manager that is used to import raw data and provides all of the validation necessary to populate the database with part information. All I have to do is extract the BOM data and put it into a flat file. Unfortunately, this extraction is going to be limited to parts and assemblies only. There will not be a dynamic link between the drawings and the ERP system, and the building of a "project" is going to have to be done manually. The only benefit of this is that all of the BOMs will not have to be retyped into the system. While the benefit seems quite limited, it will reduce errors in duplication and probably save a days work per project.

As far as populating an ERP system, there are many ways that this can be accomplished. Even though this system has an application to import data, you will, most likely, have root access to your database. Unfortunately, this will probably require some custom database programming. If you are trying to accomplish this, your first goal would be to find import abilities and database compatibility. If you can figure out this format, the rest is pretty easy.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: ERP and PDM

(OP)
Thanks for the info.  We seem to be in a similar boat, in that all we want to do is to reduce the chance of human error by not having to re-enter pre-existing data that is contained in the SWX models or the ProductCenter PDM package.

"Happy the Hare at morning for she is ignorant to the Hunter's waking thoughts."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources